PowerShell: Automating SQL Stats Collection for Performance Tuning

  • October 10, 2012 · 6:30 PM
  • Microsoft Office

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.


Join or login to comment.

47 went

Our Sponsors

Imagine having a community behind you

Get started Learn more
Bill

I started the group because there wasn't any other type of group like this. I've met some great folks in the group who have become close friends and have also met some amazing business owners.

Bill, started New York City Gay Craft Beer Lovers

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy