+ Post New Thread
Results 1 to 6 of 6
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 ...
  1. #1

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,684
    Thank Post
    516
    Thanked 2,453 Times in 1,899 Posts
    Blog Entries
    24
    Rep Power
    833

    [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?

  2. #2

    bossman's Avatar
    Join Date
    Nov 2005
    Location
    England
    Posts
    3,915
    Thank Post
    1,189
    Thanked 1,063 Times in 754 Posts
    Rep Power
    329
    @localzuk:

    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.

  3. #3

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,684
    Thank Post
    516
    Thanked 2,453 Times in 1,899 Posts
    Blog Entries
    24
    Rep Power
    833
    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).

  4. #4

    bossman's Avatar
    Join Date
    Nov 2005
    Location
    England
    Posts
    3,915
    Thank Post
    1,189
    Thanked 1,063 Times in 754 Posts
    Rep Power
    329
    @localzuk:

    Unlucky bud but this is what Capita recommend!

  5. #5

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,684
    Thank Post
    516
    Thanked 2,453 Times in 1,899 Posts
    Blog Entries
    24
    Rep Power
    833
    Quote Originally Posted by bossman View Post
    @localzuk:

    Unlucky bud but this is what Capita recommend!
    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.

  6. #6
    Sarconia's Avatar
    Join Date
    Mar 2010
    Location
    London
    Posts
    315
    Thank Post
    15
    Thanked 34 Times in 31 Posts
    Rep Power
    16
    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.

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 9
    Last Post: 24th February 2010, 10:54 PM
  2. SIMS/SQL CPU core utilisation
    By meastaugh1 in forum MIS Systems
    Replies: 1
    Last Post: 27th July 2009, 10:56 AM
  3. sims.net SQL Server CPU Spike
    By itgeek in forum MIS Systems
    Replies: 6
    Last Post: 26th February 2009, 12:28 PM
  4. SIMS communication with SQL server
    By dhicks in forum MIS Systems
    Replies: 9
    Last Post: 14th December 2007, 09:05 AM
  5. sql server sims sa password
    By Uraken in forum MIS Systems
    Replies: 18
    Last Post: 27th February 2007, 08:09 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •