Cleaning Statistics in BAT database

by Admin4. October 2012 16:19

If 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.

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading

About company

BIT Impulse - a software development company, a vendor of a proprietary BI system called "Business Analysis Tool".

Web site: www.bitimpulse.com

Calendar

<<  September 2017  >>
MoTuWeThFrSaSu
28293031123
45678910
11121314151617
18192021222324
2526272829301
2345678

View posts in large calendar