xPerf: Once I Was Blind and Now I See
I’ve been aware of the buzz around xPerf for quite some time. I flagged emails from Microsoft Premier Field Engineers Clint Huffman (author of PAL) & Shane Creamer (author of Vital Signs) who in internal DLs both cited the tool way back in 2008.
Robert Smith is also a Microsoft PFE. He is one of Microsoft’s leading engineers for troubleshooting SANs & other challenges related to disk I/O subsystems. He is the author of the ground-breaking KB 929491 on disk partition alignment.
And on top of all that, Robert is also an xPerf expert.
xPerf is the lightweight tool used to capture information from the kernel-based Event Tracing for Windows (ETW). Perhaps you’ll soon be as enthusiastic a supporter as I.
Recently, Robert Smith was generous enough to volunteer some time for a demo. He shared insights which continue to amaze me, showing me how to interpret performance metrics such as:
- Discrete reads & writes
- Discrete I/O size, concurrency, & serial vs. random
- Size of discrete I/Os
- Random writes vs. serial writes (e.g., to a log file)
And perhaps most importantly:
- Identify definitive latencies at Windows vs. storage
- Identify time spent at the driver level (e.g., storport.sys, ntfs.sys, & kernel.sys)
Raise your hand if you’ve ever had an I/O bottleneck & your SAN man says, “Hey, sorry you’re having problems, but everything’s good on our end, we even talked to our vendor…”
xPerf allows us to answer definitively, unequivocally, & without question whether it’s your server, your SAN, or both.
.png)
Such granularity & related aggregations has been heretofore unavailable to me. I believe xPerf will fundamentally change the way I do my job.
Stay tuned for additional details. I intend to share information to help you get started, tips, tricks, & techniques such as Robert shared & a few of my own, & case studies.
Jimmy May, MCM, MCDBA, MCSE, MCITP: DBA + DB Dev
Principal Performance Engineer: SQL Server
A.C.E.: Assessment Consulting & Engineering Services
http://msinfosec.com
http://blogs.msdn.com/jimmymay
www.twitter.com/aspiringgeek
Don’t practice in front of the CIO. A professional prepares ahead of time.
—Pond's 12th Law
Jimmy May is a Principal Engineer for SQL Server in the Microsoft Assessment. Consulting, & Engineering (A.C.E.) team & is assigned to Team Lee. He is the Visionary-in-Chief of SQL Server Pros & was formerly the Senior Database Architect for one of the world’s largest, SQL Server high-throughput OLTP VLDBs. He is a founder & on the executive committees of both the Indiana Windows User Group (www.iwug.net) & Indianapolis Professional Association for SQL Server (www.indypass.org). He is a recipient of the MS IT Gold Star award, is collaborating with the SQL Server Customer Advisory Team (SQL CAT) on a series of SQL best practices papers, & is a member of the Microsoft Oracle Center of Excellence. Jimmy lives in Indianapolis, Indiana with his lovely new bride, Phyllis, & Fannie May the Wonder Dog. Contact him at jimmymay@microsoft.com. Visit his SQL Server performance & personal productivity blog at http://blogs.msdn.com/jimmymay.
“In the late 90’s I made a conscious decision to become a geek, & started working with SQL Server in 1999. Since then it’s been quite a ride—going from the Help Desk to DBA to Architect to entrepreneur to Microsoft Principal Engineer & consultant.”
