Running SQL Server 2000 and 2005 simultaneously
When simultaneously running SQL Server 2000 and 2005, what performance effects can I expect this having on the box? Should the memory be increased? And what can I do now to fine-tune it before the install of 2005?
Software/Hardware used:
Software/Hardware used:
ASKED:
March 11, 2010 6:51 PM
UPDATED:
March 12, 2010 5:43 AM
Answer Wiki:
Running two instances of SQL server on the same machine will cause them to contend for memory and slow down.
I would definitely increase memory on the machine.
Are you using standard or enterprise versions for windows and sql
-----------
You will want to add as much memory to the server as you can afford to (with SQL this is just a best practice anyway).
When running multiple instances (no matter which version) you'll want to limit the maximum amount of memory that each instance can use so that they aren't fighting for memory.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
