sqlserver.exe uses 100% CPU
- by Markus
I've created an application (asp.net) that once a day syncs an entire database through XML-files. The sync first creates an transaction and then clears the databases tables and then starts to parse and insert the new rows into the database. When all the parsing is complete it commits the transaction.
This works fine on a SQL Server 2005 (on another machine), but on SQL Server 2005 Express, the process starts to use 100% CPU after a while, and as I log the inserts being made I can see that it just stops inserting. No exception, it just stops inserting.
Anyone got any idea what this may be? I've previously run the syncronization on another sql 2005 express (also on another computer), and that worked.
The server has only 2GB RAM, could this be the problem?