MIS Systems Thread, [SIMS] SQL server using full CPU of server to export CTFs in Technical; I found out this morning that when our finance officer runs the export routine for CTF files for our year ...
21st June 2010, 10:08 AM #1
[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?
21st June 2010, 10:20 AM #2
Due to Capita recoding some of the Sims modules they now recommend SQL 2008 as its execution of the code is quicker.
I would recommend a move to the Standard SQL2008 or even Enterprise if you can afford it as the use of multi-core CPUs is much better plus a decent amount of RAM (We have 8Gb) this gives quicker access to Sims server from the client workstations and the time it takes the teachers from clicking the Sims shortcut to their welcome page is 11 - 15 secs.
Only a recommendation.
21st June 2010, 10:39 AM #3
Our problem is that we follow the timeline for SIMS/SQL of our local LEA support team and they have not yet released details of the SQL2008 update to us, so I'd be reluctant to make any changes until they do (as they are the ones who provide our SIMS support).
21st June 2010, 10:42 AM #4
Unlucky bud but this is what Capita recommend!
21st June 2010, 10:45 AM #5
Yeah, the other issue is that our LEA provide our SLG2 access, so any database changes require them to make changes too - which won't happen until they roll it out LEA wide.
Originally Posted by bossman
21st June 2010, 10:46 AM #6
I'd have to agree with Bossman on this one although I'd also give your LEA a prod and ask them when they're migrating you, it's most likely they'll be doing it over the summer but they could just as easily do it in the evening after everyone has logged out of SIMS.net.
By fox1977 in forum Licensing Questions
Last Post: 24th February 2010, 10:54 PM
By meastaugh1 in forum MIS Systems
Last Post: 27th July 2009, 10:56 AM
By itgeek in forum MIS Systems
Last Post: 26th February 2009, 12:28 PM
By dhicks in forum MIS Systems
Last Post: 14th December 2007, 09:05 AM
By Uraken in forum MIS Systems
Last Post: 27th February 2007, 08:09 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)