The most recent content from our members.
Hi... Can anyone help me with a SQL query to generate a alert if the database synchronization fails. For example synchronization goes into suspended mode. If a database on one server fails or goes offline and is unable to sync to the database on other server then it should generate an alert. I know we can write a custom…
,1. I saw these previous posts about monitoring SQL Mirrors in SolarWinds http://thwack.solarwinds.com/message/168142#168142 http://thwack.solarwinds.com/message/165415#165415 2. Then I thought of using SolarWinds "SQL Server End User Experience Monitor" to execute a TSQL statement to pull back the status of the servers…
Hello, We recently configured ASync DB mirroring for a particular application in our environment. I would like to know if it is possible to use APM or NPM to monitor the status of this SQL mirror. I envision being able to gather stats about the change rate, amount of data transferred, how far behind, and also generate an…
It looks like you're new here. Sign in or register to get started.