How To..

I have SQL Server 2K installation with various databases created on them.
All our staff are writing the queries and pumping the data at all the time.
Sometimes the system is becoming too slow. How to find out which
query/process is using the resource?

Will the data in sysprocesses will help? Atleast I need to find whose job it
is taking much of the resources.

Thank you very much.

Allen

Allen,

you can first start with Enterprise Manager.  Go to Management, Current
Activity, right click and choose Refresh, then Process Info.  You will see
the most important info such as disk I/O, cpu, who is blocking who, which
process is waiting for what resources etc.  Good luck.

Quentin


"AllenHubtka" < AHubatha_London@hotm
ail.com> wrote in message
 news:%23dItH%23OTFHA
.1148@tk2msftngp13.phx.gbl...
>I have SQL Server 2K installation with various databases created on them.
> All our staff are writing the queries and pumping the data at all the
> time.
> Sometimes the system is becoming too slow. How to find out which
> query/process is using the resource?
>
> Will the data in sysprocesses will help? Atleast I need to find whose job
> it
> is taking much of the resources.
>
> Thank you very much.
>
> Allen
>
>

Thank you.
Allen

"Quentin Ran" < remove_this_qran2@ya
hoo.com> wrote in message
news:uutcMPQTFHA.632@TK2MSFTNGP10.phx.gbl...
> Allen,
>
> you can first start with Enterprise Manager.  Go to Management, Current
> Activity, right click and choose Refresh, then Process Info.  You will see
> the most important info such as disk I/O, cpu, who is blocking who, which
> process is waiting for what resources etc.  Good luck.
>
> Quentin
>
>
> "AllenHubtka" < AHubatha_London@hotm
ail.com> wrote in message
>  news:%23dItH%23OTFHA
.1148@tk2msftngp13.phx.gbl... 
job 
>
>