Browse by Tags

All Tags » /faster   (RSS)
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 , , , , , , , ,
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 , , , , , ,
New Article on SQL CAT: Initializing a Transactional Replication Subscriber from an Array-Based Snapshot by Benjamin Wright-Jones
Preamble I had the opportunity to perform a tech review of a very cool article by Benjamin Wright-Jones : Initializing a Transactional Replication Subscriber from an Array-Based Snapshot The array of geekly luminaries who contributed include SQL CAT members Read More...
Posted 15 May 09 12:19 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 , , , , , ,
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 , , , , ,
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 , , , ,
Office Outlook 2007 CU/HotFix f/u: "Best version of Outlook ever" per MS VP Will Kennedy
This is a follow-up to last week's post in which I shared the fantastic perf enhancements in the latest-&-greatest Outlook 2007 Cumulative Update / HotFix. My post prompted a reply from Will Kennedy, Microsoft Corporate VP of Outlook & InfoPath. Read More...
Posted 16 March 09 09:40 by Jimmy May | 1 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 , , , , , , ,
Architecture Journal: Green IT in Practice: SQL Server Consolidation in Microsoft IT
I'm a lucky guy. Besides the fact that I'm healthy, alive, & living on the planet earth "in interesting times" as the fortune cookie says, I had the opportunity to contribute to an article which appeared in the Green IT issue of The Architecture Journal: Read More...
Posted 10 March 09 11:12 by Jimmy May | 1 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
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 , , , , ,
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 , , , , ,
More Posts Next page »

Search

This Blog

Syndication

Page view tracker