Authoring SQL Server Performance Assessments
4.5 (14 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
106 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Authoring SQL Server Performance Assessments to your Wishlist.

Add to Wishlist

Authoring SQL Server Performance Assessments

A Step by Step Guide to Writing SQL Server Performance Appraisals
4.5 (14 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
106 students enrolled
Created by Mike West
Last updated 9/2016
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • 6 Articles
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • At the end of this course you'll understand all the components to authoring a health check and a comprehensive performance assessment.
  • Additionally, students will receive several templates that they can use to create these appraisals.
View Curriculum
Requirements
  • Students should have taken my course on performance tuning. This is NOT a course on how to tune.
  • Students will need to have prior tuning knowledge. This course is about the document creation and not specific to any one facet of SQL Server.
Description

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 out ways to speed up transactions and reduce resource consumption.

The difference between a health check and performance tuning assessment is the grain and depth. Health checks are brief highlights of how the box is doing. Like a physical for you and I.

Performance tuning assessments are highly detailed documents that break down the server into many components. These border on forensic analysis of the server and give the organization a very detailed look at how their servers are performing.

You’ll decide the depth of your assessments but 10 pages seems to be a great length.  Don’t worry, ten pages isn’t a lot when we start adding pictures. Your assessments have to have pictures to help those who are not technical or not as technical see what you are doing.

NOTE: This is NOT a course on performance tuning. This course is about creating two different types of SQL Server Reports, the health check and the performance tuning assessment. 

Thanks for your interest in crafting SQL Server health checks and performance tuning assessments.  We will see you in the course!!!

Who is the target audience?
  • This course is for SQL Server DBAs who need to craft performance assessments on how SQL Server is performing.
  • Developers interested in authoring health checks should also be interested in this course.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
+
Course Overview
4 Lectures 06:50

This is the same video in the course entry. 

It covers what we will be learning in this course. 

Note: This is NOT a tuning course. This is a document creation course. 

Preview 01:53

Are you in the right place?

Is this course right for you? 

It's an all audio lesson. 

Preview 02:27

What are we really aiming to accomplish when we craft these two documents? 

Who are they for? 

Preview 02:02


Quiz
5 questions
+
Health Check
7 Lectures 20:42

In the next two lessons we cover the definition and high level overview of the health check. 

Preview 03:17

We continue discussing the big three and how to author these documents with them in mind. 

The Health Check: IO and Memory
04:32

What did we find out?  This is the what of our health check. What's wrong with this INSTANCE.

Health Check: Initial Findings
04:04

We know what the issues are now what can we do to correct them. 

Health Check: Recommendations
03:11

Let's discuss the action items.

Health Check: Actions Items and Presentation
04:53

This is the location you can use to download the health check template.

Health Check Template
00:05

Let's wrap up this section.

Summary
00:39

Quiz
5 questions
+
Performance Assessment
9 Lectures 27:43

Let's define what a performance assessment is.

Why is it different than a health check.


Preview 03:20

We list our recommendations first.

This gives all organizational levels... business and IT members a high level definition of the issues on the INSTANCE.

Performance Assessment: Recommendations Part 1
04:15

In this lecture we continue going over our assessment's recommendations.

Performance Assessment: Recommendations Part 2
03:44

Let's continuing learning about the sundry recommendations. 

Performance Assessment: Recommendations Part 3
02:30

It's time to get our hands really dirty. 

This is where we analyze and educated. 

Performance Assessment: Supporting Documentation: Part 1
03:15

Let's continue to delve into our supporting documentation. 

Performance Assessment: Supporting Documentation: Part 2
05:41

This is where you'll download the performance tuning template.

Performance Assessment Template
00:03

In this lecture let's talk about the presentation. 

Performance Assessment: Presentation
04:08

Let's wrap up what we've learned in this section.

Summary
00:47

Quiz
10 questions
+
Conclusion
1 Lecture 00:49
Conclusion
00:49
About the Instructor
Mike West
4.2 Average rating
2,587 Reviews
42,685 Students
40 Courses
SQL Server and Machine Learning Evangelist

I've been a production SQL Server DBA most of my career.

I've worked with databases for over two decades. I've worked for or consulted with over 50 different companies as a full time employee or consultant. Fortune 500 as well as several small to mid-size companies. Some include: Georgia Pacific, SunTrust, Reed Construction Data, Building Systems Design, NetCertainty, The Home Shopping Network, SwingVote, Atlanta Gas and Light and Northrup Grumman.

Experience, education and passion

I learn something almost every day. I work with insanely smart people. I'm a voracious learner of all things SQL Server and I'm passionate about sharing what I've learned. My area of concentration is performance tuning. SQL Server is like an exotic sports car, it will run just fine in anyone's hands but put it in the hands of skilled tuner and it will perform like a race car.

Certifications

Certifications are like college degrees, they are a great starting points to begin learning. I'm a Microsoft Certified Database Administrator (MCDBA), Microsoft Certified System Engineer (MCSE) and Microsoft Certified Trainer (MCT).

Personal

Born in Ohio, raised and educated in Pennsylvania, I currently reside in Atlanta with my wife and two children.