+ Post New Thread
Results 1 to 12 of 12
MIS Systems Thread, Nova T4 Reports to slow in SIMS in Technical; Hi Guys, I am frustrated with the reports in SIMS!!!!! To call up a teacher/student timetable is so slow, I ...
  1. #1
    CatherineMay's Avatar
    Join Date
    Jun 2011
    Location
    Wigan
    Posts
    68
    Thank Post
    24
    Thanked 5 Times in 3 Posts
    Rep Power
    7

    Nova T4 Reports to slow in SIMS

    Hi Guys, I am frustrated with the reports in SIMS!!!!! To call up a teacher/student timetable is so slow, I could run round and look in every rooms before the timetable appearing in screen!!! Anybody else having the same problem.

  2. #2

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    18,156
    Thank Post
    522
    Thanked 2,551 Times in 1,980 Posts
    Blog Entries
    24
    Rep Power
    877
    It just took me 3 clicks to bring up a timetable for a teacher here, with about 5 seconds waiting whilst it churned away.

    Repeated this with a pupil, and again, 3 clicks, less time processing.

    How are you pulling the reports up? I assume you are referring to Reports -> Timetables -> Staff/Student timetables?

    What stage is taking so long?

  3. #3
    CatherineMay's Avatar
    Join Date
    Jun 2011
    Location
    Wigan
    Posts
    68
    Thank Post
    24
    Thanked 5 Times in 3 Posts
    Rep Power
    7
    Yes I am referring to Reports -> Timetables -> Staff/Student timetables, the first screen appears immediatley,select the person I want, and wait, wait wait and wait!!!!

  4. #4

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    18,156
    Thank Post
    522
    Thanked 2,551 Times in 1,980 Posts
    Blog Entries
    24
    Rep Power
    877
    That sounds like your SIMS server is not up to the job. Can you provide us with the following details?

    Database size (the .mdf file size):
    Spec of the server (CPU/RAM and whether you have the OS on a different drive array to the database files):
    Which version of SQL Server you're running (Express or full):
    Amount of memory that the sqlservr.exe process is using on the SIMS server:

    Then we can advise as to where you need to make changes.

    Our SIMS server here is an Operton 2Ghz dual core system, running 3GB RAM, with SQL Express and a database of just over 1GB in size. The sqlservr process uses about 1.2GB RAM and we have zero issues with slowdowns like you describe.

  5. #5
    CatherineMay's Avatar
    Join Date
    Jun 2011
    Location
    Wigan
    Posts
    68
    Thank Post
    24
    Thanked 5 Times in 3 Posts
    Rep Power
    7
    Thanks for that, I will ask the IT System Manager for the specs and get back to you.

  6. #6
    BatchFile's Avatar
    Join Date
    Aug 2007
    Location
    Cumbria
    Posts
    955
    Thank Post
    548
    Thanked 128 Times in 106 Posts
    Rep Power
    60
    This might also be a good time to request the database re-index patch from whoever you get your SIMS support from; that should make all your reporting activities run much faster.

  7. #7
    CatherineMay's Avatar
    Join Date
    Jun 2011
    Location
    Wigan
    Posts
    68
    Thank Post
    24
    Thanked 5 Times in 3 Posts
    Rep Power
    7
    Already have the patch!

  8. #8

    bossman's Avatar
    Join Date
    Nov 2005
    Location
    England
    Posts
    3,967
    Thank Post
    1,210
    Thanked 1,075 Times in 766 Posts
    Rep Power
    332
    @CatherineMay:

    Less than 3 seconds here, so I would conclude that it is either the database that needs re-indexing which has already been covered or as @loculzuk has mentioned your server is not up to the job.

    We have it running as VM with only one CPU at the moment with 8Gb RAM looking at increasing the CPUs to at least 2 to see if it does make any difference.

  9. #9

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,785
    Thank Post
    715
    Thanked 1,440 Times in 1,193 Posts
    Rep Power
    359
    When did this start? Is it all day everyday for a while?
    If it's recent, it could just be someone is doing something that taxes the system, e.g. applying a timetable for next year, promotion or other such end of year task.

  10. #10

    m25man's Avatar
    Join Date
    Oct 2005
    Location
    Romford, Essex
    Posts
    1,644
    Thank Post
    49
    Thanked 467 Times in 339 Posts
    Rep Power
    141
    As stated, we need more system info to help with this one.
    I have SIMs running on small servers with barely more power than a desktop and others with 8 cores and 64Gb of RAM
    It all depends on what your trying to do with it.

    RAM is your highest priority because with little RAM SQL will be thrashing the Disk I/O using the disk as Virtual RAM, if you have a slow disk subsystem and little RAM your in trouble.
    Couple this to what @vikpaw says, background applications, file serving and AV could tax your system more than a Tory government in a recession...

    Check your AV settings make sure your not on demand scanning every file open/close in your database and on your clients make sure your not AV scanning every file on your SIMs network drive/path. Your AV scanning overheads can cripple SIMs and other database applications.

  11. #11
    CatherineMay's Avatar
    Join Date
    Jun 2011
    Location
    Wigan
    Posts
    68
    Thank Post
    24
    Thanked 5 Times in 3 Posts
    Rep Power
    7
    Thanks for all your replies. Everything is over my head. I have inserted below the email from our tech.

    Hi Cath,
    Database size (the .mdf file size): 3,097,088kb
    Spec of the server: Dual Core Hyperthreaded Intel Xeon cpu 3.0ghz 4gb of ram
    Which version of SQL Server you're running (Express or full):full SQL server 2008 EE
    Amount of memory that the sqlservr.exe process is using on the SIMS server: 1,744,248kb

    Cheers
    Phil

    Does that help?


  12. #12

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    18,156
    Thank Post
    522
    Thanked 2,551 Times in 1,980 Posts
    Blog Entries
    24
    Rep Power
    877
    Its a little odd that the SQLServr.exe process is using so little RAM with a database of that size.

    However, as a beginning point, I'd suggest getting your network manager to disable hyperthreading and then retry the timetable reports. Hyperthreading can cause big issues with SQL server. I have it disabled on our SQL Server machine for this reason. (This is done in the server bios).

SHARE:
+ Post New Thread

Similar Threads

  1. [PASS] Producing School Reports - Slow...
    By asprisa in forum MIS Systems
    Replies: 5
    Last Post: 8th November 2011, 04:58 PM
  2. [SIMS] Nova T4? All functions now in SIMS.net and T6?
    By localzuk in forum MIS Systems
    Replies: 9
    Last Post: 9th June 2011, 10:07 AM
  3. [SIMS] NOVA T4 error - Help [Solved]
    By timbo343 in forum MIS Systems
    Replies: 1
    Last Post: 7th June 2010, 09:58 AM
  4. SiMS and Nova T
    By Kyle in forum Educational Software
    Replies: 14
    Last Post: 19th May 2009, 12:23 PM
  5. Installing SIMS/NOVA T on a laptop
    By randle in forum MIS Systems
    Replies: 4
    Last Post: 16th March 2007, 05:22 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
  •