SEO

#1 (**permalink**) 02-27-2008, 05:07 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.

#2 (**permalink**) 02-27-2008, 05:07 PM

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

#3 (**permalink**) 02-27-2008, 05:07 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Which performance counters?