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 |
|
oldnapkin
Starting Member
2 Posts |
 Posted - 2006-06-22 : 14:46:21
|
| We just installed SQL 2005 64 bit edition on W2k3 x64 and it is very slow. When you run an intensive query it basically shuts users out until it's done. The same DB runs great on lesser hardware with SQL 2000.I notice in Task Manager that when it's doing a major query, the CPU never breaks the 50% usage barrier. My hunch (and please correct me if I'm being dumb here) is that if I could tell it that it's ok to use more CPU time than things would speed up. Any idea how to do that?Thanks in advance for any advice! |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-06-22 : 19:34:45
|
| how many CPUs do you have in the system? I would guess that you have 2 (or a single dual-core). The 50% utilization means that you are using 100% processing of one of your 2 CPUs - which is 50% of your total CPU.If you moved this datbase from SQL 2000 make sure that you set the compatibility level of the database to version 90. It is also very helpful to rebuild the statistics on all tables.-ec |
 |
|
|
oldnapkin
Starting Member
2 Posts |
Posted - 2006-06-23 : 08:48:28
|
| Thanks for the reply.It's a single processor XEON, which I believe is dual core (sorry - I'm not a hardware guru). Windows and SQL both see 2 processors. So if what you're saying is correct, I guess I'm a little confused. Since I'm on the 64 bit Windows and the 64 bit SQL, shouldn't it be able to utilize both processors at the same time? |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2006-06-23 : 22:17:05
|
| Is it a 64-bit processor?? You can utilize both processors regardless of it being 32-bit or 64-bit. Also, have you tried updating the statistics to see if that helps?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
SQL 2005 x64 CPU Throttled at 50%