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 |
|
Robert London
Starting Member
26 Posts |
 Posted - 2010-08-14 : 05:51:00
|
| We are running server 2003 r2 x64 with sql 2008 enterprise with 12gb RAM and 1 dual core processor (singe port machine)We are running a really heavy query which is using 10.7gb RAM. We need to run several of these queries but performance suffers very badly when we execute more than one. CPU usage is fairly static at less then 10% when only one query running but shoots to 90% + when we execute second/ third queries (usage stays at 10.7gb RAM)We are aware that we need to improve performance, the question is do we get more RAM or switch to a quad core processor? |
|
|
Robert London
Starting Member
26 Posts |
Posted - 2010-08-14 : 09:02:14
|
| Additional info:We are not using a UI. Data is stored locally on dbo. There are no other applications running. This is a test server. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Robert London
Starting Member
26 Posts |
Posted - 2010-08-14 : 14:59:56
|
| We have checked the execution plans already and are reasonably happy. There are no index or table scans, bookmark lookups etc to show any warning signs.. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-08-14 : 15:12:17
|
| how many reads does the query perform? how much data in MB is returned? |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2010-08-15 : 08:01:10
|
| 1)Even though you aren't seeing any index\table scans , bokkmark lookups etc , it is possible that your query is inefficient - for example , you are returning to much data in a JOIN2)Have you got any data from measures such as PageIOLatch ? 3)Have you got statistics and fragmentation levels up to date?Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
More RAM or Quad Core processor required?