Hi, I have an application (Dynacom) which as we speak is rebuilding its database and is taking an awful lots of time. Looking in the Activity monitor of the management studio I can see that the INSERT Task State is always in a SUSPENDED state waiting for
In the resource wait panel Logging, Recent and Average wait time (ms/sec) is around 925 and cumulative wait time (sec) at 0.9.
Logging seems to make everything crawl, Its taken so far 90 minutes to insert 5% of a 2.3GB database.
How can I fix this issue if possible knowing I don't have access to the application sources. Can something be set on the server to speed things up
View Complete Post