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 |
|
seanqb
Starting Member
3 Posts |
 Posted - 2008-12-11 : 11:20:36
|
| Hi all,We have two servers one is Dell PE 2800 and it has 12G Mem and one Dell PE R900 with 128G of Mem and they both 2008 datacenter 64 O/S and both have SQL server 2005 64 Bits.Here is the promblem. When I ran one of the SQL statements on both Machines and for some strange reasons that the older PE 2800 with 12G of Mem seems a lot fast faster then the the new one R900 with 128G of Mem. And I notice that when I look at the Perf monitor I see that the PE 2800 CPU is about 60% of usage and Disk is greater than 3M, and the PE R900 the CPU is Maxed out and Disk is never goes above 2M.Is it possible there are some wrong setting with memory allocations or something else?if anyone ran into the same issues please help!thanks in advance |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-11 : 11:31:19
|
| Depends on how busy servers are,connections or multiple instances runnning on same server? |
 |
|
|
seanqb
Starting Member
3 Posts |
Posted - 2008-12-11 : 14:06:36
|
| Sodeep, I'm very appreciate for your response and helps. what about the memory allocation and AWE? any suggestions?thanks |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-11 : 19:43:01
|
| AWE is nothing in 64-bit. What does Total Server Memory and Target Server Memory say for Performance counter? Are indexes similar and defragmented on both servers? |
|
|
|
seanqb
Starting Member
3 Posts |
Posted - 2008-12-15 : 09:45:03
|
| Sodeep, but it still confused me, the biggest confusion that I'm having is two server have the same O/S 2008 64 bits and the a huge gap of memory capacity one 12G and 128G for some reasons the one with the less memory is processing the query is 6 time faster than the one with 128G. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-15 : 09:58:06
|
| You didn't answer my question for reply posted : 12/11/2008 : 19:43:01? |
|
|
|
|
|
|
SQL Server 2005 Performance issues