How to monitor insert?
From: Microsoft Newsgroups (scot.no.spam.curry_at_btopenworld.com)
Date: 05/21/04
- Next message: Susak: "CreateParameter changed (incompatibly) with MDAC 9 ?"
- Previous message: Frank Petrucci: "Re: Timeout with Where statement"
- Next in thread: Frank Hickman: "Re: How to monitor insert?"
- Reply: Frank Hickman: "Re: How to monitor insert?"
- Reply: Scot NS Curry: "How to monitor insert?"
- Messages sorted by: [ date ] [ thread ]
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.
- Next message: Susak: "CreateParameter changed (incompatibly) with MDAC 9 ?"
- Previous message: Frank Petrucci: "Re: Timeout with Where statement"
- Next in thread: Frank Hickman: "Re: How to monitor insert?"
- Reply: Frank Hickman: "Re: How to monitor insert?"
- Reply: Scot NS Curry: "How to monitor insert?"
- Messages sorted by: [ date ] [ thread ]