Maximizing hardware utilization for performance & lower TCO

2012

TL; DR

In this session we will discuss ways to maximize existing hardware utilization to speed up queries. We will analyze cases of performance issue and tune them for better CPU, Storage and Memory utilization resulting in higher performance and lower TCO.

Session Details

In this demo heavy session we will discuss ways to maximize existing hardware utilization to speed up queries. We will analyze specific cases of performance issue and tune them for better CPU, Storage and Memory utilization resulting in higher performance and lower TCO. This level 400 session is for developers and DBAs.

3 things you'll get out of this session

Speaker

R Meyyappan's previous sessions

Maximizing hardware utilization for performance & lower TCO - 2012

Monitoring and Tuning Parallel Query Execution - 2010

Performance Monitoring & Tuning - Documented Tips & Tricks - 2010

Monitoring and Tuning Parallel Query Execution - Part II - 2010

Performance Optimization with SQL Server 2008 - 2009

Let’s make SQL fly - a technical session for developers and administrators who believe in magic! - 2009