Solved

mirroring

Posted on 2011-03-09
5
550 Views
Last Modified: 2012-05-11
hei!
   getting this error many time a day, on a few servers..
"09:00MSSSPI-3086.1: Size of unrestored log in the redo queue on the mirror database <$OPTION(database_name)> is 371.00 too high (>=95.00) for hswdbp01.  [Policy: DBSPI-3086]"

Tried to go in task,launch mirror activities, but just could not find any help

anyone out their ....
0
Comment
Question by:shanj
  • 3
  • 2
5 Comments
 
LVL 39

Expert Comment

by:lcohan
ID: 35096308

"Unrestored log threshold (set up at the mirror server): helps estimate how long it would take the mirror server to roll forward the log records remaining in its redo queue. We send an alert if the redo queue exceeds a certain threshold, usually between 250 kilobytes (KB) and 500 KB. The actual value may change for each database depending upon the database's workload and behavior patterns.
We run an initial script on the mirror that looks for any databases participating in database mirroring. It sets a baseline log threshold value for each database. Each mirrored database gets the same initial setting.
We run a second script on the mirror server that adjusts the threshold value for any databases that may need a different value due to differing patterns of update activity."

http://msdn.microsoft.com/en-us/library/ee355221(v=sql.100).aspx

You should be able to chnage the treshold that by using kb article below:

http://msdn.microsoft.com/en-us/library/ms408393.aspx


0
 

Author Comment

by:shanj
ID: 35106269
Hi Icohan!
     the information u sent to me is just perfect.
I went thru it a few times but ....
I still am not getting it.

1. I launch the databasemirroring, on the plane warnings, no threshold i set up ( not enabled)

Thus i do not know what i should add their, ..?? any suggestions

appreciate your email.


PS: the 2 articles u sent me explains a lot, but i do not know where the threshold value is set up, and futher more how much should i change it to...
//shan
0
 
LVL 39

Expert Comment

by:lcohan
ID: 35109351
Use sp_dbmmonitorhelpalert database_name to see the existing values of the trheshold alert(s)
http://msdn.microsoft.com/en-us/library/ms365405.aspx

Then use sp_dbmmonitorchangealert database_name  to set new values for an existing alert(s)
http://msdn.microsoft.com/en-us/library/ms365376.aspx

0
 

Accepted Solution

by:
shanj earned 0 total points
ID: 35131109
Thanks for your info.

But again, i have done what the document says, but i get NULL and NULL  at the threshold is enabled or no.
bye for your kind patience
0
 

Author Closing Comment

by:shanj
ID: 35170967
The advise was excellent but it did not solve my problem, i have to look somewhere else, maybe hardware, dandwidth..etc..etc..
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question