sql server data warehouse: Which performance counters? -- sql server data warehouse

Re: Which performance counters?

Kevin
8/5/2003 7:34:18 AM

sql server data warehouse:

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.
----------------------------------------------------
[quoted text, click to view]

Which performance counters?

Stressed
8/5/2003 2:22:51 PM

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.