Extremely high number of pages/sec

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
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?
"OJ" <anonymous@.discussions.microsoft.com> wrote in message
news:09f001c5146a$630ad3b0$a401280a@.phx.gbl...[vbcol=seagreen]
> 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
> It is averaging over
> determine what process
> SPID. Is there an

Extremely High number of page/sec

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
Igor Marchenko wrote:
> 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
I should have added that high Read counts should be looked at as well.
David Gugick
Imceda Software
www.imceda.com
|||Igor Marchenko wrote:
> 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
Look for transactions with high CPU and/or high duration. You can use
Profiler for this or a number of SQL performance profiling tools (we
offer Coefficient).
David Gugick
Imceda Software
www.imceda.com

Extremely High number of page/sec

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,
IgorIgor Marchenko wrote:
> 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
I should have added that high Read counts should be looked at as well.
--
David Gugick
Imceda Software
www.imceda.com|||Igor Marchenko wrote:
> 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
Look for transactions with high CPU and/or high duration. You can use
Profiler for this or a number of SQL performance profiling tools (we
offer Coefficient).
--
David Gugick
Imceda Software
www.imceda.com

Extremely High number of page/sec

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,
IgorIgor Marchenko wrote:
> 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
I should have added that high Read counts should be looked at as well.
David Gugick
Imceda Software
www.imceda.com|||Igor Marchenko wrote:
> 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
Look for transactions with high CPU and/or high duration. You can use
Profiler for this or a number of SQL performance profiling tools (we
offer Coefficient).
David Gugick
Imceda Software
www.imceda.com