Extremely high number of pages/sec

microsoft.public.sqlserver.tools

16 Feb 2005 8:40 PM

Igor Marchenko

Hello!

I have noticed very high number of page/sec in perfmon. It is averaging over
1000 pages/sec.I would like to isolate this issue to determine what process
is causing excessive pagination and possibly SQL server SPID. Is there an
easy way to troubleshoot the source of pagination?

Thanks,
Igor

16 Feb 2005 8:59 PM

You can run profiler, and include textdata, writes/reads
columns in the trace. You'll be able to see what SPs/SQL
commands have intensive io operations.
OJ

>-----Original Message-----
>Hello!
>
>I have noticed very high number of page/sec in perfmon.

It is averaging over

>1000 pages/sec.I would like to isolate this issue to

determine what process

>is causing excessive pagination and possibly SQL server

SPID. Is there an
Show quoteHide quote

>easy way to troubleshoot the source of pagination?
>
>Thanks,
>Igor
>
>
>
>.
>

Are all your drivers up to date? click for free checkup

16 Feb 2005 10:21 PM

Igor Marchenko

First of all, I would like to rule out OS as primary suspect. Is there a way
to pinpoint SQL Server SPID as a source?

Show quoteHide quote

"OJ" <anonym***@discussions.microsoft.com> wrote in message
news:09f001c5146a$630ad3b0$a401280a@phx.gbl...
> You can run profiler, and include textdata, writes/reads
> columns in the trace. You'll be able to see what SPs/SQL
> commands have intensive io operations.
> OJ
>>-----Original Message-----
>>Hello!
>>
>>I have noticed very high number of page/sec in perfmon.
> It is averaging over
>>1000 pages/sec.I would like to isolate this issue to
> determine what process
>>is causing excessive pagination and possibly SQL server
> SPID. Is there an
>>easy way to troubleshoot the source of pagination?
>>
>>Thanks,
>>Igor
>>
>>
>>
>>.
>>