metrics?

Can anyone tell me how I can measure the metrics of
certain activities?
I need to see the difference in I/O between a query and
an index build.
TIA,
Adria
Adria,
possible ways:
1. you can use set statistics io on in query analyzer
2. you can use user profiler
3. you can use perfmon (or system monitor in win2k)
Quentin
"Adria" <a-carbo@.tamu.edu> wrote in message
news:b6ea01c4377b$32bf27f0$a001280a@.phx.gbl...
> Can anyone tell me how I can measure the metrics of
> certain activities?
> I need to see the difference in I/O between a query and
> an index build.
> TIA,
> Adria

metrics?

Can anyone tell me how I can measure the metrics of
certain activities?
I need to see the difference in I/O between a query and
an index build.
TIA,
AdriaAdria,
possible ways:
1. you can use set statistics io on in query analyzer
2. you can use user profiler
3. you can use perfmon (or system monitor in win2k)
Quentin
"Adria" <a-carbo@.tamu.edu> wrote in message
news:b6ea01c4377b$32bf27f0$a001280a@.phx.gbl...
> Can anyone tell me how I can measure the metrics of
> certain activities?
> I need to see the difference in I/O between a query and
> an index build.
> TIA,
> Adria