The Evt_NS_Event_History table grows to upwards of 50 million rows

Article:TECH14577  |  Created: 2006-06-30  |  Updated: 2007-09-18  |  Article URL http://www.symantec.com/docs/TECH14577
Article Type
Technical Solution


Issue



The Evt_NS_Event_History table has been seen to grow rapidly in some environments, where upwards of 550,000 Software Delivery Execution events per day are sent to the database.

Environment



Notification Server 6.0
Software Delivery Solution 6.0, 6.1

Cause



 


Solution



The following SQL was provided to purge the Evt_NS_Event_History table:

     select * into #t from Evt_NS_Event_History
     where _eventTime > getdate() - 7

     truncate table Evt_NS_Event_History
     insert into Evt_NS_Event_History select _ResourceGuid, _eventTime, _forward, StartTime, ItemGuid, ItemName, ResourceGuid, ResourceName, TickCount, ErrorNumber, EventData from #t

     drop table #t


Attachments

CleanSWD.sql (234 Bytes)

Legacy ID



24406


Article URL http://www.symantec.com/docs/TECH14577


Terms of use for this information are found in Legal Notices