Unanswered: Powershell as a performance monitoring solution?
I've been reading a lot on Powershell recently.
I'm trying to find a light-weight performance solution for my servers.
I see that Powershell can query Counters, and output them to SQL.
I used the example from: Collecting data with PowerShell
And that worked just fine for me.. but what I'd like to do is run a Powershell hourly, and have it pump Counter data into a SQL Table.. so I can later report off of it.. and watch baseline info, and spikes, etc.
I don't really want to use PerfMon, or Typeperf.. since I don't want tasks sitting on-screen on my server.
I'd like SQL to fire off a Powershell task, insert the results to a table.
Is anybody doing this? Or maybe I'm looking at the wrong tool?
Thanks for any advice you might have!