Browse by Tags

All Tags » Performance   (RSS)
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 , , , , ,
SQL CAT New Whitepaper: Data Compression: Strategy, Capacity Planning and Best Practices by Sanjay Mishra, et al.
Data Compression: Strategy, Capacity Planning and Best Practices Hot off the presses, the SQL CAT team has just published a new whitepaper for which I had the opportunity to provide a technical review. The author is SQL CAT best practices maven Sanjay Read More...
Posted 29 May 09 02:07 by Jimmy May | 1 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 , , , , , ,
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
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 , , , , ,
MSDN Blog Box Beefed Up and SProcs Tweaked For New! Improved! User Experience
A few weeks ago Cindy Gross brought this tweet to my attention from SQL Server MVP Jason Massie : statisticsio : I should pdf the essential posts from @ aspiringgeek and sqlcat because everytime I really need them blogs.msdn.com is crawling. http://twitter.com/statisticsio/statuses/1377928792 Read More...
Posted 16 April 09 12:26 by Jimmy May | 4 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 , , , , , , ,
Disk I/O: Microsoft SQL Server on SAN Best Practices from SQL CAT's Mike Ruthruff (& Prem Mehra)
While at the PASS Community Summit in November 2008, I had the pleasure of attending a handful of excellent presentations. One of the best was delivered by Mike Ruthruff (& not just because he shilled for my presentation on disk partition alignment Read More...
Posted 01 March 09 11:44 by Jimmy May | 3 Comments   
Filed under , , , , ,
Attachment(s): Mike_Ruthruff_SQLServer_on_SAN_SQLCAT.zip
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 , , , , ,
Perception, Reality, & Incrementally Tuning World-Class Applications
Performance & the 20% Rule I was reading the post from Ed Glas , Make Your Performance Work Count: The 20% Rule . He shared the words of computer science professor & billionaire entrepreneur David Cheriton: If it is fast and ugly, they will use Read More...
Posted 07 January 09 07:32 by Jimmy May | 6 Comments   
Filed under , , , , ,
Disk Partition Alignment (Sector Alignment) for SQL Server: Part 4: Essentials (Cheat Sheet)
The purpose of this post is to document Disk Partition Alignment Essentials. It is intended for engineers who are already familiar with disk partition alignment yet want a “cheat sheet”. As most of you know, partition alignment is an essential best practice. Read More...
Posted 04 December 08 10:40 by Jimmy May | 11 Comments   
Filed under , , , , , ,
Attachment(s): Disk Partition Alignment (Sector Alignment) for SQL Server - Part 4 - Essentials (Cheat Sheet) -- Jimmy May.zip
Case Study: Part 2: CXPACKET Wait Stats & 'max degree of parallelism' Option: Suppressing Query Parallelism Eliminated CXPACKET Waits & Liberated 30% of CPU
Introduction This is the second of a four-part series: Introduction to Query Parallelism Parallelism Suppression: Analysis, Remediation, & Results (this post) Parallel Query Identification & Remediation Summary Executive Summary In my first post Read More...
Posted 02 December 08 11:49 by Jimmy May | 3 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
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
More Posts Next page »

Search

This Blog

Syndication

Page view tracker