September 16, 2008 at 4:49 pm
Hello,
I am trying to determine the memory, disk space and CPU requirements for SQL Server Ent. Edition (32 bit) on a single machine for the following scenarios:
1-Using only one instance of SQL server without running any query, and running a single query.
2-Using 2 instances of SQL server without running any query, and running a single query on each instance.
3-How does two instances compare on writing to logs with writing to logs on single instance?
Thanks.
Regards,
Dariush.
September 22, 2008 at 4:46 pm
a few things to note.
-running multiple instances means that you have to manually set the memory for each instance.
-I believe x86 does better with multiple instances.
-Fire up profiler and use perfmon to see how each of those differ.
-Disk Space isn't really going to affect your # of instances as much as your db size.
-The more of all three of those the better multiple instances would run I'm sure.
MCITP, Database Administrator
A hodgepodge of Information Technology and Life
LinkedIn Profile
My Twitter
September 23, 2008 at 10:05 am
Thank you for your reply.
Best,
Dariush.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply