March 8, 2013 at 4:13 am
How much time Executionlog2 table and catlog table in ReportServer database hold the data?
Does it store all historical data and it always remain in table
or after some time of interval period sql server remove the data from both the table?????????????????
March 8, 2013 at 4:29 am
Catalog is the reports that you have on the report server, so it is updated deleted when you add or remove reports.
The ExecutionLog2 view works off ExecutionLogStorage which is cleared out as per the value of the server config assigned to this key "ExecutionLogDaysKept", by defaults its something like 2 months.
http://technet.microsoft.com/en-us/library/bb934303%28v=sql.105%29.aspx
March 8, 2013 at 4:43 am
:-)Is it possible to change the value of "ExecutionLogDaysKept"?If possible how to change
March 8, 2013 at 4:45 am
Yes, follow the link i detailed in my original post.
March 10, 2013 at 11:27 pm
What about subscription table does it hold data temporary or as soon as subscription deleted the related record deletet from subscription table??????????
March 10, 2013 at 11:28 pm
The record is removed if you delete the subscription.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 10, 2013 at 11:37 pm
thanks:-) and what about Datasource table
March 10, 2013 at 11:45 pm
Data source is the same thing. If you delete a datasource, the record should get removed.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 11, 2013 at 1:17 am
Can we see that particular table in database is affected by which ssis task or which job perform on that table??
March 13, 2013 at 7:09 am
What is difference in ExecutionLog2 and ExecutionLog3 view?
March 13, 2013 at 7:13 am
Take a look at the definition of the views and you will see the differences.
One relates to reports, the other to items
March 13, 2013 at 9:09 am
Vikas.Shinde 10262 (3/11/2013)
Can we see that particular table in database is affected by which ssis task or which job perform on that table??
You should start a new thread for this question.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply