March 26, 2008 at 4:51 pm
Hi,
We have had an outstanding issue in our store's DBs for a while now. Performance on writing records to tables in the DB takes ages. Using BCP, to write 5000 records will take about 20-30 mins.
I have tried running the following queries to try and fix:
SQLMAINT -S %DBSSRV% -D DB -CkDB -CkAl -CkCat
SQLMAINT -S %DBSSRV% -D DB -RebldIdx 1
SQLMAINT -S %DBSSRV% -D DB -RmUnusedSpace 100 10
If I drop the table i am trying to write to and recreate it, the performance is back to normal, but it is affecting almost or maybe all tables in the DB.
I found that the performance issues follow the MDF and LDF, as I copied these files to another PC and the issue followed.
I am running MSDE 8.00.760, but i dont think upgrading this will fix, as other machines have no issue with the same version.
My last resort fix is to drop a fresh copy of the DB into the PC and reimport the data, but this is a massive job for 250 stores. Is there anything someone can suggest I try before I surrender myself to this issue??
Any help will be appreciated.
Thanks
March 31, 2008 at 8:36 pm
Is there any index on your table? If so, you may try to drop the indexes before addding data. After completing your update of data, re-create indexes.
March 31, 2008 at 8:59 pm
Hi,
I'm not sure what you mean about your question. I thought the command above rebuilds indexes??
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply