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 |
|
Buraky
Starting Member
1 Post |
 Posted - 2010-09-15 : 09:57:53
|
| We currently use ASP playground forum. When a forum manager adds a new forum, when the online users are crowded, SQL server cpu graph peaks at almost 80%. It never falls back. I thought it may be associated with the count of executed queries (per time) that concern "pgd_Forums" (the table that stores all forum data, including names and ID's of all forums)We experience that problem since 2 years. There have been 4 programmers that have not any idea why does it happen. Today i have found this forum. Sooo, what do you advise? :) |
|
|
sks198117
Starting Member
46 Posts |
Posted - 2010-09-15 : 10:45:22
|
| Follow these steps if might this will help1. try to find out the SQLs running on server during this time period.2. Try to check the Indexs health on table on which operation is performing.3. Please post the SQL version and server configuration detail if you can.thanks |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
SQL server peaks at 80% when i add new forum