SQL Server Performance

3 SQL Servers, 1 DB file?

Discussion in 'SQL Server Log Shipping' started by kevin922, Oct 8, 2004.

  1. kevin922 New Member

    Hi All,

    I'm new here - didn't spend too much time searching forums but would like to get some type of quick answer to this question.

    We have a DB server handling lots of IDS alerts storing on a 120 GB raid 5 partition (yeah i know, i didn't choose raid 5). We are having serious performance issues due to the amount of things that are occuring on this DB. We have lots of events being stored, then we have lots of people running large queries against the DB. The thought is to get a FC drive array set it up as raid 0+1 store the DB file there, then pysically connect 2 other machines running SQL server (MS2000) and point their data file to the same DB file but somehow put them in a read only mode. The additional 2 servers would be used to run queries against the data file.

    Is this possible? If so, any pointers?
  2. ykchakri New Member

    So, it looks like you want to have 3 database servers pointing to the same data file. Unfortunately, that's not possible.

    But, what you can do is create a copy of the original database on to these 2 additional servers and keep syncronizing these databases with the original, via Log Shipping, replication or some other means.

  3. kevin922 New Member

    quote:Originally posted by ykchakri

    So, it looks like you want to have 3 database servers pointing to the same data file. Unfortunately, that's not possible.

    But, what you can do is create a copy of the original database on to these 2 additional servers and keep syncronizing these databases with the original, via Log Shipping, replication or some other means.



    How quick can it replicate? We need it as near real time as possible
  4. Luis Martin Moderator

  5. satya Moderator

  6. ykchakri New Member

    Trnsactional replication will be almost instantaneous. But, it comes with it's own headaches. But, if you want near real time, this is the way to go. Otherwise, I'd prefer Log shipping over replication.



    quote:Originally posted by kevin922


    quote:Originally posted by ykchakri

    So, it looks like you want to have 3 database servers pointing to the same data file. Unfortunately, that's not possible.

    But, what you can do is create a copy of the original database on to these 2 additional servers and keep syncronizing these databases with the original, via Log Shipping, replication or some other means.



    How quick can it replicate? We need it as near real time as possible

Share This Page