To check on retention time for reporting tables in the datawarehouse db run:
SELECT cs.cs_tablename 'Table Name', wcs.wcs_groomdays 'Groom Days'
from warehouseclassschema wcs
Join classschemas cs
On cs.cs_classID = wcs.wcs_classID
Where cs.cs_tablename = 'SC AlertFact Table'
Or cs.cs_tablename = 'SC_AlertHistoryFact_table'
Or cs.cs_tablename = 'SC_AlertToEventFact_table'
Or cs.cs_tablename = 'SC_EventFact_table'
Or cs.cs_tablename = 'SC_EventParameterFact_table'
Or cs.cs_tablename = 'SC_SampledNumericDataFact_table'
And wcs.wcs_mustbegroomed=1
To change the retention time run the following:
Exec p_updategroomdays '<Table Name>', 180
-----Original Message-----
From: Steve Faulkner [mailto:mssqldba-ezmlmshield-x44085942.[Email address protected]
Sent: Thursday, May 31, 2007 7:18 AM
To: LazyDBA Discussion
Subject: MOM Reporting Database Housekeep.
Hi Guys,
I was wondering if anyone here has any experience with the MOM Reporting
db.
Ours has grown very big and our users want all data older than 6 months
purged from it.
Are there any SPs out there, that can do this or does anyone have any
pointers to the tables I need to look at to housekeep?
Many thanks in advance
Steve
________________________________________________________________________
FFastFill plc is a public limited company registered in England and Wales with details as follows;
Registered Office: 1-3 Norton Folgate, London E1 6DB Company Number:978346
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
[Email address protected]
This email has been scanned for all viruses by the FFastFill Email
Security System.
________________________________________________________________________
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
MS Sql Server LazyDBA home page