Browse by Tags

All Tags » Tools   (RSS)
Xperf: Install Windows Performance Toolkit (WPT) with 242MB Download, Not the Entire 2.5GB Windows 7 SDK: Part 1
Say It Ain’t So! In my first post on Xperf , I described the simple 4.4MB download necessary to install the Windows Performance Analyzer (WPA) & the other tools which comprise the Windows Performance Toolkit (WPT), including Xperf. I was surprised Read More...
Posted 22 November 09 06:00 by Jimmy May | 1 Comments   
Filed under , , , , ,
SQLIOSim Parser by Jens Suessmeyer & Yours Truly
New! Improved! v.3.3.0 Now Available on CodePlex ! Preamble SQLIOSim Parser shreds the results of SQLIOSim.log.xml in seconds, allowing easier & more accurate interpretation of the output of SQLIOSim. SQLIOSim is a tool written by CSS Engineer Bob Read More...
Posted 27 September 09 10:32 by Jimmy May | 4 Comments   
Filed under , , , , , , , ,
Wait Stats by Joe Sack
Wait stats rock. As I shared recently with friends, when it comes to SQL Server performance, wait stats are the #1 arrow in my quiver, the first tool out of my toolbox, the Vera of guns (see the Firefly episode Our Mrs. Reynolds to divine that reference). Read More...
Posted 27 April 09 11:15 by Jimmy May | 2 Comments   
Filed under , , , , ,
Attachment(s): Joe Sack wait stats.sql
Analyzing Storage Performance by Robert Smith on the Counter-of-the-Week (COTW) Blog
In my role with MS IT's Assessment, Consulting, & Engineering ( A.C.E. ) team, I work with some of the best application perf engineers in the world. However, A.C.E. doesn't have a monopoly on talent; there are some great engineers throughout Microsoft. Read More...
Posted 19 March 09 06:27 by Jimmy May | 0 Comments   
Filed under , , , ,
VSTS Web Test Step-by-Step Primer: 7-Minute Video by Microsoft A.C.E. Performance Engineer Chris Lundquist (with Copious Notes and Screen Shots from Your Humble Correspondent)
My decision to focus on the SQL Server vertical has paid off for me—metaphorically & literally. Now it's time to spread my wings a bit & learn about Visual Studio Team System (VSTS) web testing. Spread Your Wings! http://www.youtube.com/watch?v=JtsJDTyY95g Read More...
Posted 23 February 09 05:00 by muysal | 1 Comments   
Filed under , , , , ,
SSMS Query Results: “Include column headers when copying or saving the results"
In my work with external customers, I collaborate with some excellent DBAs & Architects. But I've noticed many of them are not aware that you can capture column headers from query results to grid in SSMS. When a very bright engineer I work with—not Read More...
Posted 22 February 09 10:40 by Jimmy May | 4 Comments   
Filed under , , , ,
Disk Partition Alignment (Sector Alignment) for SQL Server: Part 2: Adding HP EVA 8000 to Veritas Enterprise Administrator “Track Alignment Settings” Dialog
Background In a previous post I documented the importance of disk partition alignment as a foundation for optimal disk I/O performance. In the lab & in the field we’ve commonly found performance enhancements of 30% - 40% by a variety of metrics. Though Read More...
Posted 04 November 08 04:05 by Jimmy May | 4 Comments   
Filed under , , , ,
Drum Roll, Please...The Debut of The SQL DMV All-Stars Dream Team!
The introduction of Dynamic Management Views (DMVs) in SQL Server 2005 provides us with all manner of wonderful information, much of which was heretofore difficult or even impossible to get. Yet I often hear confusion about their use. People ask, "But Read More...
Posted 30 October 08 10:29 by Jimmy May | 7 Comments   
Filed under , , , , ,
Attachment(s): DMV_All-Stars_v20090701.sql
Is Twitter the YouTube of 2008?
Always in pursuit of the elusive creature known as Work/Life Balance, I discard activities which monopolize my scarce bandwidth. I even struggled with tagging this post under "Productivity". Yet it struck me that Twitter was reaching critical mass, so Read More...
Posted 19 October 08 01:24 by Jimmy May | 3 Comments   
Filed under , , ,
PerfMon Objects, Counters, Thresholds, & Utilities for SQL Server
I’m frequently asked questions about which PerfMon counters to use & what thresholds to rely on. I’ve been amalgamating this information for years in the form of an Excel workbook: PerfMon_Counters_Digest_w_Vital_Signs_Correlation_v6.xls . The current Read More...
Posted 15 October 08 09:44 by Jimmy May | 7 Comments   
Filed under , , , , , ,
Attachment(s): PerfMon_Counters_Digest_w_Vital_Signs_Correlation_v6.xls

Search

This Blog

Syndication

Page view tracker