http://www.sqlservercentral.com/blogs/sqlfeatures/2012/10/13/presentation-dac-powershell-automating-sql-stats-collection-for-performance-tuning/

Printed 2014/08/27 05:17AM

Presentation DAC: PowerShell: Automating SQL Stats Collection for Performance Tuning

By Prakash Heda, 2012/10/13

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
Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.