March 21, 2008 at 4:38 pm
Hi all,
I have a question, not sure if this is even reasonable to consider. Currently, the data environment I manage consists of 2 servers running SQL 2005. I support about 35 users between both servers, who all access SQL directly through Management Studio. Our environment is not so much transactional and much more for business intelligence, so we have a great deal of static data, though many of the folks are often running reporting processes and different stored procedures they've written that tax the servers greatly (Their procedures may include temporary tables that get generated, then some updates, inserts into other tables, etc).
One server in particular has quite a bit of "global" data in various databases that users on both servers access pretty regularly. So, when that one server is often being taxed heavily by some reporting processes that are running, data access to those "global" databases can be difficult and often very slow.
So, my question is this: Does it make much sense at all to get a 3rd server that might serve as stricly a data repository. So, all the global databases would be hosted on this server, with absolutely no additional reporting processes allowed to run (i.e. no stored procedures, no functions, no tables getting created from processes, no updates occurring unless the static data needs to be updated for some planned change.). Users would only be able to select data out of these tables remotely from one of the other SQL servers and the other servers would handle any reporting processes. What do you all think about this kind of setup? Would this help with performance much? Thanks in advance.
Joe
March 22, 2008 at 8:52 pm
This could help, especially if you granted read only access to the global data. It might help with the load.
If you are joining this data across databases, however, then you might be slowing things down with cross database connections. You might be better off replicating some of this data to both (or 3 servers) and limiting come people to each server, thereby lowering the loads.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply