|
|
Posted by Erland Sommarskog on 09/25/82 11:19
Magnus Österberg (magnus.osterberg@abo.fi) writes:
> I'm experiencing the following experience problem with my SQL Server 2000.
>
> Explanation a' la example;
>
> 1.
> I insert data using my SP; EXEC dbo.up_DataInsert
> This is fine, SQL Profiler duration only a few ms.
>
> 2.
> I try to select the data.
> select * from dbo.tblData where DataNumber = 283279
> This is fine, SQL Profiler duration only a few ms.
>
> 3.
> delete from dbo.tblData where DataNumber = 283279
> This is NOT fine, SQL Profiler duration up to 50 seconds!!!
>
> I have got a unique index with ignore duplicate key and the table has
> about 180.000 records.
Possible causes:
1) Blocking.
2) Autogrow.
3) There is a trigger on the table.
4) There is a FK constraint from another, big table, and the FK
column in that table is not indexed.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
Navigation:
[Reply to this message]
|