Manually Purge Old Data
linque
Posts: 31
I'm running SQL Monitor 2.3.0.334, and neglected to set up Data Purging when I first set it up. I've been slowly setting the purge dates from one-year to six-months to three-months so I don't overwhelm the server, but it's having little effect, and it's an hour between purge jobs. Is there a way to manually delete old data? I would prefer a way that doesn't cause my tempdb.ldf file to grow so huge (30 GB+).
Comments
Can you also run a sp_who2 on the tempdb to ensure that SQL Monitor isn't maintaining a constant connection?
Thx