The following scripts are included with Data Vault Service to facilitate setting up a database to receive the query statistics information:

To use the scripts, first connect to the database as the user DBA, and run ssastat.ddl through the Data Vault SQL tool to create the domains and table (SSAQSTAT) for the database in a schema called SSASTAT, owned by the userID SSASTAT. Then, using the Data VaultLoader, execute the ssastat.ndl script to load the query statistics records into the SSASTAT.SSAQSTAT table. The ssastat.ndl file will likely have to be edited to point to the appropriate statistics log (

.sta

) files, since the loader script points to "ssa_stats.sta" in the current directory by default.