KingDuncan

There might be another angle with regards to SIMS appearing slow. We have had an issue going back to March, where on the surface it looks like SIMSv7 is going slow (staff get a spinning wheel after pressing save and have to wait ages), but the reality is that in the background there are queries being run by SSM to synchronize SIMSv7 on prem with SIMS Next Gen, and when these queries run, they apply an exclusive lock on various tables in SIMSv7. So what users are actually experiencing is a lock not slow speed. In theory the queries being run by SSM should be quite quick with an incremental update, but I am of the opinion that each time the query runs it is doing a full sync. One of the queries runs for an hour, has a 3-5 minute breather and then goes again. While this query runs staff cannot enter their end of term Marksheets in SIMSv7!! I would be really interested to find out if anyone else has the same issue.

@ozydave I have an absolute mare with our SIMS at the mo. I see that you have run queries against your SQL. I have been doing the same to try and find out what is consuming all the resources. I am trying to find someone who would be willing to run a SELECT SQL on their database to try and compare with another SIMS installation. There is a particular query that SSM runs and it runs for 20min! Would you be happy to run a simple SELECT query to see how long the SSM query runs on your installation? This is a link to my initial post - https://www.edugeek.net/forums/topic/226570-sims-user-lock-issue/#comment-2028821 Many thanks if you can assist.

Hi David, Is this something that you are able to run? Thanks

This is what I run at various intervals. This query will highlight the users who are locked and the locking session. It also will display the SSM user while it is running. SELECT r.session_id, s.login_name, s.host_name, r.start_time, DATEDIFF(MINUTE, r.start_time, GETDATE()) AS elapsed_minutes, r.cpu_time, r.logical_reads, r.writes, r.wait_type, r.blocking_session_id, t.text AS running_query FROM sys.dm_exec_requests r JOIN sys.dm_exec_sessions s ON r.session_id = s.session_id CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) t WHERE s.is_user_process = 1 ORDER BY elapsed_minutes DESC; It is obviously just a snapshot so I have to refresh at regular intervals. I also use this to check how long the SSM user has been running for (note - the user account defined in our SSM is SSMConnect). SELECT s.session_id, s.login_name, at.transaction_begin_time, DATEDIFF(MINUTE, at.transaction_begin_time, GETDATE()) AS OpenMinutes, r.status, r.wait_type, st.text FROM sys.dm_tran_active_transactions at JOIN sys.dm_tran_session_transactions stt ON at.transaction_id = stt.transaction_id JOIN sys.dm_exec_sessions s ON stt.session_id = s.session_id LEFT JOIN sys.dm_exec_requests r ON s.session_id = r.session_id OUTER APPLY sys.dm_exec_sql_text(r.sql_handle) st WHERE s.login_name LIKE '%SSMConnect%' ORDER BY OpenMinutes DESC; Thanks

We have a rather complex locking issue in SIMS (outstanding since March). I want to see what "normal" behaviour looks like, so I would like to communicate with an IT manager that fits into this spec - Uses SIMS on premise - Uses SIMS Next Gen (and by extension has SSM running on their server) - Is comfortable logging into their SIMS SQL Database using Microsoft SQL Server Management Studio - Is happy to run a simple SELECT query on their database to observer the behaviour of a particular program initiated by SSM - Not essential, but a Single Academy Trust If this is you, I would be very happy to make contact. The issue we have is that SSM is running a procedure at 5 min to the hour and 25 min past the hour for 20 minutes. While this procedure is running, various user activities on SIMS causes a lock, which then cascades to all users on SIMS. All locks are released 15 min after the start of the SSM procedure. I am really interested to see if the same program is being run on any other system, and how long it takes to run. At the moment the query performs over 338 million logical reads of the database which seems quite high. I am working through our normal support channel and this problem has made its way all the way to the developers where we have had a patch designed and installed on our server, but we still have issues. I really want to check how long the particular query runs on another server. Many thanks Duncan

I have replaced my wireless network and have the following which are no longer required. 21 X Xirrus XN4 5 X Xirrus XN8 1 X Xirrus Controller Ideally I would like to generate some revenue for the school as they were all in good working order before we replaced them. Off the top of my head, I would be happy for £20 for each. £500 (rounded down) for a complete wireless solution not too bad!? Cheers Duncan Waddesdon CE School

Thanks for the quick response. When clicked, I get a message to say that the Repository Clean up has been scheduled. Will this then happen automatically at some point in the future or do I need to action the scheduled task somehow? Many thanks

Is it ok to delete pkg files? I have a number in the following directory tree SIMS\Solus3\Repository\DoNotDeleteThisFolder\... I obviously do not intend to delete the folder, but within that folder there are a number of randomly numbered folders with very large pkg files. They seem to relate to upgrades, but they are taking up a huge amount of space (1.6GB altogether). Thanks Duncan

Hi eyetea, Very many thanks. Much appreciated.

I am looking for the drivers for LaserCam A2+ if anyone has them handy. Thanks in advance.

In the meantime, head over to https://office365.uservoice.com/forums/273494-outlook-and-calendar/suggestions/9339999-please-change-the-default-reply-all-button-to and register your vote to change it back.

Also colour blind. More rods than cones, so differentiating between shades of colour obviously enhanced.