Skip to main content

Start of semester problems

I was perhaps tempting fate with my previous post on this blog, as we had a crash on our student record system yesterday, in the middle of Freshers' week.  As the staff were mainly using the Personal Tutors system at the time, they saw this new system as the problem, and indeed we were investigating that as a potential cause ourselves.

In fact the new system was not the problem.  The cause of the crash was actually a change we made to the database parameters back in May in order to improve the performance of a search operation on the student hub - the part of the student record system that gives academic staff information about their students.  Although we tested the change at the time, it was not possible to exactly duplicate the usage we see at the start of the new academic year.  It turned out that the high load on the student hub, combined with the high load on other areas of the system, was overloading one area of memory and causing the whole system to back up.

We changed the parameter back to its old setting this morning and saw an immediate and dramatic improvement in performance.  Registry support staff are consulting users to see whether this technical fix does indeed address the actual problem for our users.  Hopefully this will allow the academic staff to meet their students without being held up by IT problems.  We are continuing to monitor the situation and we are also fine tuning some aspects of the Personal Tutors system as well to reduce the overall load on the database. 

In time, we will have to revisit the problem that the original change to the parameter was intended to solve.  We think that the advent of the Personal Tutors system will be helpful here, as in many cases it will remove the need to search for a cohort of students.  But this is speculation and we will need to back this up with data from real use in the schools.

Comments

Popular posts from this blog

Project Leadership

When I look back over recent projects that I've been involved in, it seems that one key to making a project successful is having someone on the team who really drives it forward: someone who is invested in the project as a whole and not just their own part in it. We (by which I mean the University's Applications division) have a well-defined project process, with defined roles, required milestones, deployment standards, and so forth.    All these are useful, but if the team doesn't have a leader, it seems a project can lose its way, perhaps not responding to changing circumstances, getting stuck on a technical problem, or not securing a needed resource in time to meet some external constraint. The leader can be any member of the team - it could be a developer, a project manager, or the sponsor, or someone in another role.  A team can include several people who are this committed to the project; it doesn't have to be a single person.   As an example, one of...

Business Model Canvas

A Business Model Canvas is a tool for mapping the core functions and capabilities of an organisation.  Compared to the Core Diagrams that I described in an earlier post , the business model canvas attempts to present more aspects of the business, starting with the value proposition – a statement of what the organisation offers to its users (in the business world, to its customers).  It shows the activities and resources, as Core Diagrams do, but also shows user relationships & channels, and also benefits and costs.  I’m not aware of any universities that have used this tool but you can find examples from elsewhere on the web. We are considering business model canvases as a tool for mapping the strategic capabilities of units at the University of Edinburgh.  Phil Taylor, our EA contractor, sketched an outline of what a business model canvas might begin to look like for HR: This is only intended to be suggestive: the real canvas would need to result from in-de...

"That's not Grid!" - A cautionary tale

I don't usually attempt humour here, but see if you like this... Once upon a time, in the far-off world of Computerland, a great guru arose and declared a vision. "I see a future when all computers will be linked together and people will run their programs without knowing which computers are running them. People do not need to know where their jobs run; they just need the results. I call this Grid Computing!" The people of Computerland were excited by the guru's vision. They went away and worked to make it happen. When they were ready, they returned to the guru and said: "Oh great guru! We have implemented your vision. We can run our programs on whichever processor is free at the time, making sure that all programs can run and making best use of all our processors. No longer does one computer sit idle while another one is overloaded. Your vision is a great success!" "No, no, no!", said the guru, "That's not Grid!" The guru exp...