473,327 Members | 1,896 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Multiple instances ready for Production prime-time?

Hello,

Is the multiple instances capability of SQL2K mature enough for a
Production system?

We're looking at upgrading our hardware but the proposed solution
calls for consolidating two currently separate SQL Server's onto one
machine with two CPU's.

Of the current two servers, one is for OLTP (~800Mb) and the other for
reporting (some ad-hoc, some canned queries, 2-3Gb). We purge the OLTP
db nightly and archive the purged data in the reporting server where
it stays for a couple of months before getting purged from there.

Maybe I'm being overly cautious here but the OLTP system is especially
time-sensitive. If anything causes it to slow down significantly we
lose $$$.
Thanks,

Martin V.
Jul 20 '05 #1
1 2184
mv****@olgc.on.ca (Martin V.) wrote in message news:<65*************************@posting.google.c om>...
Hello,

Is the multiple instances capability of SQL2K mature enough for a
Production system?

We're looking at upgrading our hardware but the proposed solution
calls for consolidating two currently separate SQL Server's onto one
machine with two CPU's.

Of the current two servers, one is for OLTP (~800Mb) and the other for
reporting (some ad-hoc, some canned queries, 2-3Gb). We purge the OLTP
db nightly and archive the purged data in the reporting server where
it stays for a couple of months before getting purged from there.

Maybe I'm being overly cautious here but the OLTP system is especially
time-sensitive. If anything causes it to slow down significantly we
lose $$$.
Thanks,

Martin V.


I must admit that I've never used multiple instances for production,
but I would also be wary of this proposed approach. The two instances
will always be competing for system resources at some level - while
you can assign each to a CPU, and also limit the memory avilable to
each instance, if there is a usage 'spike' in the OLTP system, it may
be that there are no spare system resources to respond. In addition,
if the two instances use the same I/O subsystem, then long-running
queries on the OLAP side may slow down OLTP access to the disks.

Personally, I see the value of instances in situations where you need
to test something like a new replication topology but you don't have a
whole bunch of physical servers. In this case, multiple instances are
a good way to verify that the functionality works, although it's not
easy to test performance in a meaningful way without an accurate
physical system.

In any event, you should really test the proposed configuration to get
a proper answer, and especially under stress or limit conditions.

Simon
Jul 20 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Jerry | last post by:
Hi All, How can I prevent a script from running when a previous instance of the script had already been triggered and the script is running in the background already? So, even when a script is...
2
by: bmatt | last post by:
I am trying to support multiple interpreter instances within a single main application thread. The reason I would like separate interpreters is because objects in my system can be extended with...
11
by: Ohaya | last post by:
Hi, I'm trying to understand a situation where ASP seems to be "blocking" of "queuing" requests. This is on a Win2K Advanced Server, with IIS5. I've seen some posts (e.g.,...
7
by: aaj | last post by:
Hi all We had a small problem when an ASP web page had a missing 'where' statement and updated all the records in the table. Luckily we could retrieve all the data from the backups. How do...
4
by: Mark Duregon | last post by:
Hi, I am trying to create a Windows Service in C# that will install on a single box to support multiple environments. I have created the service and it works perfect. Now however, the client has...
11
by: Mike | last post by:
Looking to find any information on how to properly configure multiple instances of DB2. This is on Win2k db2 ver 7.2. I am basically looking for information on how the multiple instance settings...
1
by: Arne | last post by:
All my code behind pages gets compiled into one DLL. I would like to redirect my code behind into multiple DLLs so that I get more flexibility when installing new features to a web site. I am adding...
7
by: Matt | last post by:
I have approximately 5 instances on my test server that are identical to my prod server. On the prod server, when I look at the services file, there is a single entry per instance and everything...
29
Niheel
by: Niheel | last post by:
The Apple invasion into corporate has started and I can't say if I am excited or scared. As an IT manager, I have nightmares over all the support and technical issues of integrating Apple hardware...
1
by: richard.crosh | last post by:
What is the IBM recommendation for the number of DB2-LUW databases per instance on AIX? With Oracle, it is one-to-one. In DB2 multiple databases can co-exist in an instance but is this...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.