|
Home > Archive > MS SQL Server > April 2005 > How To..
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| AllenHubtka 2005-04-29, 8:23 pm |
| 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
| |
| Quentin Ran 2005-04-29, 8:23 pm |
| 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
>
>
| |
| AllenHubtka 2005-04-29, 8:23 pm |
| 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[color=darkred]
>
>
|
|
|
|
|