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 |
|
nguyenl
Posting Yak Master
128 Posts |
 Posted - 2009-08-04 : 11:37:59
|
| Hi,I am trying to find out if SQL utilizes multiple processors and if adding a processor to my server really makes a difference.Currently we are thinking of getting a server with:1. SQL Server Standard 20052. 12 GB of Ram3. 2 Processors, 2.9 Xeon x5570, 2.9ghz, 8M cache4. OS Raid 1, DB Raid 10, and Logs on our SANWe are wondering if just getting 1 processor is going to make a difference. We have about 50 users hitting the database, which is I/O intensive. There alot of reads and writes.Thanks |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2009-08-04 : 11:48:10
|
| that depends heavily on the way that your sql is written. Generally, if you have nice set based code then the extra cores will be utilised in parallel.Throwing more power at a problem usually isn't a good way to solve that problem in db world however.From what you said you seem to have a very, very small load at the moment (50 users).Also, SQL server licence is priced by socket. Adding another physical proc will probably invalidate your licence.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
 |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2009-08-04 : 15:08:33
|
| Are you bound by CPU at the moment? Is this a 64-bit environment? |
|
|
|
nguyenl
Posting Yak Master
128 Posts |
Posted - 2009-08-05 : 09:34:03
|
| No, currently it is 32bit. We are thinking about moving it to 64 bit with 12gigs of memory. |
|
|
|
|
|
|
|
|
SQL Processor Utilization