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

Prakash Heda works as Manager (Database Team) at SS&C Advent Software. His expertise includes Automation, 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 to 2016. 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.