Server Profiling… Focus on the Waits
{"Image DocumentName": "Server Profiling\u2026 Focus on the Waits", "Image ImageDescription": "Log, Tempdb, data IO, WaitEvents. Use MS Excel or OpenOffice to plot Requests vs. Waits. Look at monOpenObjectActivity for explanation. The next few slides are from a real-world customer: Illustrates starting with server profiling to see where problems are. Drilling into problems with application profiling. Customer Application Scenario. Message processing for event tracking. Extensive BLOB writes for message data. BLOBs were logged for recoverability (remember this) ObjectID s will be used to protect the customer identity. ~36 Hours of MDA data collected.", "Image XResolution": "37", "Image YResolution": "37", "Image ResolutionUnit": "Pixels/Centimeter", "Image Software": "SlidePlayer", "Image YCbCrPositioning": "Centered"}