This is a vbs plugin to fetch the performance metrics from a SQL Server.<\/p>\n
To install it:
\n1. Create the directory “%Program Files%pandora_agentplugins” if needed.
\n2. Download the file “sqlserver_plugin.vbs”.
\n3. Copy it to the previosuly created plugins directory.<\/p>\n
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:<\/p>\n
SQLServer> CREATE LOGIN [(user)]\r\nSQLServer> WITH PASSWORD=N'(pass)',\r\nSQLServer> DEFAULT_DATABASE=[master],\r\nSQLServer> DEFAULT_LANGUAGE=[us_english],\r\nSQLServer> CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF\r\nSQLServer> GRANT VIEW SERVER STATE to [(user)]\r\n<\/pre>\nNOTE: NEVER use an account with full privileges.<\/p>\n
Also check the driver availability on the system via the “Data Sources (ODBC)” section of your windows “Administrative Tools”.<\/p>\n
Then just call it from the config file of your agent with the following line:<\/p>\n
\"module_plugin memory_plugin <user> <password> <host> <driver>\"\r\n<\/pre>\nNOTE: if <driver> has white spaces in its name it must be double-enquoted.<\/p>\n
For more plugin options or change warning and critical levels see its code.<\/p>\n
Files:<\/h2>\n