We have SQL 2005 Server with a SAP database of 400 GB in out Test enviroment (production machine is DB2 iSeries). We have a very extrange problem just with a sigle table. The table has about 56Mill of Rows an a size of 11 GB of data and 25 GB spent in indexes.
We have similar tables in the database (even bigger than this one) with a correct performance.
The performance of bulk deletes or inserts in this single table are extremly slowly. For instance, deleting 25 Mill of rows can take many hours (more than 20). CheckDB and othr maintence plans already applied without any issues.
View Complete Post