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 |
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
 Posted - 2009-11-24 : 07:47:44
|
| sql server often uses most of the cpu i'm trying to see why so I did a trace during a busy time saving it to a table when i go to select * from trace where cpu>1000 order by cpu descon this table all the records that show have no textdata(textdata=null)How can i find out what is tying the server up here? |
|
|
rajdaksha
Aged Yak Warrior
595 Posts |
Posted - 2009-11-24 : 08:22:35
|
quote:
Originally posted by esthera
sql server often uses most of the cpu i'm trying to see why so I did a trace during a busy time saving it to a table when i go to select * from trace where cpu>1000 order by cpu descon this table all the records that show have no textdata(textdata=null)How can i find out what is tying the server up here?
i think the table is select * from sys.traces-------------------------R... |
 |
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2009-11-24 : 08:35:08
|
| no i saved the tracet to a table - it's showing the right data but anything using the cpu of more then 1000 shows no textdata - so how can I tell why? |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-24 : 10:50:45
|
| what is eventID of those that have blank textdata? tried converting textdata field to varchar?another approach is to execute sp_who2 during busy time. look at runnable spids with high cpu time. execute dbcc inputbuffer for those spidsmy guess is you have missing or poorly designed indexes |
|
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2009-11-25 : 06:16:11
|
| russel - I will try that next time it goes slow.normally it's many small statements and not one thing tying the cpu at at time - i think |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2009-11-26 : 14:04:13
|
| I couldn't open the article as i'm not a subscriber but now it's busy and I did sp_who2 and I see hte big transactions - except for killing them - how can i debug what the issue is with them and what does it mean when it says sleeping? |
|
|
|
|
|
|
busy server - trying to see why