periodic table of dynamic management...

25

PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTS the science of performance tuning SQL with DMVs Presentation by Tim Ford [email protected]

Upload: duongnhan

Post on 19-Jul-2018

217 views

Category:

Documents

0 download

Report

Download

Embed Size (px):

TRANSCRIPT

Page 1: PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTSthesqlagentman.com/wp-content/uploads/2012/05/Periodic-Table-of... · PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTS ... 14.007 phosphorus

PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTS the science of performance tuning SQL with DMVs

Presentation by Tim Ford [email protected]

Page 2: PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTSthesqlagentman.com/wp-content/uploads/2012/05/Periodic-Table-of... · PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTS ... 14.007 phosphorus

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... · PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTS ... 14.007 phosphorus

Page 4: PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTSthesqlagentman.com/wp-content/uploads/2012/05/Periodic-Table-of... · PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTS ... 14.007 phosphorus

Page 5: PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTSthesqlagentman.com/wp-content/uploads/2012/05/Periodic-Table-of... · PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTS ... 14.007 phosphorus

Page 6: PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTSthesqlagentman.com/wp-content/uploads/2012/05/Periodic-Table-of... · PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTS ... 14.007 phosphorus

Page 7: PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTSthesqlagentman.com/wp-content/uploads/2012/05/Periodic-Table-of... · PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTS ... 14.007 phosphorus

Page 8: PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTSthesqlagentman.com/wp-content/uploads/2012/05/Periodic-Table-of... · PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTS ... 14.007 phosphorus

Usage DMOs

Page 9: PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTSthesqlagentman.com/wp-content/uploads/2012/05/Periodic-Table-of... · PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTS ... 14.007 phosphorus

Query and Plan DMOs

Page 10: PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTSthesqlagentman.com/wp-content/uploads/2012/05/Periodic-Table-of... · PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTS ... 14.007 phosphorus

… What are these users doing on my nice clean server?

Page 11: PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTSthesqlagentman.com/wp-content/uploads/2012/05/Periodic-Table-of... · PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTS ... 14.007 phosphorus

Indexing DMOs

Page 12: PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTSthesqlagentman.com/wp-content/uploads/2012/05/Periodic-Table-of... · PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTS ... 14.007 phosphorus

… fun with indexes

Page 13: PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTSthesqlagentman.com/wp-content/uploads/2012/05/Periodic-Table-of... · PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTS ... 14.007 phosphorus

Securables DMOs

Page 14: PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTSthesqlagentman.com/wp-content/uploads/2012/05/Periodic-Table-of... · PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTS ... 14.007 phosphorus

Page 15: PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTSthesqlagentman.com/wp-content/uploads/2012/05/Periodic-Table-of... · PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTS ... 14.007 phosphorus

my oh-my! what a cluster…

Page 16: PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTSthesqlagentman.com/wp-content/uploads/2012/05/Periodic-Table-of... · PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTS ... 14.007 phosphorus

Structure Core DMOs

Page 17: PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTSthesqlagentman.com/wp-content/uploads/2012/05/Periodic-Table-of... · PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTS ... 14.007 phosphorus

…the MacGyver of DMVs

Page 18: PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTSthesqlagentman.com/wp-content/uploads/2012/05/Periodic-Table-of... · PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTS ... 14.007 phosphorus

SQLOS DMOs

Page 19: PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTSthesqlagentman.com/wp-content/uploads/2012/05/Periodic-Table-of... · PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTS ... 14.007 phosphorus

Performance Core DMOs

Page 20: PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTSthesqlagentman.com/wp-content/uploads/2012/05/Periodic-Table-of... · PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTS ... 14.007 phosphorus

performance-enhancing… scripts

Page 21: PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTSthesqlagentman.com/wp-content/uploads/2012/05/Periodic-Table-of... · PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTS ... 14.007 phosphorus

Full Text Indexing DMOs

Page 22: PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTSthesqlagentman.com/wp-content/uploads/2012/05/Periodic-Table-of... · PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTS ... 14.007 phosphorus

Peripheral DMOs

Page 23: PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTSthesqlagentman.com/wp-content/uploads/2012/05/Periodic-Table-of... · PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTS ... 14.007 phosphorus

Page 24: PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTSthesqlagentman.com/wp-content/uploads/2012/05/Periodic-Table-of... · PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTS ... 14.007 phosphorus

Page 25: PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTSthesqlagentman.com/wp-content/uploads/2012/05/Periodic-Table-of... · PERIODIC TABLE OF DYNAMIC MANAGEMENT OBJECTS ... 14.007 phosphorus

