question

sp_lock avatar image
sp_lock asked

ServerParametersInstance table in SSRS

Hi all

My ServerParametersInstance table in the ReportServer db is growing at an alarming rate (200 rows per min during the working day). I have google'd this and some suggestions say it can be purged. Can it?

Any suggestions would be appreciated.

Details of the rows in the table

Month   Year    Count

9    2009    183470
10  2009    485955
11  2009    306870
12  2009    669902
1    2010    597570
2    2010    1797064
3    2010    788064

Thanks

JL

sql-server-2005ssrs
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image Kev Riley ♦♦ commented ·
are those derived from the CreatedDate?
0 Likes 0 ·
sp_lock avatar image sp_lock commented ·
They are from the Modified date...
0 Likes 0 ·

1 Answer

·
Kev Riley avatar image
Kev Riley answered

This table has an Expiration column (datetime) - how much of the data is 'expired'?

3 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sp_lock avatar image sp_lock commented ·
@Kev thanks for your reply. I have updated the question with some more details. There is only 107 expired records. What is the purpose of this table?
0 Likes 0 ·
Kev Riley avatar image Kev Riley ♦♦ commented ·
No idea yet - I have no records in that tbale on my SSRS instance! Like you say Google isn't offering much up about this.....
0 Likes 0 ·
sp_lock avatar image sp_lock commented ·
Only suggests to purge them, but need to understand what they are before I do.. Especially as it is a PROD system. Cheers
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.