(3 votes, average: 3.67 out of 5)

Loading...

SQL Server performance plugin

This is a vbs plugin to fetch the performance metrics from a SQL Server.

To install it:
1. Create the directory “%Program Files%pandora_agentplugins” if needed.
2. Download the file “sqlserver_plugin.vbs”.
3. Copy it to the previosuly created plugins directory.

To use it you need a sql server user with at least “VIEW SERVER STATE” privileges, for that I create a user with only this privilege:

SQLServer> CREATE LOGIN [(user)]
SQLServer> WITH PASSWORD=N'(pass)',
SQLServer> DEFAULT_DATABASE=[master],
SQLServer> DEFAULT_LANGUAGE=[us_english],
SQLServer> CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
SQLServer> GRANT VIEW SERVER STATE to [(user)]

NOTE: NEVER use an account with full privileges.

Also check the driver availability on the system via the “Data Sources (ODBC)” section of your windows “Administrative Tools”.

Then just call it from the config file of your agent with the following line:

"module_plugin memory_plugin <user> <password> <host> <driver>"

NOTE: if <driver> has white spaces in its name it must be double-enquoted.

For more plugin options or change warning and critical levels see its code.

Files:

sqlserver_plugin.vbs