| Author |
Topic |
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
 Posted - 2008-07-16 : 01:53:05
|
| sql is now using 75% of the cpu and i did a profiler and nothing big is running - just a few small queries.how can i see what's causing it?the same thing happened yesterday and i restarted sql - but I don't want to constantly be restarting. sp_who2 doesn't show anything either |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2008-07-16 : 03:38:25
|
| Are you sure it's SQL using the CPU?What version of SQL? If you look in sysprocesses/sys.dm_exec_requests do you see blocked queries or queries with wait types and high wait times? If so, what wait types?--Gail ShawSQL Server MVP |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-16 : 13:30:30
|
| Did you check whether memory is paged out in event log? Is it 64-bit standard edition? Why are you restarting server? Check with Performance monitor and Profiler what is the bottleneck?http://www.mssqltips.com/tip.asp?tip=1212Please:Donot run this on Production server: |
|
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2008-07-16 : 13:35:41
|
| i ran profiiler - it was a bunch of small update queries that i guess were saved in memory - any way to not let this happen? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-16 : 13:37:13
|
| You didn't answer my question. |
|
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2008-07-16 : 13:48:58
|
| Did you check whether memory is paged out in event log? Is it 64-bit standard edition? how do i know this? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-16 : 13:50:14
|
| run:select @@versionalso check event log in control panel in box. |
|
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2008-07-16 : 14:05:20
|
| microsoft sql server 2005 9.00.3054 (intel x86 )i don't see anything in the event log |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-16 : 23:05:53
|
| Use sp_who2 to find out which process uses most cpu time. |
|
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2008-07-17 : 01:30:06
|
| nothing showed up in sp_who2 - that's the strange thingi think it was a bunch of little update statements that had run through the night and were still in memoryis that possible? |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2008-07-17 : 14:26:42
|
| Only if they were still running.--Gail ShawSQL Server MVP |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-17 : 23:44:15
|
| >> nothing showed up in sp_who2 Impossible, at least have system prosesses. |
|
|
|
|
sql is using 75% of cpu without running much