Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2007
    Posts
    15

    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!

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Perfmon can run in the background of a server. That's what I use.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •