Fine Tuning Production SQL Servers

Speaker: Prakash Heda, Advent Software

Production SQL servers require constant proactive monitoring and fine-tuning for optimal performance and high availability. You'll learn how DBAs perform quick health checks and performance tuning on production databases to ensure high uptime.

Prakash will demo various deadlocking/blocking/top queries scenarios and share scripts to automate them.

You'll learn how to:

Perform quick health checks for production db servers Track and capture disk/database usage Track and capture and report deadlocks/blocks Identify the top SQL queries which needs performance tuning Prakash Heda is a Senior Infrastructure DBA at Advent Software. His expertise includes Performance Tuning and troubleshooting, high availability, SAN configuration, and Windows administration. He manages enterprise-wide data needs in both high volume transactional and data warehouse environments. Prakash holds certifications for MCDBA/MCITP, and his background includes development in VB and ASP, SSIS, and data warehousing using SQL Server 2000, 2005, and 2008 R2.