CACTI monitoring SQL Server database graphic

Template Download:

(1) can directly download the site released Cnyunwei-cacti+nagios integrated fully automatic installation ISO for installation, has integrated this template and more use of plug-in templates
(2) You can go directly to the official forum to download the latest template http://forums.cacti.net/viewtopic.php?f=12&t=38135

php-mssql Configuration:

Cacti must have php-mssql drive on the machine.
php-m | grep MSSQL to see if there is MSSQL, if not installed, direct Yum installation can

Yum Install php-mssql-y

Cacti configuration:

1. Import add MS SQL Monitor template Console–import Templates \ Browse Selection

Cacti_host_template_windows_-_sql_server.xml Save

After importing graph templates contains:

Windows-sql Server-backup/restore I/O
Windows-sql Server-buffer Cache
Windows-sql server-connections
Windows-sql Server-log Cache
Windows-sql server-log Flush I/O
Windows-sql Server-log Flushes
Windows-sql server-memory
Windows-sql server-page I/O
Windows-sql Server-page Splits
Windows-sql server-procedure Cache
Windows-sql server-processes Blocked
Windows-sql Server-sql Compilations
Windows-sql server-table Scans
Windows-sql server-temp Tables
Windows-sql server-transactions

2, upload ss_win_mssql.php to cacti directory under the scripts directory, and give permission

3, SQL Server executes the statement to give the monitoring permission, and the protection wall to give 1433 port corresponding IP access rights

Use master

CREATE LOGIN cactistats with Password=n ' www.cnyunwei.com ', default_database= master,default_language=us_english, Check_expiration=off,check_policy=off

EXEC Sys.sp_addsrvrolemember @loginame = n ' cactistats ', @rolename = n ' processadmin '

CREATE USER cactistats for LOGIN cactistats with default_schema=dbo

GRANT SELECT on Sys.dm_os_performance_counters to Cactistats

4, in the MS SQL Server to be monitored, create the appropriate users, pay attention to password settings, modify the password in the ss_win_mssql.php and corresponding

function Ss_win_mssql ($hostname, $cmd, $username = null, $password = null) {
List ($host, $port) = Explode (': ', $hostname);
$port = ($port = = "? ' 1433 ': $port);
$username = ($username = = NULL? ‘Cactistats': $username);
$password = ($password = = NULL? ‘www.cnyunwei.com': $password);

5. When adding a monitoring device, the Host Template selects "Windows–sql Server"

Script test:
/usr/bin/php-q/var/www/html/scripts/ss_win_mssql.php 122.xxx.xxx.xxx Scans Cactistats www.cnyunwei.com
fullscans:114947 rangescans:4428184 probescans:4228710 indexsearches:8975892

php/usr/local/cacti/scripts/ss_win_mssql.php 122.xxx.xxx.xxx Connections

Userconnections:10

Some of the monitoring pictures show:

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/4C/06/wKiom1Q2p8OArvIxAAVXscIi0Gg425.jpg "style=" float: none; "title=" 135022imydknqoloozlwe7.jpg "alt=" Wkiom1q2p8oarvixaavxscii0gg425.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/4C/08/wKioL1Q2p_uTJy8hAATNV-qOA0A044.jpg "style=" float: none; "title=" 135021imaa8jj99kkc22dp.jpg "alt=" Wkiol1q2p_utjy8haatnv-qoa0a044.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/4C/08/wKioL1Q2p_rRwJSwAASm8go6YQw001.jpg "style=" float: none; "title=" 135021b7p7zqqp7o4o4llp.jpg "alt=" Wkiol1q2p_rrwjswaasm8go6yqw001.jpg "/>

This article is from the "Operations" blog, please be sure to keep this source http://cnyunwei.blog.51cto.com/21929/1561922

CACTI monitoring SQL Server database graphic