Browse by Tags

All Tags » Disk I/O   (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 , , , , ,
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 , , , , , ,
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 , , , , , , ,
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
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
Disk Partition Alignment (Sector Alignment) for SQL Server: Part 3: PASS 2008
I've spoken publicly several times this year to crowds large-&-small: TechReady 6 (an internal Microsoft conference) Indy Tech Fest ITT Commencement Last week was my first external international conference, the Professional Association for SQL Server Read More...
Posted 25 November 08 12:24 by Jimmy May | 5 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 , , , ,
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
Disk Partition Alignment (Sector Alignment) for SQL Server: Part 1: Slide Deck
<Note: 20081119: Deck updated w/ new graphics, perf metrics, & dynamic disk info> <Note: 20090225: Deck updated & moved to skydrive > <Note: See also Disk Partition Alignment (Sector Alignment) for SQL Server: Part 4: Essentials Read More...
Posted 14 October 08 11:57 by Jimmy May | 18 Comments   
Filed under , , , , , ,
Attachment(s): DPA Deck Info.txt

Search

This Blog

Syndication

Page view tracker