PowerShell: Automating SQL Stats Collection for Performance Tuning

Speaker: Prakash Heda, Senior DBA at Advent Software

You can use PowerShell to collect stats from all SQL Servers in your environment, storing them in a centralized database server, available for server baselining and performance tuning.

Dynamic Management Objects (DMOs) allow us to see what's going inside SQL Server. You can use PowerShell to collect data snapshots for comparing performance for any desired duration.

You'll learn

Some of the key DMOs used used in baseline/tuning How to capture Memory/CPU stats How to capture queries stats along with actual execution plans How to capture and evaluate Database Growth How to capture database I/O stats Prakash Heda is with Advent Software. His expertise includes Performance Tuning/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 and MCITP. His background includes development in VB and ASP; SSIS; data warehouse development using SQL Server 2000, 2005 and 2008 R2 and SQL server 2012. He's a frequent presenter at user groups, SQL Saturdays, and other PASS community events. He's also an avid tweeter, blogger and runner.