Very Computer

Hi all,

(SQL2000 SP1/WIN NT 4 SP6a)

I need to identify the queries which take up more memory and I/O.In profiler
how do I set a filter for that ?

Also , how do I find  the buffer cache hit ratio ?

am a novice with profiler but did my homework with BOL..

Thanks for any help/advice...
Michelle Vileone.

I'm not sure if there is anything on finding the amount of memory queries
take up.
You can find the read/write values in profiler. It's one of the "data
columns" that you can choose.

As to the buffer cache hit ratio, there is an event in Profiler under
"Stored Procedures" called "SP:CacheHit".
You can also use the Windows tool "Performance". There are a lot of counters
for SQL server. Take a look through them.
The "Buffer cache hit ratio" counter is under the Performance object
"SQLServer:Buffer Manager".

I hope this helps
Joe

Quote:> Hi all,

> (SQL2000 SP1/WIN NT 4 SP6a)

> I need to identify the queries which take up more memory and I/O.In
profiler
> how do I set a filter for that ?

> Also , how do I find  the buffer cache hit ratio ?

> am a novice with profiler but did my homework with BOL..

> Thanks for any help/advice...
> Michelle Vileone.

Another source of resource utilization information ( CPU, physical_io,
memusage etc ) for SQL processes not specific queries can be "sysprocesses"
table.

Hope this helps.

Raju Girdher MCSE
SQL Support Engineer, Microsoft

Please reply only to newsgroups. When posting, please state the version of

error message text received, if any.

Disclaimer:
This posting is provided AS IS with no warranties, and confers no rights.
You assume all risk for your use. ? 2001 Microsoft Corporation. All rights
reserved.