sql server replication monitor script

unified all change the connection address Of course, this article is not about my relocation process, after the establishment of replication, because I did not set the subscription library login user's permission for read-only, resulting in a few days before the development side At the same time inserting new data into the subscription library, causing replication to fail (primary key duplication), distr

SQL Server uses Trigger to monitor the stored procedure change script instance, trigger Stored Procedure The following triggers are used to monitor changes to stored procedures.Create a monitoring table: Create table AuditStoredProcedures (DatabaseName sysname, ObjectName

The script executes at the Distributor! I use it primarily to monitor replication. Here is a case, for reference only! Modify the relevant parameters according to the actual situation /*Description: command is used to monitor replication performance in primary use:1. Executi

(' (event[@name = "Xml_deadlock_report"]/@timestamp) [1] ', ' datetime ') execution_time,xml_data.value (' (Event/data/value) [1] ', ' varchar (max) ') Queryfrom (select Object_name as Event, CONVERT (XML, Event_data) as Xml_datafrom sys.fn_xe_file_target_ Read_file (' C:\temp\deadlock*.xel ', ' C:\temp\deadlock*.xem ', NULL, NULL)) v ORDER by Execution_time--If you want the session to stop capturing events (until you enable the session again), you can use this query:alter EVE NT SESSION [Deadl

Compile a shell script in CentOS to monitor MySQL master-slave replication, Objective: To regularly monitor whether the MySQL master-slave database is synchronized. If not, record the fault time and execute commands to restore the master-slave database to the synchronization state. 1. Create a

This article demonstrates how to build the most basic transactional replication.Environment Preparation: 2 virtual machines:The server names are Repa and Repb,repa are publishers, and REPB are subscribers. Are installed WindowsServer 2008r2 English version (the reason for working in a foreign company). and ensure that the two servers can exchange visits.SQL Server:In the above virtual machine, install SQL

Replication is the most powerful and complex component in SQL Server, so it is unavoidable to replicate errors in specific applications. But, thankfully, SQL Server provides replication management tools-

Objective: To monitor whether the MySQL master-slave database is synchronized, if it is not synchronized, record the failure time, and execute the command to restore the synchronization status. 1. Create script file vi/home/crontab/check_mysql_slave.sh #编辑, add the following code #!/bin/sh # check_mysql_slave Status ip=eth0 #网卡名称 mysql_binfile=/usr/local/mysql/bin/mysql mysql_user=root

topic that will be introduced in the hierarchy at the back of this ladder, so now just click on "Next" instead of making a selection on this form. the next three screens process the Snapshot Agent. on The first screen (Figure ), select Create Snapshot Now, and then tap Next. On the Agent Security screen (Figure ), click the Security Settings button, and then on the open form, select run under the SQL Server