June 12, 2006 at 5:57 am
I'd be interested to hear if anyone has set up multiple mirrored databases in a production environment and how many.
Also interested if anyone mirrors on clustered sql server and if failover has been tested successfully.
Lastly anyone mirroring on multiple instances in production.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
June 14, 2006 at 11:17 am
Sat in a briefing by Microsoft on this one. The most the speaker (one of the program managers at Microsoft) had seen mirrored from one server was 20, and that was in a purely test scenario at Microsoft. He said if numbers are creeping up that high, another solutions is probably necessary.
K. Brian Kelley
@kbriankelley
June 14, 2006 at 11:36 am
It sounds too familiar ... as if it is using the the old replication algorithm of processing things ...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
June 15, 2006 at 9:31 am
Microsoft have indicated to me a max of 10 mirrors per instance and you need a really good line/link . I was hoping to find evidence of users deploying mirroring in production.
I understand that there can be issues with clustered servers mirroring .. seems no-one will own up to using mirroring !!!
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
June 17, 2006 at 9:12 am
Mirroring didn't gain full support until SP1 and since that is really new, not a lot of folks have likely implemented it in production as of yet.
K. Brian Kelley
@kbriankelley
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply