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

<<  January 2018  >>
MoTuWeThFrSaSu
25262728293031
1234567
891011121314
15161718192021
22232425262728
2930311234

View posts in large calendar