How to monitor insert?

From: Microsoft Newsgroups (scot.no.spam.curry_at_btopenworld.com)
Date: 05/21/04


Date: Fri, 21 May 2004 15:42:40 +0100

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.