Finding long-running or clashing SQL Agent jobs...

Last Post 26 Jun 2010 08:17 AM by william.alber. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
william.alber
New Member
New Member

--
26 Jun 2010 08:17 AM
Hi All,

I've been using SQLjobvis (http://localhost/sqlsoft/sqljobvis.php) recently to identify and resolve issues with periodic slowness on a production server, and can highly recommend it.  The UI provided with SSMS is great for checking what's running and the history of individual jobs - but doesn't give any information on how jobs have performed historically in a decent format - SQLjobvis is great for this.

After using SQLjobvis, I've managed to decrease the number of user complaints of slowness to near zero!

Cheers,

Will.


Acceptable Use Policy
---