Purge ServerParametersInstance

Last Post 20 Mar 2008 11:40 AM by ChabotWVU. 4 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
ChabotWVU
New Member
New Member

--
19 Mar 2008 01:15 PM
The ServerParametersInstance table is growing out of control; can anyone explain the function of the this table in the Report Server DB and has anyone setup a nightly purge for this table?

Thanks,
Andrew

SQLUSA
New Member
New Member

--
19 Mar 2008 11:07 PM
First backup the report server database for safekeeping.

Create a nightly purge job which keeps only last 5 days of create date.

Let us know if this works for you.

Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
BI Workshop NYC SSAS, SSIS, SSRS - April 21-24: http://www.sqlusa.com/

ChabotWVU
New Member
New Member

--
20 Mar 2008 11:40 AM
I setup the purge to remove any records older than 5 days and I did not receive any complaints from end users which is a good thing.
SQLUSA
New Member
New Member

--
20 Mar 2008 05:59 PM
Great keep monitoring and let us know how it goes.

Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
SSAS, SSIS, SSRS Training: http://www.sqlusa.com/
chrno2004
New Member
New Member

--
08 Apr 2008 05:15 AM
Hi ChabotWVU,

Any chance you can share your TSQL script for the purge job?

Thanks,
chrno


Acceptable Use Policy
---