MS SQL 2008 Monitoring

arshadkhan20

2012-10-15 09:00:01 UTC

arshadkhan20 [http://community.zenoss.org/people/arshadkhan20] created the discussion

"MS SQL 2008 Monitoring"

To view the discussion, visit: http://community.zenoss.org/message/69143#69143

--------------------------------------------------------------
Hi,

I am using Zenoss core 3.1 and ubuntu 64bit Desktop version. I want to monitor MS SQL 2008 databases so i have install below zenpacks along with their dependenciesÂ i -e FreeTDS and ODBC driver as by below.

etc/freetds/freetds.conf

*[SQLTEST]*
*host = SQLTEST*
*port = 1433*
*instance =*
*tds version = 8.0*

etc/odbcinst.ini

*[FreeTDS]*
*DescriptionÂ Â Â Â Â Â Â Â Â Â Â Â = TDS driver (Sybase/MS SQL)*
*DriverÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â = libtdsodbc.so*
*SetupÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â = libtdsS.so*
*CPTimeoutÂ Â Â Â Â Â Â Â Â Â Â Â =*
*CPReuseÂ Â Â Â Â Â Â Â Â Â Â Â Â Â =*
*UsageCountÂ Â Â Â Â Â Â Â Â Â = 1*

etc/odbc.ini

*[SQLTEST]*
*Driver = FreeTDS*
*Servername = SQLTEST*
*Port = 1433*

and able to connect sql via isql on zenoss machine as well.

***@NMS:~# isql -v SQLTEST UID Password
+---------------------------------------+
| Connected!Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â |
|Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â |
| sql-statementÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â |
| help [tablename]Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â |
| quitÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â |
|Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â |
+---------------------------------------+

and install mention below zenpacks

*ADVANCED DEVICE DETAILS*
*RDBMS MONITORING*
*SQL DATA SOURCE*
*MS SQL DATABASE MONITOR*

Kindly guide me which parameters i need to set on zenoss i-e ,Connection string,instance and UID , Password so i can recieve database monitoring graphs as well.

Regards,
Arshad Ahmed
--------------------------------------------------------------

Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/69143#69143]

Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]