Managing Statistics in SQL Server for DBAs (videos)
Category:
query-performance
, database-administration
Want to learn more about managing statistics updates in SQL Server? Watch my 27 minute presentation on managing statistics.
Tag: sql-agent
Average Daily Job Runtime
Category:
monitoring-troubleshooting
Here’s a query I found useful today– this week we moved many of our production datamart servers to SQL 2K5 SP3 CU4, and today among the course of other issues I wanted to take a look at my job runtimes to see if they might be noticeably slower or faster than prior runs. I often am in a similar situation after deploying significant changes to our codebase.
SQL Agent Jobs: Checking for failed steps at the end of a job
Category:
monitoring-troubleshooting
I use the SQL Agent a lot, and it is handy for a lot of things, but it can be frustrating to not be able to pass state information between steps.