Browse by Tags

All Tags » Fundamentals   (RSS)
Xperf: Install Windows Performance Toolkit (WPT) with 242MB Download, Not 2.5GB Windows 7 SDK: Part 2
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 to learn that the Read More...
Posted 24 November 09 02:18 by Jimmy May | 1 Comments   
Filed under , , , ,
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 , , , , ,
A Rendezvous With Destiny: PASS 2009 (#sqlpass)
Rendezvous With Destiny Forty-five years ago, Ronald Reagan aka Ronaldus Magnus spoke to Americans of our rendezvous with destiny . In a few short days the SQL Community will rendezvous in Seattle for the PASS 2009 Summit . This time last year, eager Read More...
Posted 30 October 09 09:04 by Jimmy May | 2 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 , , , , , , , ,
Aspiring Geek Speaks This Week Yet Again: Perpetual Technologies (PTI) Back-to-School with Microsoft and Oracle Event
Yesterday I flew to Minneapolis to speak at PASS MN on disk partition alignment . I left for the airport immediately afterward to get home to Indianapolis in order to speak at Perpetual Technologies, Inc. ( PTI ) 2nd Annual Back to School with Microsoft Read More...
Posted 16 September 09 09:47 by Jimmy May | 0 Comments   
Filed under , , , , ,
Attachment(s): SQLIOParserWin_0.2.3.0.zip
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 Read More...
Posted 08 September 09 11:10 by Jimmy May | 2 Comments   
Filed under , , , , ,
sys.dm_db_index_operational_stats: Kick Your Assumptions: Part 1
A two-part tale in which your humble correspondent interrogates databases & Very Smart Persons (VSPs), & is forced to kick his ass- umptions regarding a popular DMF. Executive Summary Documentation for the DMF sys.dm_db_index_operational_stats Read More...
Posted 03 August 09 09:17 by Jimmy May | 0 Comments   
Filed under , , , , , ,
Disk Partition Alignment (Sector Alignment): Make the Case: Save Hundreds of Thousands of Dollars
I recently collaborated with Microsoft PFE Daniel Janik to create a template to make the case for disk partition alignment. Perhaps your customers or stakeholders within your organization can benefit. This work was recently broadcast throughout PFE DLs Read More...
Posted 08 May 09 02:15 by Jimmy May | 1 Comments   
Filed under , , , , , ,
A Language for Software Architecture by JD Meier in The Architecture Journal
J.D. Meier is a Principal Program Manager for Microsoft’s Patterns & Practices team.  He’s a great writer & a clear thinker.  J.D.’s Sources of Insight is devoted to getting results & balancing life. His latest-&-greatest publication Read More...
Posted 28 April 09 09:41 by Jimmy May | 0 Comments   
Filed under , , , ,
Wait Stats Introductory References
Preamble For those of you who are already facile with SQL Server wait stats, there’s nothing new here. However, if you’re a n00b, this is a great place to start. History As I commented here on SQL MVP Jason Massie’s blog , I first became aware of the Read More...
Posted 26 April 09 06:23 by Jimmy May | 3 Comments   
Filed under , , , , ,
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 , , , ,
Disk I/O Case Study: Classic Case of SAN Over-Subscription
SAN Over-Subscription There are a variety of challenges related to I/O performance. One common problem is "SAN Over-Subscription", which is characterized by the the following symptoms: High disk latency and Low IOPs & Throughput As MS PFE & fellow Read More...
Posted 15 March 09 09:21 by Jimmy May | 2 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 , , , ,
sp_reset_connection Does NOT Reset TRANSACTION ISOLATION LEVEL: Unexpected Behavior By Design
I've long been an advocate of the best practice of explicitly setting the transaction isolation level in my scripts. At my old day job as an enterprise architect I mandated that along with SET NOCOUNT ON , the preamble for all SProcs explicitly must declare Read More...
Posted 02 February 09 12:44 by Jimmy May | 6 Comments   
Filed under , , , , ,
More Posts Next page »

Search

This Blog

Syndication

Page view tracker