|
|
|
|
|
|
|
Account Login
|
 |
|
|
|
 |
|
|
Downloads
|
|
|
|
|
|
|
|
|
|
 |
Adam Machanic - 15 Powerful DMVs |
|
|
Adam Machanic's presentation and demos from the April 8, 2010 meeting.
What's Really Happening on Your Server? 15 Powerful SQL Server Dynamic Management Objects
There are two kinds of DBAs in this world: those who scratch their heads, unsure of how to find answers, and those who demand real-time, comprehensive insight. This session is for the latter type, the Type A DBAs who are serious about managing their servers as efficiently as possible. The Dynamic Management Objects--a set of views and functions that first shipped with SQL Server 2005--are a window into the inner workings of your SQL Server instance. Locked within the objects is the information you need to help you solve virtually any performance problem, quickly debug issues as they're occurring, and gain insight into what's actually happening on your server, right now. This session is a fast-paced tour of the ins, outs, whys, hows, and even pitfalls of 15 of the most important views and functions--information gleaned from heavy use of the objects in a number of environments over the past five years. You will learn how to understand transaction behavior, locking, wait statistics, sessions, requests, and much more. No longer will you need to scratch your head, wondering what is slowing down your queries: You will be the master of your SQL Server instance.
| File size |
173 K |
| Downloads |
209 |
| Date |
Thu 04/08/2010 @ 07:09 |
| Author |
Adam Machanic |
| EMail |
amachanic@gmail.com |
|
|
RATING: DOWNLOAD
|
|
|
|
|
|
|
|
|
|
|
|
|
|