Title: SQL Server Baseline for Performance Diagnostics - Try to beat the “All Depends” Scenarios
Speaker: Kun Lee
Abstract: We have all heard the response “It All Depends” when it comes to a solution for SQL Server performance tuning. In this presentation we will demonstrate how having a baseline will help to reduce this situation. The collected metrics can provide better justification for your recommendations when you talk to your system administrators, developers, network administrators or your management. Throughout this session, I will talk about what you want to baseline when you get a brand new system as compared to an existing system when there is a performance problem. Some of the techniques I will demonstrate can be used to troubleshoot existing performance issues for many different area such as Virtual Machines, Physical servers, SANs, DAS, Network, etc.
Meeting Sponsor: SQL Power Tools (http://www.sqlpower.com/)