Presenting “PowerShell: Automating SQL Stats Collection”

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