1 / 13

Steve Hood Blog: SimpleSQLServer

Monitoring and Baselines. Steve Hood Blog: SimpleSQLServer.com. Monitoring and Baselines. Every Server is Unique. Continuous Baseline for 13 Months. What to Watch?. Traces – Snapshot Wait Stats – Cumulative Blocking – Snapshot Query Stats – Cumulative Index Stats – Cumulative

bartons
Download Presentation

Steve Hood Blog: SimpleSQLServer

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Monitoring and Baselines Steve HoodBlog: SimpleSQLServer.com Photo "Laptop and Stethoscope" by jfcherry on Flickr CC

  2. Monitoring and Baselines Photo "Monitor" by Boyce Duprey on Flickr CC

  3. Every Server is Unique Photo "snowflakes" by koogy on Flickr CC

  4. Continuous Baseline for 13 Months Photo "Lucky 13" by Thomas Hawk on Flickr CC

  5. What to Watch? • Traces – Snapshot • Wait Stats – Cumulative • Blocking – Snapshot • Query Stats – Cumulative • Index Stats – Cumulative • OS Perf Counters – Varies • Database and Table Sizes - Snapshot

  6. Traces – Fill your drives Photo "Overflowing" by roblonmom on Flickr CC

  7. Traces vs. Extended Events Photo "crossroads" by Laenulfean on Flickr CC

  8. Traces – Enough days to matter Photo "Calendar Card - January" by Joe Lanman on Flickr CC

  9. Wait Stats – Wasted Time Photo "clocks in a dumpster" by jasonvance on Flickr CC

  10. Wait Stats – Filter Them Out

  11. Wait Stats – 1 and 7 Days Ago Photo "7 Mosaic" by Leo Reynolds on Flickr CC

  12. Blocking – Who’s in Your Way Photo "Driving Cars in a Traffic Jam" by Leo Reynolds on Flickr CC

More Related