July 23, 2012 at 10:24 pm
Hi All,
I have a problem with SQL SERVER, i am using SQL SERVER 2008 & WIN SERVER 2008. Always i am getting 100% utilization alerts.
When i check task manager it showing 85% SQL SERVER is using than i check 'SP_WHO2' than some users are in SLEEPING status & there CPU utilization is 10%, when i killed that particular SPID then my server is coming normal mode.
Tel me know what is the exact issue & how do i fix it?
Thanks in Advance....
July 24, 2012 at 12:43 am
I would recommend reading chapter 3 of the Accidental DBA Guide (link in my signature below).
July 24, 2012 at 3:11 am
Have you checked the excution plan for that particular SPID you just killed? I have the same problem before and it caused by index missing. After i add the index back, the sql server became normal. So you may could check yours.
July 24, 2012 at 10:41 pm
Hi,
I checked it is development server, i can't use profiler while they using server. If i use on same time Server will hang.
Satish
July 25, 2012 at 12:56 am
You dont need profiler to find the execution plan.
You just need to use 2 DMV's to find the plan from the system tables or 3 if you want the SQL Query as well
select query_plan, * from sys.dm_exec_requests
cross apply sys.dm_exec_query_plan (plan_handle)
cross apply sys.dm_exec_sql_text (sql_handle)
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply