Seven SQL Agent Jobs You Should be Running
Duration: 60 minutes
Track: Track 2
See those things around your ankles? You hope they're your socks because no DBA wants to be caught with their pants down.
Whether you're an accidental DBA, a DBA who has just inherited a bunch of servers, or someone who works in a shop that won't buy monitoring tools, this session will help you get basic monitoring in place to make sure you know what's going on in your environment.
You'll learn how to implement seven simple scripts that perk their ears up and start barking like a dog after a stranger walks in the house. They are the canary in your coal mine. You'll know when backups fail, when they run longer than usual, when data files are getting full, when transaction logs have excessive VLFs, and more.
No material found.