Add a server property to specify data retention period for data stored in Analysis Service query log
We are using SQL Server database to store Analysis Service query log data. Comparing to Analysis Service 2000, Analysis Service 2005 seem to log a lot more information to the query log, resulting in rapidly growing query log database for busy applications. We have a requirement to log every query on production servers. After just a few weeks into production, the query log database has grown to over 4G in size. What's the best way to deal with large amount of query log data? Apart from developing our own customized data purging mechanism, it will be very helpful to have a server property for us to specify data retention period.
Upvotes: 0<=-=May 14 2007 10:20AM=-=>
Thank you for your suggestion. We will consider this for the next release of SQL Server.