Monitoring long-running jobs in SQL Server 2000 is not a simple practice, but it is a best practice among DBAs. In this tip, try out a stored procedure that easily identifies long-running jobs. You'll also receive email alerts about these jobs that poorly affect SQL Server performance.
This is cache of http://feeds.feedburner.com/~r/WhatisEnterpriseItTipsAndExpertAdvice/~3/242814086/0,289483,sid87_gci1302809,00.html. Cache is the snapshot of article that we took when we index feed.
To see original page click here.
We are not affiliated with the authors of this article and not responsible for its content.
To see original page click here.
We are not affiliated with the authors of this article and not responsible for its content.
Monitor long-running jobs in SQL Server 2000





