RSS

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: