August 22, 2002 at 5:44 pm
I've set up a couple of counter logs in the Window performance monitor. I always have to start them manually by clicking on start. Does anyone know of a way to start my counter longs via a doc script or something?
-------------------------
Greg Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
August 22, 2002 at 5:59 pm
Perfmon lets you schedule start/stop, thats one way.
Andy
August 22, 2002 at 7:59 pm
Hummmm......
What I really want is to start my counter logs everytime the machine reboot, or everytime they stop running.
Well the scheduling feature help start my counter logs as I described above?
Also is there a way to tell if they are already running?
-------------------------
Greg Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
August 23, 2002 at 5:34 am
No other way that I know of. No direct way to tell its running either. Possibly some kind of hack sending keystrokes to it. Be interested if someone has a better way.
Andy
August 23, 2002 at 8:00 am
That is kind of what I figured. Hopefully there will be something, someday.....
-------------------------
Greg Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
August 23, 2002 at 10:08 am
You can do this with WMI. I started down this path and it was annoyingly complex. No good object model.
I may take another look. Testing Patrol right now and not entirely thrilled with it, so I may head back to WMI.
Steve Jones
August 23, 2002 at 12:20 pm
Has to be a better way and ridiculous not to be able to do a solution using the OS tools. Right up there with the disk defrag that you cant schedule. Gee thanks.
Andy
August 23, 2002 at 1:28 pm
You can get the performance counters through WMI and through Perl scripts (with the right packages installed). It looks like Win XP Pro has a program called LogMan which allows command line start and stop of the Counter Logs. Creation, too. I didn't find anything for Win2K. So unless you do it through something like WMI you are forced to start pulling the counters manually through some other source.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply