Browse by Tags

All Tags » Best Practices » Architecture   (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 , , , , , , , ,
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 | 6 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 , , , ,
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 , , , , , , ,
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 , , , , ,
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 , , , , ,

Search

This Blog

Syndication

Page view tracker