We are now coming into the second year of our Moodle installation. Now the students have returned, we have been having some major perfromance issues. Our engineers have followed many of the suggestions from the performance documentation at moodle.org. We think it may be to do with the Free TDS connector and SQL Server causing bottlenecks when writing to the database and we are trying different solutions to this. We are looking for anyone that is running the same set up as ourselves that may be able offer some advice (or warn of pitfalls).
Our system setup:
Windows Server 2008 64 bit
SQL Server 2008 Standard Release (running on a separate box)
Web Server running IIS 7
Free TDS Connector (although possibly trying to recompile ODTP connector to 32bit from 16bit)
If anyone can offer some advice on this it would greatly appreciated.Does anyone know if migrating the database from SQL server to MySQL will solve this issue?
Thanks for your help Visvanath.
We find that a lot of the problem was due to an issue with the server. We ended up moving the moodle application server on to a box at least a third of the spec and increased performance by a huge amount!
Now... just off to solve that Microsoft issue!