Monday, March 12, 2012

LIMITs on MIRROR with SQL Server SE

Hi folks. I'm trying to clear up some licensing confusion I"ve come across. First, if I use MIRROR on SS SE I am limited to a single REDO thread and Sycn mode. I see that on the Web. Will the singel REDO thread hurt the ability for the Secondary to keep up? Any one done any tests?

My confusion comes from a document that came across my desk a long time ago that showed that if you use MIRROR on SQL Server SE you are limited to 4 processors for the entire cluster. So if you wanted a balanced failover you would have to have two 2-ways in essence. Is this true? Is it not longer true? I can't seem to find any mention of this....did someone give me bad advice? Help! Thanks.

Licensing will not hurt any performance, only the number of transactions will have the recovery of REDO and UNDO process during the recovery.

|||In standard edition you wont get parallel redo and database snapshots features in the case of database mirroring.

No comments:

Post a Comment