Daily Archives: July 3, 2012

SQL SERVER – Delete Backup History – Cleanup Backup History

SQL SERVER – Delete Backup History – Cleanup Backup History.

1 Comment

Posted by on July 3, 2012 in Database Administration


Tags: , , ,

Capture Server Activity from Sp_Who2

One problem I’ve always had is not having enough time to investigate a performance problem due to the fact that the system stored procedure Sp_Who2 only displays current activity. I had an issue with a problematic query that was running occasionally. Emails would be sent out about CPU usage spiking on a production transactional system but they would be short lived.  I needed a way to save some of the activity so I could use it later.

Read the rest of this entry »


Tags: ,

%d bloggers like this: