Purge ServerParametersInstance

Last Post 20 Mar 2008 12:40 PM by ChabotWVU. 4 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
ChabotWVU
New Member
New Member

--
19 Mar 2008 02: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

--
20 Mar 2008 12:07 AM
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 12:40 PM
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 06: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 06:15 AM
Hi ChabotWVU,

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

Thanks,
chrno
You are not authorized to post a reply.

Acceptable Use Policy