Clever Geek Handbook

Database mirroring and logistics

I have set up both mirroring and logarithm for 8 databases about 10GB each size in one instance, but now when I want to mirror another database it takes very long to show the database property page. Any suggestions for this issue.

+1


source to share


2 answers


I am assuming you are using "ALTER DATABASE [dbname] SET SAFETY FULL" as this will cause the databases to update synchronously (for example, your transaction will not complete until it completes on both database servers ).

If you have high latency between servers, you will experience significant performance degradation.



You can use "ALTER DATABASE [dbname] SET SAFETY OFF", which will not give you full mirroring (the slave may fall behind and you will have to manually crash), but you will not get a performance penalty.

See BOL for details.

+1


source


You can set up tracing and see what happens when the GUI makes a SQL call.



I had a similar problem with a database that was migrated from 2000 to 2005 but ended up clearing up on its own.

0


source






More articles:


All Articles