Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jrockfl
Posting Yak Master
223 Posts |
 Posted - 2005-03-09 : 16:30:10
|
| We have 2 main applications, Macola and Goldmine, currently neither are running on SQL Server, butwe are in the process of converting them.Should we have 2 seperate servers each running SQL Server or 1 server running SQL Server with 2 seperate databases?We have about 30 users that would be connecting to both at any given time. Would there be a considerable amount ofperformance gain if there were 2 seperate servers? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-03-09 : 16:31:33
|
| Well, it depends. If your one server has sufficient hardware to support both, then certainly you can put both in one instance, or separate the applications amongst two instances on one server. If the one server does not have sufficient hardware, then you'd need two servers. Given the information that you have provided, we can not provide a direct answer.Tara |
 |
|
|
jrockfl
Posting Yak Master
223 Posts |
Posted - 2005-03-09 : 20:30:40
|
| Tara,Thank you for your reply. The server has dual 2.8 xeon cpu, 2 gigs of ram and scsi hard drive raid. There would be 30 users connected simotainiously. SQL Server would be the only application running on this server. |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-03-09 : 21:25:44
|
That's not bad, but it's only part of the information needed. You also have to know what the applications will be doing, how much data will be stored, etc.Otherwise, it's like saying, "I have a 24,000 pound truck with a 300 hp engine. Is that big enough?" Who can say without knowing what you are hauling?quote:
Originally posted by jrockfl
Tara,Thank you for your reply. The server has dual 2.8 xeon cpu, 2 gigs of ram and scsi hard drive raid. There would be 30 users connected simotainiously. SQL Server would be the only application running on this server.
CODO ERGO SUM |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-03-09 : 21:31:19
|
| I've got a 300 hp engine in my car, which weights 750kg. Your truck isn't big enough!Kristen |
|
|
|
|
|
|
|
|
Multiple SQL Servers?