ABOUT ME

theSQLAgentMan.com

consulting

achievements

working

writing

The Periodic Table Periodic table. How is the periodic table organized? Mendeleev organized the periodic table by PROPERTIES! He put them in groups (called

Elements and the Periodic Table. The Periodic Table and the Elements What is the periodic table ? What is the periodic table ? What information is obtained

The Modern Periodic Table - SCH3UKING - homesch3uking.wikispaces.com/file/view/Periodic+Table+and...Agenda •Lesson: PPT, •Handouts: 1.PPT Handout; Periodic Table Puzzle; Periodic

The Periodic Table. MENDELEEV Old image of periodic table

Unit 5 Notes - Periodic Table · Periodic Table Lesson 1: Periodic Table Basics HISTORY OF THE PERIODIC TABLE • Dmitri Mendeleev: 1869 - arranged elements according to increasing

The Periodic Table. Why is the Periodic Table important to me? The periodic table is the most useful…

The Periodic Table Introduction Mendeleev’s Periodic Table Dmitri Mendeleev

THE P PP PERIODIC TABLE THEPERIODIC TABLETHE PERIODIC TABLETHEPERIODIC TABLETHE PERIODIC TABLE

Periodic Table and Chemical Reactions revision. The Periodic Table

The Periodic Table. content i. Dimitri Mendeleev's periodic table ii. The modern periodic table iii. Families of the periodic table iv. Periodic

Periodic Table Bingo Periodic Table

The Periodic Periodic Table - exo.netemuller/activities/The Periodic Periodic Table.pdf · The Periodic Periodic Table ... Print off periodic table provided at end of this document

The Periodic Table How the periodic table is put together

4.06 Periodic Table and Periodic Trendsfaculty.sdmiramar.edu/fgarces/zCourse/All_Year/Ch100/Ch100_mmc/aMy... · 4 4.06 Periodic Table and Periodic Trend August 2017 Periodic Table

UNIT 3 Part 3: The Periodic Table 1 Development of the Periodic Table 2 Reading the Periodic Table 3 Periodic Trends

2.2 The Periodic Table. The Periodic Table Every block represents an element Every periodic table has a key

Chapter 6: The Periodic Table and Periodic · PDF file12.011 Nitrogen 7 N 14.007 Silicon 14 Si ... The Periodic Table and Periodic Law Sulfur ... Review Vocabulary atomic number: the

The periodic table. Using the periodic table What is the periodic table? ◦ The periodic table is a chart of the elements arranged into rows and columns

+ Chapter 10: The Periodic Table. + Vocabulary words: Periodic table Group Period Lesson 1: Using the Periodic Table

Chapter 5 The Periodic Table. Periodic Table Info

THE PERIODIC TABLE & PERIODIC LAW Periodic Table and Periodic... · THE PERIODIC TABLE & PERIODIC LAW ... General rule: i. Elements with three or less electrons in the outer level

Periodic Table.1. The Periodic Table-Key Questions What is the periodic table ? What information does the table provide ? ? How can one use the periodic

Periodic Table and Periodic Trends

Atoms, Elements and the Periodic Table. Periodic Table of Elements

The Periodic Table of Elements The Periodic Table

THE MODERN PERIODIC TABLE. Modern Periodic Table

Periodic Table of the Elements - periodni.com€¦ · GROUP IUPAC GROUP CAS PERIODIC TABLE OF. 2 4.0026 7 14.007 1020.180 17 35.45 1839.948 8 15.999 9 18.998 3683.798 54131.29 86

Ptable.com Periodic Table · 2017. 2. 6. · 207.2 208.98 (209) 210) 74.922 78.971 121.76 127.60 79.904 83.798 126.90 131.29 14.007 15.999 30.974 32.06 18.998 20.180 35.45 39.948

Periodic Table of Elements Research Project...2016/11/08 · Periodic Table of Elements Research Project Researching the Periodic Table! Choose one element from the periodic table

Periodic Table Tutorial Chapter 5.4 Chapter 14 Periodic Table Periodic Table Scientists & Definitions Scientists & Definitions Periodic Trends Questions

Mendeleev’s Periodic Table This arrangement was the forerunner of today’s periodic table. Periodic Table

TThe Periodic Table and Periodic Lawhe Periodic Table and

Web viewUsing games: the Periodic Table. Using games: the Periodic Table. Using games: the Periodic Table. . 2

Periodic Table – Filling Order Electron Configurations and the Periodic Table

Periodic Table and Periodic Trends