I am running SQL Server on a 4-processor (4 x 750 Pentium Xenon processors) box with 2 GByte RAM and RAID-5 hard drives. The only application that is running is SQL Server. The OS is Windows 2000 Server.
The database I am working with is about 3 GBytes with about 40 or 50 tables in it. One of the tables, "myTable", has 3 million records.
Under these circumstances, when I execute something simple like:
DELETE FROM myTable
how long should this statement take to execute? It takes a very long time on the above machine (5-10 minutes). Is that reasonable? I have "Truncate Log on Checkpoint" checked.
Thank you,
Aristotle