+ Post New Thread
Results 1 to 6 of 6
MIS Systems Thread, Database Deadlocks in Technical; I have a school who is getting about 3-12 database deadlocks within SIMS everyday. They seem to be appearing when ...
  1. #1

    Join Date
    Dec 2011
    Location
    SUNDERLAND
    Posts
    3
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Database Deadlocks

    I have a school who is getting about 3-12 database deadlocks within SIMS everyday. They seem to be appearing when Registers/Edit marks routines are bing used within SIMS.

    I suspect that this is performance related so far I have tried:

    Installing a Reindex Patch
    Switching off homepage widgets
    Archiving Attendance Marks
    Shinking the LDF etc

    I have a trace running and the school is still getting database deadlock error messages, Capita have the log files but I was wondering if anyone else has ever had a similar problem?

  2. #2

    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
    Ask whoever is in Edit Marks to not use it until all registers are done in the morning. That might help. There are some changes coming in this area which might also help this issue, as the Edited Marks are going to have precedence over teacher entered marks.

  3. #3

    Join Date
    Dec 2011
    Location
    SUNDERLAND
    Posts
    3
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Thanks, I have tried this but still having problems......

    Deadlocks are also appearing when using different areas of SIMS.

  4. #4

    Join Date
    Apr 2007
    Location
    Cornwall
    Posts
    309
    Thank Post
    19
    Thanked 85 Times in 57 Posts
    Rep Power
    38
    Our attendance officer gets these approx once every week or two, but I've only ever seen it with her.

  5. #5

    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
    Look around at the other threads regarding performance as there are other things you can do to troubleshoot. You might find something on a search for deadlocks.

  6. #6

    jinnantonnixx's Avatar
    Join Date
    Mar 2011
    Location
    In the Calamatorium.
    Posts
    2,028
    Thank Post
    119
    Thanked 513 Times in 347 Posts
    Blog Entries
    2
    Rep Power
    288
    We use attendance a lot; I'll ask our SIMS team if they come across this error.

    By the way, are the error messages from SIMS, or a .net exception?

SHARE:
+ Post New Thread

Similar Threads

  1. Technical Databases
    By RobC in forum Educational Software
    Replies: 15
    Last Post: 21st April 2006, 06:45 PM
  2. Designing Access Databases
    By RobC in forum Windows
    Replies: 2
    Last Post: 20th December 2005, 11:56 AM
  3. Online Database
    By Pear in forum Windows
    Replies: 12
    Last Post: 11th November 2005, 11:52 AM
  4. Student Performance Database
    By mark in forum Educational Software
    Replies: 10
    Last Post: 12th August 2005, 09:09 AM
  5. Database with a Barcode Reader
    By mrtechsystems in forum General Chat
    Replies: 5
    Last Post: 28th June 2005, 09:01 AM

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
  •