Prev: Database Mirroring for large number of databases
Next: test - sql
From: Pat.Rick on 1 Jun 2010 14:59
Hi Friends,
SQL 2008 -
I have high CPU and IO (4457218,1120635) count.
it cause my disk queues to spike hight and disk %idle time to drop to
almost %0.

where should I look for it ? ( beside slow raid configuration on
storage side ! which we are aware of it already)

thanks in advance,
Patirck
From: Uri Dimant on 2 Jun 2010 04:02
---This first thing to check if CPU is at 100% is to look for parallel
queries:

-- Tasks running in parallel (filtering out MARS requests below):

select * from sys.dm_os_tasks as t

where t.session_id in (

select t1.session_id

from sys.dm_os_tasks as t1

group by t1.session_id

having count(*) > 1

and min(t1.request_id) = max(t1.request_id));

-- Requests running in parallel:

select *

from sys.dm_exec_requests as r

join (

select t1.session_id, min(t1.request_id)

from sys.dm_os_tasks as t1

group by t1.session_id

having count(*) > 1

and min(t1.request_id) = max(t1.request_id)

) as t(session_id, request_id)

on r.session_id = t.session_id

and r.request_id = t.request_id;









"Pat.Rick" <patrickalexander.email(a)gmail.com> wrote in message
news:58d17c95-5570-4f19-a957-eb8cb3b34e0e(a)40g2000pry.googlegroups.com...
> Hi Friends,
> SQL 2008 -
> I have high CPU and IO (4457218,1120635) count.
> it cause my disk queues to spike hight and disk %idle time to drop to
> almost %0.
>
> where should I look for it ? ( beside slow raid configuration on
> storage side ! which we are aware of it already)
>
> thanks in advance,
> Patirck


 | 
Pages: 1
Prev: Database Mirroring for large number of databases
Next: test - sql