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 |
|
harshal_in
Aged Yak Warrior
633 Posts |
 Posted - 2003-05-05 : 06:00:55
|
| hi,Recently I have seen that my database server cpu goes to 99% whenever any long running job is executed or any heavy procedure is executed previously I never used to go to 100% though the procedures used to take time but the server never went 100%,due to this the sites are getting slow.please help.harshal.Expect the UnExpected |
|
|
franco
Constraint Violating Yak Guru
255 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-05-05 : 16:47:13
|
| Do you have a multi proc server?If so, what is your MAXDOP setting? If a SQL chooses a parallel plan, it will max out the procesors until the query is complete. That is why parallel plans are not supposed to be selected by the optimizer if there are more users on the system that there are procs.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
 |
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2003-05-06 : 02:21:35
|
quote:
Do you have a multi proc server?If so, what is your MAXDOP setting? If a SQL chooses a parallel plan, it will max out the procesors until the query is complete. That is why parallel plans are not supposed to be selected by the optimizer if there are more users on the system that there are procs.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime.
no I have a single processor server with 528 MB of ramExpect the UnExpected |
|
|
|
|
|
|
cpu 100%