People who have inherited a SQL Server they need to administer
You’ve just been handed a SQL Server, and you need to make sure there aren’t any skeletons in the closet. What things should you check to make sure everything is healthy?
In this presentation, we’ll run you through the checklist I use when I provide a health check to a customer. First, I check for any resume generating events (RGEs) like broken backups. Then I check for best practices like email alerts and MAXDOP settings. Finally, these checks turn into more a scuba diving expedition, where we look for things that seem off and dig deeper.
You won’t walk away with a perfect strategy, but you’ll have an idea of how one data professional does it.
Why I Want to Present This Session:
This is something that I do anyway, I might as well document it for the community.
Latest posts by Eugene Meidinger (see all)
- SQL Server Health Checks - July 30, 2017
- Just Enough Database Theory for Power BI - June 15, 2017
- Keeping up with Technology: Drinking from the Firehose - June 2, 2017