[SIMS] SQL server using full CPU of server to export CTFs
I found out this morning that when our finance officer runs the export routine for CTF files for our year 8 pupils, it maxes out the CPU usage of SQL server.
Now, we're only running the Express edition of SQL 2005, but it has done us fine up until now. We didn't have this problem in previous years.
Does anyone have any idea why the CTF export is being so heavy on the server now, or is it simply time to move to the full SQL server to allow it to make use of multiple cores?