Hi Simon,
I have the following setup: There's a machine running IIS 5 and the
Application server with a CRM website; they're using a SQL 2000
database, located on a different
machine. The website is using the App server to interact with the SQL
server.
"Stops responding" means that no database-related action can be
performed on the website while this insert process is running. I tried
opening pages that are not in any way using the tables I'm inserting
into so it doesn't look like the problem is due to table locking. During
the process, IIS is not transmitting anything back to the user except
for status of the job when it's done, but until then a page i'm opening
basically hangs...
When I run the process, CPU utilization on the IIS machine is 1-2%, but
on the SQl machine it jumps up to 50-60%.
What puzzles me is that I tried running some queries right on the SQL
machine while it's running my large insert, and I do get results. So it
seems like the Queries which the APP server is requesting to run are
blocked, but other users can still use SQL server.
The more I dig into it, the more it seems like the problem is not in SQL
server, but in the App server.
Thanks very much for your suggestions.
Oleg.
*** Sent via Developersdex
http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!