SQL Server 2000 Connections via WMI

[DevilSun]

As the title says, SQL Server 2000 connections...

Usage:

Code: Select all

perl <path_cacti>/scripts/w32_sql_query_connections.pl <hostname> get UserConnections,LoginsPersec,LogoutsPersec

*NOTE - I haven't found Logins/Logouts per sec to be very useful in my scenario so I am not graphing them.

Addendum - If you're using SQL 2000 on Windows 2000, you need to change the script class to "Win32_PerfRawData_MSSQLSERVER_SQLServerGeneralStatistics" to make it work. Thanks to chewy009 for this info.

[JVandermark]

I imported this template into cacti and go the following:
[success] SQL - Connections [update]
+ Unmet Dependency: (Data Template Item)
+ Found Dependency: (GPRINT Preset) Normal
+ Unmet Dependency: (Data Template Item)
+ Found Dependency: (GPRINT Preset) Exact Numbers
+ Unmet Dependency: (Data Template Item)
+ Unmet Dependency: (Data Template Item)

Looking in the data input methods section, there is nothing for SQL- Connections. I'm going to try and figure it out, but if you get a chance can you look into it?

[pshankland]

Think me thick but I have managed to import the XML via 'Import Templates' and I have copied the *.pl files into <cacti_install>\scripts\*.*

My question is.... what do I have to do then??

Thanks.

[DevilSun]

Here is the data template, it should be included in the graph template though so I dunno...

[DevilSun]

Think me thick but I have managed to import the XML via 'Import Templates' and I have copied the *.pl files into <cacti_install>\scripts\*.*

My question is.... what do I have to do then??

Thanks.

Go create a Data Input Method, of type "Script/Command", input string like

Code: Select all

perl <path_cacti>/scripts/w32_sql_query_connections.pl <hostname> get UserConnections,LoginsPersec,LogoutsPersec

and setup the fields as shown. You gotta match up the fields and what not...

[pshankland]

Cheers for the reply. I have done what you have said but the graph never gets generated - I just get the red-cross thingy.

I have imported the Graph Template OK and I have then created a Data Input Method as per your instructions but still get no graph. Any suggestions??

Thanks.

Code: Select all

perl <path_cacti>/scripts/w32_sql_query_connections.pl <hostname> get UserConnections,LoginsPersec,LogoutsPersec

[DevilSun]

I see the problem. This is that data source disconnect problem that happened to me a version or two ago, a lot of my templates got hosted in that nature, and I've rebuilt quite a few, but some don't want to be fixed.

Here's what I believe you need to do. Go edit the graph template. See where it says "(No task)" next to each graph item under the Data Source column? That means, that graph item is not associated with the data source. My suggestion would be to delete the existing Graph Item input data source, and then go to each graph item itself, and select the Data Source. The reason I say to delete the existing Graph Item Input data source ("Data Source [user_count]") is because as soon as you add it again to the graph item, it'll duplicate the existing one and you won't know which to delete. For each graph item, set the data source to "SQL - Connections - (user_count)". That should work unless there is something else going on.

[pbulteel]

I'd like to use this, but I'd be polling from a linux host...

Would that mean I'd install activeperl on the sql server and ....

Hmm... I might have to do something like what's mentioned in

http://forums.cacti.net/about4670.html

-P

[Thomas]

If you want to monitor Windows Servers using WMI from Unix/Linux please have a look at http://forums.cacti.net/viewtopic.php?t=5842.
I have summarized all possible ways (as far as I know them) to get WMI information from Unix/Linux.

[Riceman]

I have a set of clustered MSSQL 2000 \ Win2k servers that both respond to WMI queries for cpu and mem etc, but when I query using this perl script I get this.

Any ideas?

Check the computer and class name.
No information was found on the specified class!

Thanks in advance,


Nick

[pshankland]

I know this script is for WMI but just as a word of caution if you want to monitor Microsoft SQL Servers that are clustered using SNMP...... DON'T!! It seems that the Intel SNMP agent can cause a load of problems that you really don't want in a clustered environment!

http://support.microsoft.com/default.as ... -us;811876

Cheers.

Pete.

[Riceman]

Roger that, I am just running the windows SNMP service on these machines. Thanks for the heads up.

I was wondering if I need to install the mof files for SQL since my machines think they don't have this class needed for this application.


Thanks,


Nick

[DevilSun]

Riceman, check these links, they might help...
http://support.microsoft.com/default.as ... -us;827260
http://support.microsoft.com/default.as ... -us;820847

[Riceman]

Thanks for the help bro. Looks like it might be my problem.


Thanks again,


Nick

[Jvona]

Did you ever figure anything out with this, niether of these solutions helped, I even reinstalled sql making sure snmp was enabled before install.

When running the script I get the same error as Riceman. Any suggestions are much appreciated.

Thanks!

Jason