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: jobs
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.
A Table Summarizing All Agent Jobs with Steps...
Category:
database-administration
Each time I work with a new system, it can take a while to familiarize myself with what all the SQL Server Agent jobs do. Often there are quite a few jobs, and sometimes they have legacy names that either don’t describe what the job does very well anymore, or is just hard to understand.
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.