SQLXML Slow Performance after Installs - 05-06-2005 , 10:46 AM
I have a DTS package that loads XML files with an ActiveX script and the
SQLXML Bulk load object. I also have a C# web application. If I install the
web app on the server the SQLXML Bulk load runs extremely SLOW. The problem
is fixed by a reboot of the server...I'm not sure why this solves the issue?
The performance problem was also experienced after installing Microsoft
Office. Again, a reboot solved the issue.
Almost forgot...here's the environment....
SQL 2000 SP3a
Reporting Services SP1
Any ideas on this one??????
Re: SQLXML Slow Performance after Installs - 05-09-2005 , 04:44 PM
It is a low possibility but it could be due to the BSTR allocations. Could
you check that if the memory footprint gets bigger as well?
Could you also check if Bulkload (or ActiveX script hosts the Bulkload)
utilize the cpu at full power?
This posting is provided "AS IS" with no warranties, and confers no rights.
"SQL Guy" <SQLGuy (AT) discussions (DOT) microsoft.com> wrote