That is correct. However, unless you have more data to insert than query,
generally query performance is just as, or usually more important than load
performance.


----------------------------------------------------
The views expressed here are my own
and not of my employer.
----------------------------------------------------
"Stressed" <k@c.co.uk> wrote in message
news:eEXLHfMXDHA.2640@TK2MSFTNGP09.phx.gbl...
> Thanks for the reply.
>
> I'm trying to understand performance counters in general, but
> mainly bulk load/update/insert performance. Say for instance that
> the avg disk queue length should be < 2, your reply seems to suggest
> that, if our main activity is bulk loading, we should invest in sufficient
> hardware/partitioning/optimization to ensure that this value remains
> < 2, is this correct?
>
> Thanks one again for taking the time to reply.
>
> "Kevin" <ReplyTo@Newsgroups.only> wrote in message
> news:#iYNp61WDHA.1004@TK2MSFTNGP12.phx.gbl...
> > 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.
> > >
> > >
> >
> >
>
>