How to monitor insert?

From: Scot NS Curry (scot.no.spam.curry_at_btopenworld.com)
Date: 05/24/04 

Date: Mon, 24 May 2004 14:35:18 +0100

Is there a SQL Profiler, or Performance Monitor counter that we can view to
check this information out. We are struggling because the error "goes away"
after a while and we are having trouble duplicating it on our test machine.

Thanks for your help.
Scot

"Microsoft Newsgroups" <scot.no.spam.curry@btopenworld.com> wrote in message
news:OcahcH0PEHA.252@TK2MSFTNGP10.phx.gbl...
> When I am performing an Insert into a table using Query Analyzer, it is
> taking 2 minutes 30 seconds. The table has 1,170,548 rows.
>
> There is a clustered Index that scripts out to
>
> CREATE CLUSTERED INDEX [IX_1_39_varcharIndex] ON BusinessDate,
ContentType,
> CTMapID, BZMapID, IndexMapID, Value, COMapID, COVID, DocID, Page ON
> [Primary}
>
> We have a CONSTRAINT on:
> BusinessDate, CoMapID, COVID, DocID, Page, PageOffset, Value
>
> I cannot seem to figure out how to determine what is happening during the
> insert. I am guessing that is has something to do with FILLFACTOR, but I
am
> not sure how to find information in Performance Monitor or SQL Profiler.
> Could someone please point me in the right direction?
>
> Thanks in advance for your help.
>
>