by Admin4. October 2012 16:19If you're using BAT for a long time, you may wonder why the size of BAT database is so large?
Answer: because BAT is gathering a lot of statistical information, including:
- What actions each user performed and additional information about these actions (e.g. what measures/dimensions were on the report page when user was doing data update).
- What MDX requests users were running;
Error logs.
When we look at the BAT database using SqlExecMS, we can see the following picture:
There are tables which contain a lot of data.
In the case if you don't need to keep this data, we propose to do the following.
There is a stored procedure sprStatistics_Clear in the BAT database (if your BAT version is lower than 4.48, download it from here). Put this procedure to SQL Server Agent to start at 1:00 am, for example. The statement should look like this:
exec sprStatistics_Clear
or
exec sprStatistics_Clear NUMBER_OF_DAYS
where NUMBER_OF_DAYS should be replaced by actual number of days that you want to keep in history.
db424509-f63d-4fd8-8c61-a1d01f67e8ec|0|.0|96d5b379-7e1d-4dac-a6ba-1e50db561b04