Post reply

Databases per instance

  • August 24, 2011 at 12:52 am

    #246863

    I am managing 9 mirrored database on one instance.Is this set-up ok?

    “When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

  • August 24, 2011 at 1:33 am

    #1372382

    ya you can setup principle servers in one instan e and mirror dabases in one instane

  • August 24, 2011 at 2:39 am

    #1372401

    OK,was acttually worried about the number of mirrored databases per instance.

    “When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

  • August 24, 2011 at 3:03 pm

    #1372857

    With ample hardware you should be fine mirroring 9 DBs. The upper bound has to do with how many worker threads required by each mirroring session (i.e. sessions are per DB). See Paul's post here:

    http://www.sqlservercentral.com/Forums/FindPost901266.aspx

    The entire thread is a good read for learning about the cross-over between when to mirror and when to cluster.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • August 25, 2011 at 6:49 am

    #1373099

    Thank you.

    “When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply