Page 1 of 1

PERF_PRECISION_TIMESTAMP

Posted: Mon Jun 18, 2012 12:41 pm
by ggewehr
I'm looking for perf_precision_timestamp.vbs to monitoring some services like mssql. Where I can found this script? Is part of some wmi package?

Re: PERF_PRECISION_TIMESTAMP

Posted: Mon Jun 18, 2012 3:07 pm
by agriffin
Where'd you hear about this script? I didn't find anything on Nagios Exchange or Google.

Re: PERF_PRECISION_TIMESTAMP

Posted: Mon Jun 18, 2012 3:17 pm
by ggewehr
Its a customized system based on nagios. It calls various vbs to get some informations. This counter specifically monitors sql databases and does not delivery this plugin, so I started a search about this plugin here. I think this come together NRPE. All other vbs came and does not generate any error. I hope someone heard about it!

Re: PERF_PRECISION_TIMESTAMP

Posted: Mon Jun 18, 2012 4:23 pm
by ggewehr
In time, I have open an vbs to see who have wrote them. Some of them has been wrote by Groundwork, but I don't found it.

http://sourceforge.net/project/shownote ... _id=160654

Re: PERF_PRECISION_TIMESTAMP

Posted: Mon Jun 18, 2012 8:02 pm
by jsmurphy
The scripts are located in the zip file here: http://sourceforge.net/projects/gwmos/f ... WMI%201.3/

I took a stab in the dark and just checked the plugins in their file repository and sure enough... there it was.

Re: PERF_PRECISION_TIMESTAMP

Posted: Tue Jun 19, 2012 7:44 am
by ggewehr
Thanks for the reply jsmurphy, but this plugins I'm already have. I don't even know where this perf_precision_timestamp act in wmi context. This mention occurs in 3 items from original script. It appears in this kb from microsoft: http://support.microsoft.com/kb/269481

The counter I traying to monitor is Log cache hit ratio, described in this article: http://www.mssqltips.com/sqlservertip/1 ... -counters/

Is there other script to return this information?

Re: PERF_PRECISION_TIMESTAMP

Posted: Tue Jun 19, 2012 4:04 pm
by agriffin
So, this is a WMI resource or something? If it is, you could monitor it using check_wmi_plus.

Re: PERF_PRECISION_TIMESTAMP (SOLVED)

Posted: Thu Jun 28, 2012 2:05 pm
by ggewehr
Hello everyone!

As I continuing search for some resolution, the "log cache hit ratio" for mssql could be monitored by using an performance monitor query. The counter to monitoring is \SQLServer:Databases(model)\Log Cache Hit Ratio.
Sometimes the answer are in front of you, just takes a little time to see!

Thanks for everyone who posted here some information.

Re: PERF_PRECISION_TIMESTAMP

Posted: Fri Jun 29, 2012 9:25 am
by agriffin
Glad you got it working!