Presenting PowerShell: Automating SQL Stats Collection

Oct 5, 2012
Share on:

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

    • <li>How to capture queries stats along with actual execution plans</li>
<li>How to capture and evaluate Database Growth</li>
<li>How to capture database I/O stats</li><script data-ad-client="ca-pub-2234698597179500" async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>"