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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-10-29 : 09:19:05
|
| sivadycart writes "I'm running SQL Server 2000, SP 2 on Windows 2000, on a system with two processors, and I've noticed performance problems which come with some very consistent clues:1) Queries run a lot slower.2) When viewing the activity on the two processors with Windows Task Manager, I notice that the total CPU Usage is steady at 50%, and oddly enough, the graph for the CPU Usage History for the two processors shows one activity level which is a mirror image of the other, i.e. when one processor is at 80%, the other one is at 20%, so that you could paste one graph under the other and they would look like reflected images of one another.3) On the Processes tab of Windows Task Manager, if I sort by CPU Time, I see that System Idle Processes and sqlservr.exe are each taking up almost EXACTLY 50% apiece of the overall CPU activity.4) This seems to happen in stored procedures where the batch size is large, with individual SQL statements processed as a group due to common usage of shared variables (i.e. there are no GO statements in-between the queries, so they must be compiled together under a common execution plan).This has happened on at least three servers. Our database recovery model is Simple because we implement a data warehouse system. Does anybody have any idea what could be the problem?" |
|
|
|
|
|
|
|
Performance Problems in SQL Server 2000 With Clues