CACTI monitoring SQL Server database graphic

Source: Internet
Author: User
Tags install php mssql

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.