Setting Thresholds For Mirroring Alerts
Dec 31, 2007
Hi all,
I have configured some Mirroring alerts based on Micosoft's documents. Mirroring.
If you can help me in setting some of the "Thresholds" for the Mirroiring alerts. That will be helpful, because i didnt see anywhere about the actual threshold limits setting for alerts ( In Production). Any approx. also OK.
At Principal:
(a) Unsent Log = ------ KB
(b) Oldest Unsent Transaction = ---- Minutes
At Mirror:
(c) Unrestored Log = ---- KB.
(d) Mirror Commit Overhead = --- MilliSeconds
Thanks again.
View 3 Replies
ADVERTISEMENT
Aug 15, 2007
I have set up thresholds for time behind and I'm getting an event 32040 in the eventlog when the threshold has been exceeded. I have also set up a SQL Agent Alert with a email operator. However the alert is never generated (and no email sent). Shouldn't it be possible to alert an operator as described in http://www.microsoft.com/technet/prodtechnol/sql/2005/mirroringevents.mspx also???
The email profile is working and also setup on the SQL Agent, and the SQL Agent has been restarted (just in case that's necessary).
What did I miss? Any ideas?
/Thomas
View 6 Replies
View Related
Aug 15, 2012
We have occasional problems with transactional replication between 2 databases, and the problem is we dont notice right away. Usually the customer notices a few days after replication has stopped, and thats no good. We want to be notified as soon as there is any problem related to replication so we can go in and figure it out.
Ive been playing with the alerts, and it LOOKS like I should be able to do what I want, but after several hours I still cannot make any of the alerts work.
In my test environment, I'm forcing the following error, in order to try and test an alert: error 20598 "The row was not found at the Subscriber when applying the replicated command."
This seems to be one of our more common errors, and also its really easy to produce, so it seemed like a good candidate for testing the alert.
First off, I noticed that the agent profile was set to "Continue on data consistancy errors", which ignores error 20598. So I changed the profile to "Default", which doesnt skip any errors.
Next I set up a simple Job that simply writes a string to a file. I tested the job by calling it manually and it works. Once i can prove that this job is actually being called, I will change it to email me and the team.
Then I created a new alert in the publisher database which watches for error code 20598. Its response is to call the job I mentioned above. So when the error occurs, a string should be written to that file.
Then I forced the 20598 error to occur. I deleted a row in the subscriber DB, and then changed the corresponding row in the publisher. This causes the error to occur. In my replication monitor, I see new entries saying "Skipped 1 error(s) when applying transactions at the Subscriber." I'm not sure why it says skipped, but I know that these entries are the 20598 error that I'm trying to produce.
Now, there was nothing written to my text file, and I can see from the job history that my job was never called. If I look at the history of my test alert, it says "never occured".
I forced the 20598 error to occur, and I have an alert that is watching for the 20598 error, but it never fires.
I also created an alert in the subscriber database, watching for the same error. This alert was not called either.
View 5 Replies
View Related
Oct 7, 2002
Hello Guys,
I have a Question. I want to set up a sql alert that will monitor a particular counter(Eg. Memory:pages/sec) and send me an email when it reaches a particular threshold.
My question is if i set up this, Will sql will start running a perfmon on the background and degrade server's performance
OR
Will it just read it from some system file or something to to get the values.
I dont know if the perfmon counter values are stored in any system files or not.
Please advise..
thank you in advance.
View 1 Replies
View Related
Dec 10, 2002
We are running SQL Server 2000 on a w2k server. I want to set up alerts to notify me through SQL Server Agent. The doc states to open the Mail icon in Control Panel but on this server there is no Mail icon. I thought that if Outlook Express was installed on the server the mail icon would be there. We have OE installed but there is no Mail icon.
Any ideas?
Thanks.
Joe
View 7 Replies
View Related
Sep 15, 2015
I need to set up asyncronous data replication across two clustered instances of SQL 2012 across 2 Datacenters. Both the datacenters have a common domain however the vlans are different. There are only 3 small databases on the primary instance.
any issue in setting up mirroring in this case as vlans are different.
Operating system is Windows 2012.
View 2 Replies
View Related
Jun 21, 2007
In my environment Mirroring is set up and the Principal/Primary and secondary are set up as well. I am having trouble added my mirror as a logshipping primary.
BOL says to create the Mirror/Primary I need to use the Transact-SQL commands. But sp_add_log_shipping_primary_database checks to make sure the status of the database is "Online". So when I run sp_add_log_shipping_primary_database to add the mirror db as a Primary I get the following error:
Msg 32008, Level 16, State 1, Procedure sp_add_log_shipping_primary_database, Line 58
Database TestMirror is not ONLINE. Cannot proceed with log shipping primary processing.
Am I doing something wrong? I am following the BOL page http://msdn2.microsoft.com/en-us/library/ms187016.aspx .
View 5 Replies
View Related
May 28, 2007
hi guys , does anyone of you have a good solution on the Error 1413: Communications to the remote server instance failed before database mirroring was fully started issue?
Best Regards,
Hans
View 1 Replies
View Related
Oct 20, 2011
I have setup database mirroring with witness server. To prevent unnecessary failover because of network slow or other issue, I changed the timeout setting as
ALTER DATABASE <Database Name>
SET PARTNER TIMEOUT 120
Which I understand if connection is broken between principal and mirror, principal database will wait for 120 second and after that only automatic failover will happen.
If this is true, it does not happen in my case. Failover happens before120 second.
View 5 Replies
View Related
Dec 14, 2006
I had a problem with mirroring that I only was able to resolve when I attempted to replicate instead. Replication gave me an error message that expained the problem; mirroring simply failed.
Is there any place where mirroring logs the details of what it is doing & why it is failing?
BTW, the problem was that the server name was changed after SQL was installed. Although i knew this, the forums indicated taht SQL 2005 automatically picks up the new name after it is restarted. This apparently is not true...
Thanks
Dave S
View 2 Replies
View Related
May 24, 2006
I attempted to setup database mirroring using a High Availability scenario but when I installed SQL is chose to use local system accounts for all the services. Consequently, I stubled upon a microsoft article explaining how to setup mirroring using local system accounts and certificate authentication but I am stil not able to get it to work. When I try ti initiate the mirror from the mirror server I receive an error stating "Neither the partner nor the witness server instance for database "EDENLive" is available. Reissue the command when at least one of the instances becomes available." I have checked all the endpoints and everything seems to be in order. I even checked to make sure that each server was listening on the appropriate ports and I AM able to telnet to the ports. Please help!
View 1 Replies
View Related
Mar 18, 2015
I have a data table in below format and the need the desired output in 2nd table format
TABLE1
RANKBOOLEANREVENUE
1TRUE100
2FALSE150
3FALSE200
4FALSE250
5FALSE300
[code]....
Desired Output to be:
RANKBOOLEANREVENUERUNNINGTOTAL
1TRUE 100250
2FALSE150400
3FALSE200600
4FALSE250850
5FALSE3001150
[code]....
View 3 Replies
View Related
May 3, 2008
Server A = primary SQL DBs (mirroring origination)
Server B = failover SQL DBs (mirroring destination)
For database mirroring a witness is required.
Can the witness live in another instance of SQL on server B?
View 7 Replies
View Related
Oct 12, 2015
Using SQL Server 2008, we would like propose mirroring between two servers of a critical database. Since we initiate, may require to clarify on its purpose and also required changes from application end.Any changes required from OS Level? (I believe both servers IP or Host name should be added in host entries. Mirroring ports should be allowed/open including Principal and mirror server IP Addresses): Windows Team.Any changes required from Application? (Instance name, authentication: user name and its password should be added in web config files): Application Team.Any changes required from Network Team?Also for mirroring both the principal and mirror servers should be with same version, does it only mean SQL Server 2008 versions are enough or does it also mean to say build numbers 10.00.4000 should also be same.URL....
View 5 Replies
View Related
Feb 9, 2000
Is there any recommendations on setting up Alerts. What are the standard set alerts that should be setup on every server?
View 1 Replies
View Related
May 9, 2002
I have to send the alerts when the database(s) will be filled more than 90% and 95%. Please help me if you have some samples.
Thanks,
Rau
View 1 Replies
View Related
Jun 20, 2008
I ignored this nice little feature till now, probably because mail configuration complexities. Now that we have DB mail, it has become very smooth.
I just implemented an alert for log growth, and found that it works very well.
Any of you using, alerts for , other interesting events?
------------------------
I think, therefore I am - Rene Descartes
View 4 Replies
View Related
Jun 20, 2006
Hi everyone,
I also could not find any definition about Alerts and their purpose and usage.
Would you please explain it to me ??
Thanks
View 4 Replies
View Related
Oct 31, 2000
Is there a way that I can get SQL Server to tell me (Alert?) when it has grabbed another chunk of space for a database that has the "Automatically grow file" option set?
View 1 Replies
View Related
Dec 2, 1999
I was wondering if anyone knew of some key error numbers that I should look for to fire alerts off of.
For example, ERROR 926 "Database cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server error log for more information."
I am looking for some key error messages (Error Numbers) like the one above that are good to initially setup within SQL Server for alerting Administrators of potential issues.
Thanks,
Peter
View 1 Replies
View Related
Dec 4, 2002
Hi,
I just realized there are several severity alerts on the Server Agent, from Severity 19 to 25.
Is there anyways to delete those messages? If I don't delete those, would it be affected later?
The Online Book mentions those are some of the system error messages, but they don't show how to delete them.
Can anyone helps?
Thanks a lot.
View 6 Replies
View Related
Nov 3, 2005
Hi,
I am having trouble with locks and performance issues in one application. The SQL server is specific to this application. What settings should i choose to set an alert to let me know when i get too many locks? the locks i am interested in ar ethe ones that show up in SQL EM. ie where a process is blocking another process(es).
I have tried New Alert | lock requests /sec but that is a huge figure when the server is running OK, so i cant guess what value to set for the counter. Is there a better object/counter i should use?
thanks
fatherjack
View 5 Replies
View Related
Dec 14, 1998
I've setup alerts and an operator to email on a particular event code.
I can successfully test the operator. (It e-mails fine)
The problem I am having is that despite having a particular event
log to the NT application log, no SQL Alert is triggered.
I've tried logging to the NT Application log, as well as the SQL errorlog.
The SQLExecutive is running.
Thanks in advance.
John
View 1 Replies
View Related
May 4, 2001
I am working with alerts and trying to see if there is a way that I can control the message on the notification. I have the job set to send an email and a net message when the job succeeds. Since this message will be going to the user, I owuld like to be able to make the message as clear as possible for them. Does anyone know if the message being sent can be modified or altered with an alert? And how?
Thanks!!
View 1 Replies
View Related
Feb 17, 2005
Hey guys,
I was just thinking, is it possible to send alerts via the Managment/SQL Server Agent/Operators/Alerts to an SMS system?
Is it even technically posibble?
Actually I am trying to develop an alert system that reads the database table periodcally, the data being read is a datetime, once it reaches the time, I need to send an sms to the person.
Any suggestions? ideas? Quickest solution?
View 1 Replies
View Related
Mar 22, 2004
I defined an Alert in Enterprise Manager for Severity 19 - Fatal Error In Resource. The alert is enabled, the type is "sql server event alert" and the alert is defined against a specific database. SQLSERVERAGENT and SQL Mail session are both started. I test the alert using the following statement in the specified database.
raiserror (50001,19,1) with log
A message is placed in the SQL Server log, however no alert is fired. The alert history indicates the alert has never occurred. What am I missing?
Thanks, Dave
View 8 Replies
View Related
May 29, 2008
hi
how are the use alerts in sql server2005,
and which alert type used in maximum and how to performaing our database
I would like to get user experiences
View 3 Replies
View Related
Aug 9, 2001
Does anyone know of a way, either by 3rd party tools or using SQL server, to have alerts get emailed to you in a clustered active/active environment? I work as the DBA at a quickly-growing company, whose production databases need to be online 24X7. I want to set up the alerts to email/page me if there are problems with the databases, but since (according to microsoft) SQL mail is not supported in a clustered environment I'm at a loss.
I'm looking for some help in trying to resolve this issue either by 3rd party means or a SQL Server work around.
Your help will be greatly appreciated.
Sincerely,
Tony
View 1 Replies
View Related
Sep 28, 2001
Can anyone point me in the direction of a good resource
that will help us set up our system so that
notifications from alerts/jobs send emails to our
Groupwise email system?
View 1 Replies
View Related
Mar 7, 2001
Hello all,
Here's the problem I'm trying to solve:
I have several alerts set up and a job setup to notify via email if alerts occur. There are times when I might be doing maintenace on a box that may generate alerts but I don't want to get emailed or paged for these "dummy" alerts. I thought first of setting the enabled column of sysalerts to 0 - that doesn't work. I still get notified. Then I thought I'd set the enabled column in sysjobs for my notification job to 0 while I'm doing the work. But as soon as I re-enable the job I get an alert. It seems that as soon as the job is re-enabled it checks the NT application log and sees that an alert was fired and somehow knows that there was no notification sent so sends one. If I purge the NT application log before re-enabling the job is solves the problem. But that is a very in-ellegant solution and I don't want to loose all the info stored in the event log any way. Does anyone know how SQL SErver aggent keeps track of this stuff? (ie. that an alert was fired but it's response job is disabled and to check once a job is re-enabled to see if any alerts occured while it was disabled?) I did a Profiler trace while re-enabling the job but didn't see anything pertinant in there.
Thanks in advance.
Patrick
View 2 Replies
View Related
Nov 30, 2000
I want to write a sql alert to notify me when my database is out of space.
So as not to duplicate any messages - has anyone seen threads on this subject?
If not, can anyone give ideas on how to create this script?
thanks in advance.
View 1 Replies
View Related
Jun 3, 2004
I'm searching for tips on how to alert users regarding downtime of our SQL Server. Is it good enough to alert users by email, and then shut down the service, or do you use a better approach (lock database, sp_who, one-by-one alert...)?
Thankful for all replies.
Newbie in DB administration.
View 1 Replies
View Related
Aug 19, 2004
I want to creat an alert that will back up my database when the log files get to 90% full. When i try to create a new alert and select performance condition and select sqlserver:databases as the object then log file(s) Used size (kb) as the counter but when i go and select the instance i dont see my database in the drop down list but if I change to sql server event alert I see the database i want to use for this alert. I dont want to wait until the log is already full to back it up i want to do it when it hits a percent full. Is there a way to do this as a performance condition? thanks for your help!
View 7 Replies
View Related
