Sign In
Jimmy May, Aspiring Geek: SQL Server Performance, Best Practices, & Productivity
News you can use on implementation of the elusive sqlservr.exe /faster switch & personal effectiveness
Translate This Page
Translate this page
Powered by
Microsoft® Translator
Options
Email Blog Author
RSS for posts
Atom
RSS for comments
OK
Search
Advanced search options...
Search In:
Everything
Blogs
Forums
People
Groups
Places
Pages
Date range:
All Time
Last Year
Last 6 Months
Last 3 Months
Last Month
Last Week
Last Two Days
Tags
/faster
Architecture
Best Practices
Career
CPU
Discipline
Disk I/O
Disk Partition Alignment
Effectiveness
Engineering Discipline
Fundamentals
Geekly
Me
Miscellaneous
News
Performance
Personal Productivity
Productivity
Scalability
Speaking
SQL CAT
SQL Server
Tools
Training
xperf/ETW/WPA/WPT
Archive
Archives
November 2009
(2)
October 2009
(1)
September 2009
(4)
August 2009
(1)
May 2009
(5)
April 2009
(5)
March 2009
(9)
February 2009
(3)
January 2009
(1)
December 2008
(4)
November 2008
(3)
October 2008
(4)
September 2008
(2)
June 2008
(1)
November, 2008
MSDN Blogs
>
Jimmy May, Aspiring Geek: SQL Server Performance, Best Practices, & Productivity
>
November, 2008
Posts
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Jimmy May, Aspiring Geek: SQL Server Performance, Best Practices, & Productivity
Case Study: Part 1: CXPACKET Wait Stats & 'max degree of parallelism' Option: Introduction to Using Wait Stats to Identify & Remediate Query Parallelism Bottlenecks
Posted
over 4 years ago
by
Jimmy May
3
Comments
This is the first of a four-part series: Introduction to Query Parallelism (this post) Flipping the Bit Expensive Query Identification & Remediation Summary Query Parallelism The SQL Server configuration option max degree of...
Jimmy May, Aspiring Geek: SQL Server Performance, Best Practices, & Productivity
Disk Partition Alignment (Sector Alignment) for SQL Server: Part 3: PASS 2008
Posted
over 4 years ago
by
Jimmy May
5
Comments
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...
Jimmy May, Aspiring Geek: SQL Server Performance, Best Practices, & Productivity
Disk Partition Alignment (Sector Alignment) for SQL Server: Part 2: Adding HP EVA 8000 to Veritas Enterprise Administrator “Track Alignment Settings” Dialog
Posted
over 4 years ago
by
Jimmy May
4
Comments
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...
Page 1 of 1 (3 items)