Sorry about that, here's the info.
From what I understand, you can use almost any perfmon counter that exists on your Windows box.
Use perfmon to identify the counter you wish to monitor.
Then you can monitor it with NSClient++.
For example :
from a Windows 2008 box with SQL 2008 Enterprise
Click the + icon
Find the Counter and Add it
SQL1.png
Then right click the counter down the bottom and select Properties.
SQL2.png
Now you will be shown the properties of the counter.
SQL3.png
The counter you can see is in almost the same format that the NSClient++ command requires. The correct formatting is:
\\SQLServer:General Statistics\\User Connections
All I have done is added an extra backslash at the begining and in the middle.
To monitor this counter, just run the Windows Server Monitoring Wizard. Under the Performance Counters section add the following:
(Tick the first box and clear the existing values)
Performance Counter:
\\SQLServer:General Statistics\\User Connections
Display Name:
SQL User Connections
Counter Output Format:
Number of user connections is %.f
No need for warning and critical values at this point.
Finish the Wizard and click Apply.
This service should now appear under your host and produce a pretty graph.