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 ...
6th March 2012, 01:45 PM #1
- Rep Power
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?
6th March 2012, 01:49 PM #2
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.
6th March 2012, 01:55 PM #3
- Rep Power
Thanks, I have tried this but still having problems......
Deadlocks are also appearing when using different areas of SIMS.
6th March 2012, 03:30 PM #4
Our attendance officer gets these approx once every week or two, but I've only ever seen it with her.
6th March 2012, 07:54 PM #5
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.
6th March 2012, 08:29 PM #6
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?
By RobC in forum Educational Software
Last Post: 21st April 2006, 06:45 PM
Last Post: 20th December 2005, 11:56 AM
Last Post: 11th November 2005, 11:52 AM
By mark in forum Educational Software
Last Post: 12th August 2005, 09:09 AM
By mrtechsystems in forum General Chat
Last Post: 28th June 2005, 09:01 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)