+ Post New Thread
Results 1 to 8 of 8
MIS Systems Thread, Anybody use Intouch? Server getting hammered since Summer update in Technical; Now the new term is in full swing i've been getting reports that SIMS.NET the client is quite slow, which ...
  1. #1

    Join Date
    Jun 2012
    Posts
    7
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Anybody use Intouch? Server getting hammered since Summer update

    Now the new term is in full swing i've been getting reports that SIMS.NET the client is quite slow, which I am seeing for myself. Some screens load quickly, others take a noticeably long time to appear.

    I've been doing some monitoring on the server using perfmon and SQL profiler and my investigation seems to identify the culprit to be the "sims.itc_pix_MyMessagesWidget_Load" stored procedure. The average execution time of the query is around 2500-3000 milliseconds, but what i think is causing the excessive load on the sql engine is the number of reads required for the operation which range from about 250,000 to over 600,000 - this number is (hundreds of) thousands times more than what i'm seeing as an average for most other operations, only a few seem comparable and this procedure seems to be executed on the server every few seconds by all the users who happen to have SIMS open and it's executed by any given user about every 60-90 seconds, give or take.

    This operation stands out like a sore thumb because many other operations occur with less than 50 reads and with significantly less cpu time. It just looks like the number of users using SIMS, leaving it open with the background checking of messages is killing the server. I see other stored procedures taking lots of cpu time and requiring many reads, such as sims.sta_pix_BehaviourSummary_Load and sims.sta_pix_AchievementSummary_Load, but these occur significantly less frequently and appear user initiated, sims.itc_pix_MyMessagesWidget_Load just seems to gobble cpu cycles and disk in the background.

    by any stretch, an operation which happens every few seconds requiring 600,000 reads seems abnormal, especially for something as simple as updating a message widget. This seems to be something which changed in the Summer update as we didn't have this last year.

    Any other intouch users finding this?

  2. #2

    glennda's Avatar
    Join Date
    Jun 2009
    Location
    Sussex
    Posts
    7,821
    Thank Post
    272
    Thanked 1,140 Times in 1,036 Posts
    Rep Power
    351
    I fairly sure that is the My Messages front end widget on the homepage. I would get in touch with Capita and ask why its hammering the DB.

  3. #3

    Join Date
    Jun 2012
    Posts
    7
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Thanks Glennda,

    I have indeed reported this case to Capita, but they haven't responded, I'm not really sure what's going on with them at the moment because we have another outstanding issue with SLG users not being provisioned (which, appears not to be just us as another school in the next town has the same problem) but normally they respond the same or next day, this call has been open a week with no further contact. I don't have high hopes for this one, either sadly (i reported it yesterday)

  4. #4

    glennda's Avatar
    Join Date
    Jun 2009
    Location
    Sussex
    Posts
    7,821
    Thank Post
    272
    Thanked 1,140 Times in 1,036 Posts
    Rep Power
    351
    Get @PhilNeal to give them a prod then - a week IMHO is unacceptable especially with the problem it looks like you are having.

  5. #5

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,404
    Thank Post
    38
    Thanked 387 Times in 262 Posts
    Rep Power
    85
    @Eric_Bisto Feel free to get in touch or email one of the support desk managers - details are on SupportNet under sticky items. Our new system isn't without issues so its possible that your case is being updated but you can't see the details. What ever it is please get in touch and we'll check things out.

  6. #6

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,522
    Thank Post
    374
    Thanked 677 Times in 551 Posts
    Rep Power
    166
    Isn't there a setting to increase the time it waits before checking for new message - maybe a tempory solution at least

  7. Thanks to matt40k from:

    vikpaw (24th September 2012)

  8. #7

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,956
    Thank Post
    775
    Thanked 1,487 Times in 1,234 Posts
    Rep Power
    367
    @Eric_Bisto - as @matt40k said, the timing may help ease things. I think the default is 30 seconds, at least it was, mine is set to 300. You can increase it up to 3600.
    I think it's a per user setting, you'd have to go in as each user click on the spanner / wrench icon for that panel and then alter it.
    It won't help first thing when all users go in for the first time, but hopefully, if they close sims and reopen through the day, the larger timeout will create a staggered effect. otherwise you could manually set a stagger as you go and change them.

  9. #8

    jinnantonnixx's Avatar
    Join Date
    Mar 2011
    Location
    In the Calamatorium.
    Posts
    2,085
    Thank Post
    123
    Thanked 533 Times in 357 Posts
    Blog Entries
    2
    Rep Power
    336
    @Eric_Bisto
    I'm not clued up on Intouch, but I noticed that SIMS makes frequent use of the tempdb (with lots of INSERT INTO #temptables).

    Crack open your Acitivity monitor and check the Recent Expensive Queries. If the expensive queries do something like INSERT INTO #sometable you might see a benefit in moving your tempdb tables across to a dedicated disk, if you can, and increasing the number of files used by tempdb.

    http://sqlzen.wordpress.com/2011/02/...-optimization/
    Then again, it may be a red herring.

    From <link>:
    Following are some additional configuration and performance recommendations for tempdb:

    Create the tempdb database on a fast I/O subsystem. Use disk striping to numerous directly attached disks.

    Separate the disk space dedicated to tempdb from user databases.

    Create many files to maximize disk bandwidth and to reduce contention in allocation structures. As a general guideline, create one data file per CPU. Each file should be set to the same size. This enables the proportional fill algorithm to distribute the allocation load uniformly with minimal contention.
    Last edited by jinnantonnixx; 24th September 2012 at 04:58 PM.



SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 16
    Last Post: 4th July 2011, 01:32 PM
  2. Anybody using Sims Intouch in West/East Sussex or East Hampshire
    By glennda in forum South East Grid for Learning (SEGfL)
    Replies: 9
    Last Post: 3rd May 2011, 04:19 PM
  3. Anybody use CSE Webspace explorer ?
    By sathang in forum Courses and Training
    Replies: 15
    Last Post: 10th July 2009, 10:56 AM
  4. iLibra Mail??? Anybody use it?
    By CM786 in forum Wireless Networks
    Replies: 2
    Last Post: 22nd June 2006, 11:15 PM
  5. Anybody using SchoolGuard - comments?
    By SpuffMonkey in forum Wireless Networks
    Replies: 9
    Last Post: 10th May 2006, 10:51 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
  •