(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...