On 10th Oct 6.30 PM, I will be presenting “PowerShell: Automating SQL Stats Collection for Performance Tuning”@ at San Francisco SQL Server User Group, If you are in the area I hope to see you…

Location:Microsoft 835 Market Street, San Francisco, CA

Register Here

Session Detail: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.

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
  • About Prakash Heda

    Prakash Heda works as Sr. Database Administrator at Advent Software. His expertise includes Performance Tuning/Troubleshooting, high availability, SAN configuration and windows administration. He has 13+ years of experience managing enterprise-wide data needs in both high volume transactional and data warehouse environments. Prakash holds certifications for MCDBA and MCITP. His background includes administration & development using VB/ASP/SSIS using SQL Server 2000, 2005 and 2008/R2 and SQL server 2012. He is an active member of PASS, SQL Saturday. He's a frequent presenter at user groups, SQL Saturdays, and other community events. Connect me on Facebook | Twitter | Google + | LinkedIn | Blog | Photography