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 |
|
dotnetmick
Starting Member
5 Posts |
 Posted - 2004-06-16 : 15:29:43
|
| Our SQL server has all of the sudden started pegging at 100%. No code has changed that I am aware of. We are an application service provider and everything has been humming for several months with no problems. Can I use SQL Profiler to figure out what is causing the CPU to spike up to 100% (it does it every few minutes).Thanks for any QUICK replies! :(Mick |
|
|
stephe40
Posting Yak Master
218 Posts |
Posted - 2004-06-16 : 15:55:15
|
| Is it the SQL Server process or some other process that is maxing it out?- Eric |
 |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-06-16 : 16:20:54
|
| Log your profiler results to a table, and then sort that table by cpu.That should tell you what user and what query is pegging your CPU.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
dotnetmick
Starting Member
5 Posts |
Posted - 2004-06-16 : 16:21:27
|
| SQL Server process...I think I have it half way figured out now...one of my log files was 10Gig. We do hourly back ups of tran logs, so they hardly ever get more than 50 to 100Meg. I am now getting this error which I'm thinking I caused when moving the cluster from one server to another:I/O error (bad page ID) detected during read at offset 0x000000022ba000 in file 'removed...Session_DATA.mdf'.This was the best database that it could have happened on because it only stores current session info. I'm guessing DBCC CHECKDB right?Thanks,Mick |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-16 : 16:24:18
|
| Yep DBCC CHECKDB. You might consider dropping and recreating your indexes. Are you on the latest SQL service pack?Tara |
|
|
|
dotnetmick
Starting Member
5 Posts |
Posted - 2004-06-16 : 16:34:45
|
| I ran DBCC CHECKDB and didn't find any errors. A job that had previously failed now runs, so I wonder if it was something that happened when I was moving the instance from one server to another. I guess all is well at this point. Thank you all for your quick and helpful responses.Mick |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-06-16 : 16:35:23
|
| When you moved your cluster, did you use Cluster Administrator?Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
dotnetmick
Starting Member
5 Posts |
Posted - 2004-06-16 : 16:42:59
|
| Yes, I used Cluster Administrator.Mick |
|
|
|
|
|
|
Performance Problems (uh oh)