How to know What Query Statement that consume the Server resources most ?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

krislioe@gmail.com - 04 Mar 2008 10:49 GMT

Hi all,

We have problem with SQL Server 2000 : there something in the
application that cause the server out of memory. I suspect this is
because an inefficient and heavy query.

In Oracle we have TOP SQL from Enterprise Manager to see what query
that consume the server resources most, How can I get that information
in SQL Server 2000 ?

Thank you for your help,
Krist

Reply to this Message

Uri Dimant - 04 Mar 2008 11:56 GMT

Hi
It is possible that long running queries and /or queries that performs lots
READs are consumed resources. SQL Server Profiler tool is your friend

> Hi all,
>
[quoted text clipped - 8 lines]
> Thank you for your help,
> Krist

Reply to this Message

TheSQLGuru - 04 Mar 2008 14:39 GMT

To really get a look at the internals of SQL executions and resource usage
you need to be on SQL 2005+. Not much info available in 2000.

Signature

Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net

> Hi all,
>
[quoted text clipped - 8 lines]
> Thank you for your help,
> Krist

Reply to this Message