The San Francisco SQL Server User Group – Oct 10 2012

Thanks you everyone for attending session, here is the presentation DAC….


Check how to use DMO sys.dm_exec_query_stats and sys.dm_io_virtual_file_stats for finding top CPU/Memory/IO queries with scripts…

Detect Worst Performing SQL Queries – Part 3

About Prakash Heda

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. Connect me on Facebook | Twitter | Google + | LinkedIn | Blog | Photography