Table of Contents
About the Contributors ................................................................... v
Glenn Berry (Author) ...............................................................................................................v
Louis Davidson (Author) .........................................................................................................v
Tim Ford (Author) ....................................................................................................................v
Adam Machanic (Additional Material).................................................................................vi
Introducing Dynamic Management Objects ...................................7
What sort of data is available? ................................................................................................8
Point in time versus cumulative ............................................................................................9
Performance Tuning with DMOs .........................................................................................11
Connections, Sessions, Requests, Queries ...................................15
Optimizing your SQL Workload ..........................................................................................16
DMV#1: Are you Connected? ............................................................................................... 17
DMV#2: Session Ownership ................................................................................................19
DMV#3: Current expensive, or blocked, requests ............................................................ 20
DMV#4: Query Stats – Find the "top X" most expensive cached queries ..................... 21
DMV#5: How many single-use ad-hoc Plans? ................................................................... 23
DMV#6: Ad-hoc queries and the plan cache .....................................................................24
DMV#7: Investigate expensive cached stored procedures ..............................................26
DMV#8: Find Queries that are waiting, or have waited, for a Memory Grant ............29
Transactions ................................................................................... 31
DMV#9: Monitor long-running transactions ................................................................... 32
DMV#10: Identify locking and blocking issues ................................................................. 33
Databases and Indexes..................................................................36
DMV#11: Find Missing Indexes............................................................................................37
DMV#12: Interrogate Index Usage ......................................................................................39
DMV#13: Table Storage Stats (Pages and Row Counts) ...................................................43
DMV#14: Monitor TempDB ................................................................................................ 44
评论0
最新资源