In a datamart or DW, the counters that indicate a bottle neck do not
change - what changes is the workload, which may or may not expose the same
bottle necks as an OLTP system.

Is there a specific problem you are trying to solve so we can be of more
help?

----------------------------------------------------
The views expressed here are my own
and not of my employer.
----------------------------------------------------
"Stressed" <k@c.co.uk> wrote in message
news:uV18uR1WDHA.384@TK2MSFTNGP12.phx.gbl...
> SQL2K SP3a Win2k SP3
>
> I'm wondering if anybody can help me with performance counters?
>
> I've read lots about which counters to use and what values to look for, in
> an OLTP system.
>
> What I'm interested in is which counters and what values are relevant to a
> data warehousing environment. Disk queue for example, OLTP states this
> should average < 2. What should it be during a bulk upload/update etc...?
>
> Any pointers gratefully received.
>
>