Jesse Hurtado
2013-05-15 14:24:25 UTC
Jesse Hurtado [http://community.zenoss.org/people/jesse05] created the discussion
"How to monitor MS SQL on Zenoss 4.2.3"
To view the discussion, visit: http://community.zenoss.org/message/73195#73195
--------------------------------------------------------------
Would anyone be kind enough to share how they've managed to monitor their MS SQL database(s)? I currently have a MS SQL 2005 server I'd like to monitor!
I have the device under /Server/Windows/WMI/MSSQLServer and the graphs for CPU Utilization, Memory Utilization, Memory Paging, and Paging File Usage are displaying nicely BUT the SQL based graphs are empty (MS SQL- Buffer Manager, MS SQL-User Connections, MS SQL-Lock rates, etc.).
I didn't see anything in the Configuration Properties where I could set-up monitoring of the database like I would with MySQL databases so I started searching for help and I've seen users install the MsSQLMon, RDBMS, and SQLDataSource Zenpacks which I have done so successfully. I also have the zenperfsql daemon running. Now I see a zMsSqlConnectionString and zMsSqlSrvInstances in the Configuration Properties.
So my question is where do I go from here? Do I have to add a local template or was it even necessary for me to install those additional zenpacks?
--------------------------------------------------------------
Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/73195#73195]
Start a new discussion in zenoss-users at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]
"How to monitor MS SQL on Zenoss 4.2.3"
To view the discussion, visit: http://community.zenoss.org/message/73195#73195
--------------------------------------------------------------
Would anyone be kind enough to share how they've managed to monitor their MS SQL database(s)? I currently have a MS SQL 2005 server I'd like to monitor!
I have the device under /Server/Windows/WMI/MSSQLServer and the graphs for CPU Utilization, Memory Utilization, Memory Paging, and Paging File Usage are displaying nicely BUT the SQL based graphs are empty (MS SQL- Buffer Manager, MS SQL-User Connections, MS SQL-Lock rates, etc.).
I didn't see anything in the Configuration Properties where I could set-up monitoring of the database like I would with MySQL databases so I started searching for help and I've seen users install the MsSQLMon, RDBMS, and SQLDataSource Zenpacks which I have done so successfully. I also have the zenperfsql daemon running. Now I see a zMsSqlConnectionString and zMsSqlSrvInstances in the Configuration Properties.
So my question is where do I go from here? Do I have to add a local template or was it even necessary for me to install those additional zenpacks?
--------------------------------------------------------------
Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/73195#73195]
Start a new discussion in zenoss-users at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]