Prakash Heda works as Sr. Database Administrator at Advent Software. His expertise includes Performance Tuning/Troubleshooting, high availability, SAN configuration and windows administration. He has 13+ years of experience managing enterprise-wide data needs in both high volume transactional and data warehouse environments. Prakash holds certifications for MCDBA and MCITP. His background includes administration & development using VB/ASP/SSIS using SQL Server 2000, 2005 and 2008/R2 and SQL server 2012. He is an active member of PASS, SQL Saturday. He’s a frequent presenter at user groups, SQL Saturdays, and other community events. He is also an avid tweeter, blogger and runner.
Archives: February 2012
Best way to tune production server is to find out what are the queries executed in a particular duration and how many times it got executed, thus to concentrate on tuning top hitting queries ASAP...check out the video and scripts
Join SQL Server experts as they take an in-depth look at the hottest SQL Server topics over 24 consecutive (and free!) technical webcasts. The learning starts on March 21, 2012 beginning at 00:00 GMT (that’s a March 20 evening start for the Americas).