I recently gave a presentation as part of the PASS Performance Virtual Chapter’s Performance-Palooza on “Performing a SQL Server Health Check.” I was happy to take part in this event, and as a bonus the group recorded the presentations so that others could view them.
The full presentation is available here. I hope you learn something (and enjoy it!)
Some key takeaways from the presentation:
1) Health Checks should be proactive and recurring
2) Make sure to check as many of the various layers of the system – infrastructure, virtualization, operating system, database, application – as possible – not just the database.
3) Many of the tools needed are freely available online, such as Glenn Berry’s Diagnostic Information Query Scripts.
4) Baseline your systems to learn what the true expected values are for most indicators – there are generic best practice guidelines for most numbers, but every system is different.
The various PASS virtual chapters provide content like this for *free* on a regular basis – some as frequently as several times per month. There are currently 28 virtual chapters that are broken out by content and language – visit www.sqlpass.org for a full list.
Andy Galbraith has more than 15 years of experience in SQL Server, clustering, mirroring, and performance tuning. He is currently a Microsoft SQL Server Team Lead at Ntirety. Follow Andy on Twitter @DBA_ANDY and read more of Andy’s blogs at: http://nebraskasql.blogspot.com/