October 10, 2012 · 6:30 PM
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.
- 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.