SQL Counter File

Rusty Hall rhall at HealthVision.com
Thu Feb 22 17:11:16 CET 2007


    Has anyone tried accessing the performance counter files for SQL
Server 2000 Enterprise on a Windows 2003 server. I am trying to access
SQL Server counter files, but im running into issues with the following
counters SQLServer:SQL Statistics Batch Requests/sec, I can access OS
related counter files on this server.  No luck with any of the SQL
Server Ones. I have added a few command that im trying to work with:
 
./check_nc_net -H $HOSTADDRESS$ -v COUNTER -l "\\SQLServer:SQL
<file://\\SQLServer:SQL>  Statistics\\Batch Requests/sec","Batch Request
per sec is %.f%%"
./check_nc_net -H $HOSTADDRESS$ -v COUNTER -l "\\SQLServer:General
<file://\\SQLServer:General>  Statistics\\User Connections","User
Connections %.f%%"
 
The result I get from the command is -1, which I know is wrong.  I have
nagios 2.5 on Redhat running with NC_NET for windows servers.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20070222/9d392102/attachment.html>
-------------- next part --------------
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
-------------- next part --------------
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null


More information about the Users mailing list