DigitalConcourse.com - On-Demand Business Communities
 
Email this Page» Next»

Email
Password
Save Password? 
Forgot your password?
First Time User?
  
 

DCMS Community

Community Calendar
 
 


 
September PASSMN Meeting: Partition Alignment and Wait-Time Based Performance Mangement

SQL Server and Partition Alignment

&

Wait-Time Based Performance Mangement

September 15, 2009

3:00 PM - 5:15 PM

 This Month's Sponsor:
Sponsor: Confio 

Last Month's Sponsor:
Sponsor: EMC

 

SQL Server and Partition Alignment

Speaker: Jimmy May, Microsoft

Now that SQL Server wait stats are formally documented & DMVs are available, disk partition alignment may be the best kept secret related to database performance optimization. In combination with stripe unit size & file allocation unit size, learn how you can increase I/O throughput by 10%, 30%, & under some circumstances even more. Many customers are unaware of partition alignment. Even experienced disk administrators may be unfamiliar with it. Explanations are often initially met with disbelief. Engineers familiar with the topic may underestimate its importance. For example, some customers think it is useful only for Microsoft Exchange Server. In fact, partition alignment is important for all servers from which high performance is expected, especially SQL Server. Each month I encounter customers with unaligned storage. Until existing misaligned partitions created using Windows Server 2003 or Windows 2000 Server are rebuilt properly, disk partition alignment will remain a relevant technology.

 

Jimmy May  is a Principal Performance Engineer for Microsoft’s Assessment, Consulting, & Engineering (A.C.E.) Services & works for Team Lee. He is the Founder & Visionary-in-Chief of SQL Server Pros & was formerly the Senior Database Architect for one of the world’s largest OLTP DBs. He is a founder & on the executive committees of both the Indiana Windows User Group & Indianapolis Professional Association for SQL Server . Jimmy lives in Indianapolis, Indiana with his lovely bride, Phyllis, & Fannie May the Wonder Dog. Subscribe to & read his blog at msdn.blogs.com/jimmymay. Contact him at jimmymay@microsoft.com or aspiringgeek@live.com.


 

 Wait-Time Based Performance Management

Speaker: Janis Griffin, Confio

 

Using Wait Time Analysis and Wait Types is a newer method for tuning SQL Server instances. As a result, there is often confusion on exactly what the data means. The issue typically centers around the fact the wait time data is analyzed at the wrong level or the collected wait time data is not detailed enough. This presentation will focus on these problems and review several real-life case studies of using SQL Server Wait Type data coupled with Wait-Time based performance analysis to solve the most difficult performance related issues.

Janis Griffin has over 20 years of DBA experience including design, development and implementation of many critical database applications. Before coming to Confio, Janis held DBA positions primarily in the Telecom Industry (15 yrs), working with both real-time network routing databases and OLTP business to business applications.

 

Janis was also a Principal Architect and Senior Manager, mentoring other DBAs on best practices in database performance tuning. She was responsible for managing all aspects of the Voice Network databases including short and long-term technical planning and strategic alliances. As a highly successful liaison between management and technical staff, Janis has proven to be an effective collaborator implementing cutting-edge database solutions.


When
Date: Tuesday, September 15, 2009
Registration: Monday, August 31, 2009 to Tuesday, September 15, 2009
   (Registration Closed)
Time: 3:00 pm - 3:15 pm PASSMN Announcements
3:15 pm - 5:15 pm Presentations

Add to Calendar?
Current Weather: Conditions for Minneapolis, MN at 12:53 am CDT

Current Conditions:
Fair, 75 F

Forecast:
Sun - Mostly Sunny. High: 87 Low: 68
Mon - AM Clouds/PM Sun. High: 89 Low: 73

Full Forecast at Yahoo! Weather

(provided by The Weather Channel)

Maps Additional Route Directions»
Contact
Name: Eric Strom
Phone: (952) 3585291
This site is sponsored by

 
 

DigitalConcourse.com™- all rights reserved - ©2003-2010 - Privacy Policy - Terms of use