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 |
|
kityo
Starting Member
1 Post |
 Posted - 2011-01-27 : 06:47:07
|
| Hi All,I'm really sorry if that has been before but search button is not my friend today!I have SQL server running on Windows 2008 Enterprise SP2 X64, 2x Xenon E5420 2.5 and 17 GB of memory. 3 DBs running, 60 MB, 3.5 GB and 300 MB.You would suspect that this should be enough but users are experiencing a long responses from SQL server.I have setup data collection on perfmon and SQL server using data warehouse management tool. Problem is that I am not sure what is wrong..According to report from SQL server cpu time exceeds 95.72% (http://img253.imageshack.us/f/sql2008.jpg/) but perfmon says that cpu usage does not exceeds 20%??? Would appreciate any ideas!Many thanksk |
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-01-30 : 09:55:33
|
| Is hyperthreading enabled on the CPU ?PBUH |
 |
|
|
|
|
|
CPU Bottleneck?