Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

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.

0 votes
Sign in
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)

We’ll send you updates on this idea

AdminMicrosoft SQL Server (Product Manager, Microsoft Azure) shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

0 comments

Sign in
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base