SQL Server 2014 DMV Diagnostic Queries - Part 3

Learn how to easily query SQL Server for database-level information to help identify and solve performance problems. This course is applicable to anyone who is responsible for SQL Server databases, with all topics also applicable to SQL Server 2012 and earlier versions.
Course info
Rating
(86)
Level
Intermediate
Updated
Feb 2, 2015
Duration
1h 8m
Table of contents
Introduction
Database-Level Performance Queries Part 1
Database-Level Performance Queries Part 2
Description
Course info
Rating
(86)
Level
Intermediate
Updated
Feb 2, 2015
Duration
1h 8m
Description

It is very common for SQL Server databases to have performance problems, but it can be hard to know how to get the information necessary to figure out what the performance problems are. This course will describe and demonstrate more than 20 DMV queries you can use to easily examine SQL Server database performance information and identify problems. This course is perfect for anyone who is responsible for SQL Server databases, with all topics also applicable to SQL Server 2012 and earlier versions.

About the author
About the author

Glenn works as a Principal Consultant at SQLskills.com. He has been a SQL Server MVP since 2007, and he is also an Adjunct Faculty member at University College - University of Denver. He is the author of the book SQL Server Hardware (Redgate 2011), and he wrote chapters for both SQL Server MVP Deep Dives books.

More from the author
More courses by Glenn Berry
Section Introduction Transcripts
Section Introduction Transcripts

Introduction
This is Glenn Berry with sqlskills. com. And I'm recording this course for Pluralsight and this is SQL Server 2014 DMV Diagnostic Queries Part 3. This is an introductory module. So what are we going to talk about during this course? Well, database performance issues are actually very immediately noticeable to everybody in your organization. They can quickly affect multiple applications or the entire organization. Usually you can't just reboot the database server and hope that that fixes the problem like you can with a web server. And in case you don't know it, DBA actually stands for Default Blame Acceptor. You know I can't tell you how many times I've heard what's wrong with the database? Why is database server so slow? And so because I used to hear those so often in previous jobs, I put together the scripts that help you deal with that issue. Because the database or the database server is typically guilty until proven innocent. People always assume that it's the source of any application slow down. So you really need some good tools and the knowledge to interpret were you fine with these tools to figure out what's actually going on with your server and what the actual problem might be. You know, maybe there's nothing wrong at all with the database or the database server until you have the tools and the metrics to prove that, people are always going to assume that it's a database problem.

Database-Level Performance Queries Part 1
Database-Level Performance Queries, Part 1. In this module, when we talk about database-level performance queries, this is a group of database-specific queries that we're going to use to collect database-level performance metrics. It's very important that you run these in the context of the database that you're concerned with and not the master system database. Again, these are database-specific queries. Many SQL Server databases actually have performance issues, and these queries are going to help you further focus your tuning efforts in the right area to get to the root cause of the problem. My Pluralsight course, Scaling SQL Server 2012 Part 1 covers some best practice instance-level performance considerations that can help you avoid database-level performance issues. And the URL for that is right there. And Joe sack has a very good Pluralsight course called SQL Server Common Performance Issue Patterns that's a very valuable resource in this area. And the URL for that is right there.

Database-Level Performance Queries Part 2
This is Glenn Berry with SQLskills. com and I'm recording this course for Pluralsight. This is the Database Level Performance Queries Part 2 Module. Database level performance queries are a group of queries that you use to collect database level performance metrics. These must be run in the context of a database that you're concerned with and they are database specific queries. Many SQL server databases have performance issues and these queries will help you further focus your tuning efforts in the right area, so you're not wasting your time, just guessing with your tuning efforts. My Pluralsight course Scaling SQL Server 2012 Part 1 covers some best practice instance level performance considerations and you can get to it at this URL. This course will help you make sure that your instance is set up correctly so that you won't have as many database level performance issues hopefully. Joe Sack has a very good Pluralsight course called SQL Server: Common Performance Issue Patterns that I think is a very valuable resource. You can get to it at that URL.