SQL Server 2014 DMV Diagnostic Queries - Part 2

Learn how to easily query SQL Server for instance-level information to help identify and solve performance problems. This course is applicable to anyone who is responsible for a SQL Server instance, with most topics also applicable to SQL Server 2012 and earlier versions.
Course info
Rating
(111)
Level
Intermediate
Updated
Dec 11, 2014
Duration
1h 17m
Table of contents
Introduction
Instance-Level Performance Queries Part 1
Instance-Level Performance Queries Part 2
Description
Course info
Rating
(111)
Level
Intermediate
Updated
Dec 11, 2014
Duration
1h 17m
Description

It is very common for SQL Server instances 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 instance performance information and identify problems. This course is perfect for anyone who is responsible for a SQL Server instance, with most 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. This is SQL Server 2014 DMV Diagnostic Queries - Part 2 and this is the Introduction. So what am I going to talk about in this course? Well, it turns out that database performance issues are immediately noticeable to everybody in your organization. They can quickly affect multiple applications or the entire organization's business, and usually you can't just reboot the database server and hope that that fixes the problem, even though that's what a lot of people do when they have no other clue of what to do. And it turns out that DBA actually stands for Default Blame Acceptor. I can't tell you how many times I've heard, what's wrong with the database? What's wrong with the database server? The database and the database server is guilty until proven innocent. That's just the assumption you're going to run into in most organizations. So you're going to need tools and knowledge to help quickly determine the actual problem when your application or website slows down. Maybe there's nothing wrong with the database server or the database, and so you need to have some evidence to prove that or if there is something wrong with it, you want to find out what is wrong, and then know what to do to fix it.

Instance-Level Performance Queries Part 1
This is Glenn Berry with SQLskills. com, and I'm recording this course for Pluralsight. This is SQL Server 2014 DMV Diagnostic Queries Part 2, and this is the Instance-Level Performance Queries Part 1 module. So instance-level performance queries are a group of queries that you use to collect some instance-level performance metrics about whatever instance you're connected to when you run the queries. And they can be run in the context of any database on the instance, so it doesn't matter if you're connected to master or one of your user database, they're not database specific Many SQL Server instances that I've run into in my career have instance-level performance issues, and these queries are going to help you focus your tuning efforts in the right area, and that's the point of these queries. Now some more background about instance-level performance issues that you might want to think about and correct are in my Pluralsight course, Scaling SQL Server 2012 - Part 1. It covers some best practice instance-level performance considerations and configuration options, and you can get that at this URL. Another really good resource is Joe Sack's Pluralsight course, SQL Server: Common Performance Issue Patterns, and I think that's a very good course you might want to watch at this URL.

Instance-Level Performance Queries Part 2
This is Glenn Berry with SQLskills. com, and I'm recording this course for Pluralsight. This is SQL Server 2014 DMV Diagnostic Queries Part 2, and this is the Instance-Level Performance Queries Part 2 module. So what are we going to talk about in this module? Well instance-level performance queries are just a group of queries that you can use to collect instance-level performance metrics. This is the second half of the set of these queries. And these can be run in the context of any database on the instance, so it doesn't matter if you're connected to master or a particular user database, because these are all instance-level queries, they're not database specific whatsoever. And many SQL Server instances that I've run into in my career have instance-level performance issues that you can use to discover what's happening on your server and focus your tuning efforts in the right area. My Pluralsight course, Scaling SQL Server 2012 - Part 1 covers some best practices instance-level performance considerations, and the URL for that is right here. You also might want to take a look at Joe Sack's Pluralsight course, SQL Server: Common Performance Issue Patterns. That's a very valuable resource that lets you see things that might be happening on your server and talks about different ways that you can fix them, and the URL is right there.