addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwchatcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobegmailgoogleimageimagesinstagramlinklocation-pinmagnifying-glassmailminusmoremuplabelShape 3 + Rectangle 1outlookpersonplusprice-ribbonImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruseryahoo

PowerShell: Automating SQL Stats Collection for Performance Tuning

  • Oct 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

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