Lost Rings and Other Monitoring Stories

cakeexoticInternet και Εφαρμογές Web

13 Δεκ 2013 (πριν από 3 χρόνια και 9 μήνες)

80 εμφανίσεις

Lost Rings
and Other Monitoring Stories
Grant Fritchey
Product Evangelist - Red Gate Software
Goals
• Learn a few of the more obscure methods for
monitoring servers
• Know where these methods are applicable
• Understand how to interpret the results from
these methods



Grant Fritchey
• Product Evangelist for Red Gate Software
• Email: grant.fritchey@red-gate.com
• Twitter: @gfritchey
• Blogs: scarydba.com
simple-talk.com/community/blogs/scary
Agenda
• My Precious
• Workers
• Get Me to the Church
• Status Quo
• Stalling
• Waiting
• An Event to Remember

My Precious: sys.dm_os_ring_buffers
• Use
– Out of memory alerts
– Internal memory pressure
(VAS)
– External memory pressure
(OS)
• Results
– Check for existence

Will have to parse XML




http://lotr.wikia.com/wiki/One_Ring
Workers: sys.dm_os_workers
• Use
– A measure of workload
– State of ‘running’
• Results
– One result must be
compared to a previous
result or to the baseline
http://deanoinamerica.wordpress.com/2012/01/02/metropolis-fritz-langs-science-fiction-classic/
Get Me to the Church:
sys.dm_os_schedulers
• Use
– A measure of workload
– State of ‘is_idle = 0’
• Results
– One result must be
compared to a previous
result or to the baseline
http://vonemmel.com/page/2/
Status Quo: DBCC MEMORYSTATUS
• Use
– Dump of all memory
– Need to find Target &
Current
• Results
– Target should be less
than current
http://www.covershut.com/cover-tags/Status-Quo-Blue-For-You-LP.html
Stalling: sys.dm_io_virtual_file_stats
• Use
– Io_stall_read_ms
– Io_stall_write_ms
– Io_stall
– Sample_ms
• Results
– Must compare to
baseline
http://tawnasrandomthoughts.blogspot.com/
Waiting: sys.dm_os_wait_stats
• Use
– Signal wait time for CPU
– LIKE 'PAGEIOLATCH%' for
Disk
– And the rest
• Results
– Numbers must be
compared to history or
baseline
http://www.bing.com/images/search?q=waiting&view=detail&id=050D795F9478BB5C5864EDDF5
45CAFA1D0DAA83C&first=31&FORM=IDFRIR
An Event to Remember: Extended
Events
http://www.testically.org/2011/03/11/creating-an-event-including-a-picture-on-facebook-with-the-graph-api/
• Use
– 2008 or better
– Roughly like Trace
• Results
– No automated tools for
this… yet
Resources
• Scarydba.com/Monitoring
Questions?

Grant Fritchey
• Product Evangelist for Red Gate Software
• Email: grant.fritchey@red-gate.com
• Twitter: @gfritchey
• Blogs: scarydba.com
simple-talk.com/community/blogs/scary