By detecting a test page in the Web to get an HTTP status code to judge the state of the Web server, the source script comes from the Internet, where you can make a small comment for the study of children's shoes like python.
#!/usr/bin/env python#script name check_web_stat.pyImport Socket #tcp建立socket连接用到Import re #正则表达式模块Import Sysdef check_webserver (address,
Script for the remaining space on the Monitoring Server:# Vi size. ShPress a or I to enter the editing mode.#! /Bin/bashName = 'hostname'Date = 'date + % m % d % y'Size = '/bin/DF-H/home | grep T | awk-f [: ""] +' {print $5 }''Size2 = '/bin/DF-H/home | grep T | awk-f [: ""] +' {print $5} '| tr-d' %''Size3 = '/bin/DF-H/home | grep T | awk-f [: ""] +' {print $4 }''If [$ size2-ge "90"]ThenTouch/log/size/$ date
? SQL Server replication requires an actual server name to connect to the server, please specify the actual server name ? 2014-06-12 12:01:10 recently in the study advanced replication
Getting Started with SQL Server replication (i) Introduction to----replicationIntroductionReplication in SQL Server (Replication) is one of the core features of SQL
1. Database Replication
SQL Server 2008 database replication synchronizes data between multiple servers through the publishing/subscription mechanism. We use this mechanism for Synchronous database backup. The synchronous backup here refers to the real-time data synchronization between the backup
Tags: Server reader support view error logging service build Info CLIOriginal: SQL Server local replication subscription for database server read-write separationThe previous paragraph Echosong wrote about MySQL data synchronization to realize the separation of business read
For a geographically dispersed large enterprise organization, to build a large enterprise management information system with typical distributed computer features, it is always necessary to solve a very important problem: how to ensure the consistency of shared data among different database servers. The important problem is that the organization changes the local database with the same structure in different locations, but it is necessary to ensure that the modified database has the same result,
WIN2008 R2 installed on the server, and then did not care about the machine name, after installing the SQL2008 R2 database, configure the ad domain to modify the machine name.Then, when you start configuring Database mirroring synchronization, try the following database replication publication, and the result is "SQL Server
SQL Server synchronous replication troubleshooting method, SQL Server
1. the row cannot be found on the subscription server when the command copied by the application is run.
Solution: Use System stored proceduresSp_browserepl
Reprint Address: http://www.cnblogs.com/echosong/p/3603270.htmlThe previous paragraph Echosong wrote about MySQL data synchronization to realize the separation of business read and write, today we look at SQL Server replication subscription implementation of data read and write separationSQL server
Label:Requirements Description In our production environment, in most cases, we need to have our own operation and maintenance system, including the detection of their own health status. In the event of an exception, an early warning is required, and the form of notification is generally communicated by e-mail. The basic configuration of messages in SQL Server has been analyzed in the previous article, and
The WIN2008 R2 installed on the server does not care about the machine name. After the SQL2008 R2 database is installed, the machine name is changed when the AD domain is configured.
Then, when you start configuring database image synchronization, you first try to copy and publish the database. The result shows that "SQL Server
We usually create
BackupIn
SQL Server, We can achieve this through the following method:
Steps for automatic backup in SQL Server 2005 database:
1. Open SQL Server Management Studio
2. Start the
subscription server.
The number of commands in the distribution database that have not been delivered to the selected subscriber.
A command consists of one Transact-SQL data manipulation language (DML) statement or one Data Definition Language (DDL) statement.
In this case, insert tracer in replication monitor and fi
keep available status Proxy security Select the default proxy account to Click Finish The release was found to be successful, but there was a warning. This is because the proxy service is turned off by default and needs to be started. After starting the agent service, go to view the Snapshot Agent status It's ready to start. This will create the release. 3. Create the subscription in the MySQLServer instance. Choose to find a SQL
I encountered a problem when I was doing an SQL Server 2005 experiment today. The problem is clearly described. I suspect it was caused by the name I used to change the computer. you can use select @ servername and select serverproperty ('servername') to check whether the two results are the same. If they are different, the problem may occur. The following shows the SQL
The problem that I ran into today when I was doing the SQL Server 2005 experiment was that the problem description was clear, and I suspected that I had changed the name to the computer before. You can use the SELECT @ @servername and select SERVERPROPERTY (' ServerName ') In contrast, two results are the same, the problem will not be the same, the following given the solution of the
I encountered a problem when I was doing an SQL Server 2005 experiment today. The problem is clearly described. I suspect it was caused by the name I used to change the computer. you can use select @ servername and select serverproperty ('servername') to check whether the two results are the same. If they are different, the problem may occur. The following shows the SQL
use the DBCC command, DMV, and DMF to monitor which statements are using tempdb.
To make the results simple, we need to restart SQL server before testing.
Then we establish a connection (connection A) in management studio and input the following statement. These statements use the space of tempdb.
Select @ spid
Go
Use adventureworks
Go
Select ge
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.