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 |
|
senthilkmd
Starting Member
4 Posts |
 Posted - 2003-07-22 : 08:34:26
|
| Greetings, I came with one problem. Here we are using MS SQL Server 7.0 with IIS 4.0.Our Database size is arround 600MB.Upto yesterday it was working fine.But suddenly we have found the pages[ASP] got structed.we went to the task manager of our windows 2000 server which our SQL server is running. Inthat task manager under processes tag we saw that SQL servers Mem usage was 46,560k, and the CPU usage was 100%. if we restart the SQL server thru SQL server agent the CPU usage is comming below 10%. We again restart the SQL Server thru agent in the begining no problem all the ASP pages are running fine but after 5 min the same 100% CPU usage coming and the pages got probelm. We are running this in web.So we have to solve it qick.So please suggest us any solution.Thanks in advance...Regards,Senthil Kumar.T |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-07-22 : 12:32:57
|
| There isn't anyway for us to know what is occurring on your server unless we actually looked at the server. You will need to investigate what the culprit is by running Performance Monitor and SQL Profiler.Tara |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-07-22 : 12:34:23
|
| For information about Performance Monitor and SQL Profiler:[url]http://www.sql-server-performance.com/[/url]Tara |
|
|
|
|
|
|
SQL Server and CPU usage !