1 / 13

Continuous Server Monitoring and Baselines for Optimal Performance

Explore the importance of continuous monitoring and baselines in maintaining server performance. Learn to use traces, wait stats, blocking analysis, query stats, and index stats effectively. Understand the significance of OS performance counters and database sizes snapshots over time.

bartons
Download Presentation

Continuous Server Monitoring and Baselines for Optimal Performance

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