Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rlaubert
Yak Posting Veteran
96 Posts |
 Posted - 2007-02-26 : 14:34:22
|
| I am trying to create a set of procedures that will monitor the performance of multiple servers and alert based on preset values. I have it working using Perfmon into a SQL DB and sysperfinfo table in Master.What I want to do now is find a way to directly access the performance counters on each machine WITHOUT having to use Perfmon to store them in a database for me. This way I can remotely gather the information and act on it immediately if needed.Since the counters are always 'on' and SQL's sysperfinfo is collecting data on SQL, there has to be a way of accessing the informaiton from the server OS side.Has anyone done this before? How can I access this informantion?Thanks, Raymond LaubertMCDBA, MCITP:Administration, MCT |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2007-02-26 : 15:18:27
|
| You will have to look up WMI (Windows Management Instrumentation), and see if you can make out how ot retrive the counters in their raw form. If you know VB script, this will be much easier, as most of the scripting examples use VB script. |
 |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2007-02-26 : 17:04:17
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=76834rockmoose |
|
|
|
rlaubert
Yak Posting Veteran
96 Posts |
Posted - 2007-02-27 : 08:04:01
|
| Thanks Rock...This is just what I was looking for. Also the scripting tool is nice, wasn't aware of it before.Raymond LaubertMCDBA, MCITP:Administration, MCT |
|
|
|
|
|
|
Accessing Windows Perf Counters