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 |
|
trouble2
Constraint Violating Yak Guru
267 Posts |
 Posted - 2006-11-23 : 05:58:46
|
| We have a problem with our website. It uses SQL express.After restarting the website etc., SQL Express starts out ok, but after a while it seems to react slower and slower.SQL server takes a lot of the cpu resources it jumps up and down to 100%.It might be some stored procedure behaving bad....How can I find out which one is causing the problem.I've checked the activity monitor, and see some processes with high cpu loads, but how can I find out what this process is.... |
|
|
|
|
|
Activity monitor