SSRS: History in ExecutionLogStorage

By default, Reporting Server (SSRS) keeps report execution information in the execution log (‘[dbo].[ExecutionLogStorage]‘). After that, you guessed it…it will be deleted. In case you would like to increase the retention period on this table, there’s a server property named “ExecutionLogDaysKept” for Reporting Services. This can help you to increase the retention period, for more information:
http://technet.microsoft.com/en-us/library/bb934303%28v=sql.105%29.aspx

ExecutionLogDaysKept
The number of days to keep report execution information in the execution log. Valid values for this property include 0 through 2,147,483,647. If the value is 0 entries are not deleted from the Execution Log table. The default value is 60.


How to increase the number of days
You can modify the settings by connecting to your SSRS database and executing the SetConfigurationInfo stored procedure:
EXEC SetConfigurationInfo @Name=N'ExecutionLogDaysKept',@Value=N'90'

Or connect to your Reporting Services instance with SSMS and open the Server Properties of SSRS and go to ‘Logging’:

SSRS-server-properties-logging








Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s