Authoring SQL Server Performance Assessments

About this course

Welcome to Authoring SQL Server Performance Assessments.Note: Included in the course are two separate templates you can use to craft your own assessments. Please feel free to use them in any capacity you'd like. When you go to the doctor he/she performs a basic list of checks on you.  What’s your temperature? What’s your blood pressure? Height? Weight? A health check is very similar to looking at the basics. Just like a doctor SQL Server DBAs want to see just how bad of shape our patient is really in. In order to do that we create health checks on the instance.  I used the word instance not database. Performance tuning is not about tuning an individual database it’s about tuning the entire instance. Why? Because most real world boxes have more than one database on them. Those databases all share the big three. The big three are: CPU, Memory and Disk. A heath check or an assessment seeks to highlight the two main principles of performance tuning. The first is speeding up transactions. The second is reducing resource consumption of the big three.  In our checks and assessments we point ou