SQL Server Performance Forum – Threads Archive
3 SQL Servers, 1 DB file?
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?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.
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
Check: http://www.sql-server-performance.com/transactional_replication.asp Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
If the other databases are used only for query purposes then choose Log shipping than replication
http://www.sql-server-performance.com/sql_server_log_shipping.asp for detailed information. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
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
How quick can it replicate? We need it as near real time as possible
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
]]>