sql server database health check script

1. SQL Server 2000 database Dictionary (table structure. SQL) Select top 100 PERCENT -- a. id, Case when a. colorder = 1 THEN d. name ELSE ''end as table name,Case when a. colorder = 1 THEN isnull (f. value, '') ELSE'' end as table description,A. colorder as field No., a. name AS field name, case when columnproperty (a

address, and then use Curl to detect return code, found very good, basic 1 minutes will be able to produce resultsHere's the scripting code: #!/bin/bash #Author: Zhangge #Date: 2014-08-21 #Desc: Check The site of Zgboke Alliance. #取出网站数据 data= '/usr/bin/mysql-uroot-p123456-e "use Zgboke;select web_url from dir_websites where web_status= ' 3 ';"-n-b | awk ' {print '} ' if [-Z ' $data '];then echo ' faild to connect

Tags: mysql from mysql stateCheck the status of the MySQL master- Slave synchronization architecture (from a master-to-one) from the database server (IP Authorization, whether the server and Io are normal, from my SQL process is normal)Master mysql:192.168.1.10From mysql:192.168.1.20[Email protected] ~]# VI check_s

Cookie $http _cookie; Proxy_set_header X-real-IP $remote _addr; Proxy_set_header X-forwarded-For $proxy _add_x_forwarded_for; Proxy_set_header X-forwarded-Proto $scheme; Client_max_body_size 300m; } }} Provides two load interfaces, same server, same IP, same port. Second: monitoring and inspection of nginx load back end In fact, the above configuration file has been configured in the Health

int update (String sql){Close ();Open ();SqlCommand sc = new SqlCommand ();Sc.commandtext = SQL;Sc.commandtype = CommandType.Text;Sc. Connection = conn;int x = SC. ExecuteNonQuery ();Close ();return x;}Traversing data in a tablePublic SqlDataReader Sdread (String sql){Close ();SqlDataReader SDR;Open ();SqlCommand cmd = new SqlCommand ();Cmd. Connection = conn;Cm

"${update_sql}"Mysql-h${hostname}-p${port}-u${username}-p${password} ${dbname}-E "${select_sql}"#删除数据Delete_sql= "Delete from ${tablename}"Mysql-h${hostname}-p${port}-u${username}-p${password} ${dbname}-E "${delete_sql}"Mysql-h${hostname}-p${port}-u${username}-p${password} ${dbname}-E "${select_sql}"Show Processlist How to filter the problem I finally know how to fix it.MYSQL-UROOT-E-p password ' show processlist\g ';Mysql-uroot-e ' show processlist\g ' |grep ' Info ' |grep-v "NULL" |awk-f ":"

Several common creation methods are listed a few days ago. SQL Server Login , Login , User , System stored procedures used by roles and Groups , Of course, you also need to check Connectiongstring String SQL Server Login and

Label:MYSQL-HHOSTNAME-PPORT-UUSERNAME-PPASSWORD-E mysql-related SQL statements without running MySQL at the prompt of MySQL, which means you can manipulate MySQL in the shell. #!/bin/Bash HOSTNAME="192.168.111.84"#数据库信息 PORT="3306"USERNAME="Root"PASSWORD=""DBNAME="test_db_test"#数据库名称 TABLENAME="test_table_test"#数据库中表的名称 Create a database Create_db_sql="CREATE database