periodic table of dynamic management...
TRANSCRIPT
![Page 1: PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTSthesqlagentman.com/wp-content/uploads/2012/05/Periodic-Table-of … · QS QTS rgvvc Groups ioPR 10 Pending 10 xeP QOII QMG ioFS 10 File](https://reader033.vdocuments.us/reader033/viewer/2022060319/5f0ce0947e708231d437931c/html5/thumbnails/1.jpg)
PERIODIC TABLE OF DYNAMIC
MANAGEMENT OBJECTS
the science of performance tuning SQL with DMVs
A Presentation by Tim Ford
SQLCruise.com
B-Side Consulting
http://thesqlagentman.com/go/presentations
![Page 2: PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTSthesqlagentman.com/wp-content/uploads/2012/05/Periodic-Table-of … · QS QTS rgvvc Groups ioPR 10 Pending 10 xeP QOII QMG ioFS 10 File](https://reader033.vdocuments.us/reader033/viewer/2022060319/5f0ce0947e708231d437931c/html5/thumbnails/2.jpg)
The Periodic Table of DMOs
Performance Tuning with SQL Server Dynamic
Management Views Book
Glenn Berry’s SQL Server Performance Blog
Brent Ozar PLF Wait Stats Goldmine
Ola Hallengren Index Tuning Suite
Tim’s Blog: theSQLAgentMan
![Page 3: PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTSthesqlagentman.com/wp-content/uploads/2012/05/Periodic-Table-of … · QS QTS rgvvc Groups ioPR 10 Pending 10 xeP QOII QMG ioFS 10 File](https://reader033.vdocuments.us/reader033/viewer/2022060319/5f0ce0947e708231d437931c/html5/thumbnails/3.jpg)
![Page 4: PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTSthesqlagentman.com/wp-content/uploads/2012/05/Periodic-Table-of … · QS QTS rgvvc Groups ioPR 10 Pending 10 xeP QOII QMG ioFS 10 File](https://reader033.vdocuments.us/reader033/viewer/2022060319/5f0ce0947e708231d437931c/html5/thumbnails/4.jpg)
![Page 5: PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTSthesqlagentman.com/wp-content/uploads/2012/05/Periodic-Table-of … · QS QTS rgvvc Groups ioPR 10 Pending 10 xeP QOII QMG ioFS 10 File](https://reader033.vdocuments.us/reader033/viewer/2022060319/5f0ce0947e708231d437931c/html5/thumbnails/5.jpg)
![Page 6: PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTSthesqlagentman.com/wp-content/uploads/2012/05/Periodic-Table-of … · QS QTS rgvvc Groups ioPR 10 Pending 10 xeP QOII QMG ioFS 10 File](https://reader033.vdocuments.us/reader033/viewer/2022060319/5f0ce0947e708231d437931c/html5/thumbnails/6.jpg)
![Page 7: PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTSthesqlagentman.com/wp-content/uploads/2012/05/Periodic-Table-of … · QS QTS rgvvc Groups ioPR 10 Pending 10 xeP QOII QMG ioFS 10 File](https://reader033.vdocuments.us/reader033/viewer/2022060319/5f0ce0947e708231d437931c/html5/thumbnails/7.jpg)
![Page 8: PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTSthesqlagentman.com/wp-content/uploads/2012/05/Periodic-Table-of … · QS QTS rgvvc Groups ioPR 10 Pending 10 xeP QOII QMG ioFS 10 File](https://reader033.vdocuments.us/reader033/viewer/2022060319/5f0ce0947e708231d437931c/html5/thumbnails/8.jpg)
Performance Core DMOs
![Page 9: PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTSthesqlagentman.com/wp-content/uploads/2012/05/Periodic-Table-of … · QS QTS rgvvc Groups ioPR 10 Pending 10 xeP QOII QMG ioFS 10 File](https://reader033.vdocuments.us/reader033/viewer/2022060319/5f0ce0947e708231d437931c/html5/thumbnails/9.jpg)
… What are we WAITING for?
![Page 10: PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTSthesqlagentman.com/wp-content/uploads/2012/05/Periodic-Table-of … · QS QTS rgvvc Groups ioPR 10 Pending 10 xeP QOII QMG ioFS 10 File](https://reader033.vdocuments.us/reader033/viewer/2022060319/5f0ce0947e708231d437931c/html5/thumbnails/10.jpg)
Usage DMOs
![Page 11: PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTSthesqlagentman.com/wp-content/uploads/2012/05/Periodic-Table-of … · QS QTS rgvvc Groups ioPR 10 Pending 10 xeP QOII QMG ioFS 10 File](https://reader033.vdocuments.us/reader033/viewer/2022060319/5f0ce0947e708231d437931c/html5/thumbnails/11.jpg)
Query and Plan DMOs
![Page 12: PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTSthesqlagentman.com/wp-content/uploads/2012/05/Periodic-Table-of … · QS QTS rgvvc Groups ioPR 10 Pending 10 xeP QOII QMG ioFS 10 File](https://reader033.vdocuments.us/reader033/viewer/2022060319/5f0ce0947e708231d437931c/html5/thumbnails/12.jpg)
… who are you and what are you doing?
![Page 13: PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTSthesqlagentman.com/wp-content/uploads/2012/05/Periodic-Table-of … · QS QTS rgvvc Groups ioPR 10 Pending 10 xeP QOII QMG ioFS 10 File](https://reader033.vdocuments.us/reader033/viewer/2022060319/5f0ce0947e708231d437931c/html5/thumbnails/13.jpg)
Indexing DMOs
![Page 14: PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTSthesqlagentman.com/wp-content/uploads/2012/05/Periodic-Table-of … · QS QTS rgvvc Groups ioPR 10 Pending 10 xeP QOII QMG ioFS 10 File](https://reader033.vdocuments.us/reader033/viewer/2022060319/5f0ce0947e708231d437931c/html5/thumbnails/14.jpg)
let’s shrink a database…
![Page 15: PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTSthesqlagentman.com/wp-content/uploads/2012/05/Periodic-Table-of … · QS QTS rgvvc Groups ioPR 10 Pending 10 xeP QOII QMG ioFS 10 File](https://reader033.vdocuments.us/reader033/viewer/2022060319/5f0ce0947e708231d437931c/html5/thumbnails/15.jpg)
![Page 16: PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTSthesqlagentman.com/wp-content/uploads/2012/05/Periodic-Table-of … · QS QTS rgvvc Groups ioPR 10 Pending 10 xeP QOII QMG ioFS 10 File](https://reader033.vdocuments.us/reader033/viewer/2022060319/5f0ce0947e708231d437931c/html5/thumbnails/16.jpg)
My oh my what a CLUSTER …
![Page 17: PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTSthesqlagentman.com/wp-content/uploads/2012/05/Periodic-Table-of … · QS QTS rgvvc Groups ioPR 10 Pending 10 xeP QOII QMG ioFS 10 File](https://reader033.vdocuments.us/reader033/viewer/2022060319/5f0ce0947e708231d437931c/html5/thumbnails/17.jpg)
Structure Core DMOs
![Page 18: PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTSthesqlagentman.com/wp-content/uploads/2012/05/Periodic-Table-of … · QS QTS rgvvc Groups ioPR 10 Pending 10 xeP QOII QMG ioFS 10 File](https://reader033.vdocuments.us/reader033/viewer/2022060319/5f0ce0947e708231d437931c/html5/thumbnails/18.jpg)
The Swiss Army Knife of DMVs…
![Page 19: PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTSthesqlagentman.com/wp-content/uploads/2012/05/Periodic-Table-of … · QS QTS rgvvc Groups ioPR 10 Pending 10 xeP QOII QMG ioFS 10 File](https://reader033.vdocuments.us/reader033/viewer/2022060319/5f0ce0947e708231d437931c/html5/thumbnails/19.jpg)
Securables DMOs
![Page 20: PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTSthesqlagentman.com/wp-content/uploads/2012/05/Periodic-Table-of … · QS QTS rgvvc Groups ioPR 10 Pending 10 xeP QOII QMG ioFS 10 File](https://reader033.vdocuments.us/reader033/viewer/2022060319/5f0ce0947e708231d437931c/html5/thumbnails/20.jpg)
SQLOS DMOs
![Page 21: PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTSthesqlagentman.com/wp-content/uploads/2012/05/Periodic-Table-of … · QS QTS rgvvc Groups ioPR 10 Pending 10 xeP QOII QMG ioFS 10 File](https://reader033.vdocuments.us/reader033/viewer/2022060319/5f0ce0947e708231d437931c/html5/thumbnails/21.jpg)
Full Text Indexing DMOs
![Page 22: PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTSthesqlagentman.com/wp-content/uploads/2012/05/Periodic-Table-of … · QS QTS rgvvc Groups ioPR 10 Pending 10 xeP QOII QMG ioFS 10 File](https://reader033.vdocuments.us/reader033/viewer/2022060319/5f0ce0947e708231d437931c/html5/thumbnails/22.jpg)
Peripheral DMOs
![Page 23: PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTSthesqlagentman.com/wp-content/uploads/2012/05/Periodic-Table-of … · QS QTS rgvvc Groups ioPR 10 Pending 10 xeP QOII QMG ioFS 10 File](https://reader033.vdocuments.us/reader033/viewer/2022060319/5f0ce0947e708231d437931c/html5/thumbnails/23.jpg)
![Page 24: PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTSthesqlagentman.com/wp-content/uploads/2012/05/Periodic-Table-of … · QS QTS rgvvc Groups ioPR 10 Pending 10 xeP QOII QMG ioFS 10 File](https://reader033.vdocuments.us/reader033/viewer/2022060319/5f0ce0947e708231d437931c/html5/thumbnails/24.jpg)
![Page 25: PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTSthesqlagentman.com/wp-content/uploads/2012/05/Periodic-Table-of … · QS QTS rgvvc Groups ioPR 10 Pending 10 xeP QOII QMG ioFS 10 File](https://reader033.vdocuments.us/reader033/viewer/2022060319/5f0ce0947e708231d437931c/html5/thumbnails/25.jpg)
ABOUT ME
theSQLAgentMan.com
consulting
achievements
working
writing