We have recently upgraded our Moodle from 1.9 running on Linux to 2.2.5+ running on Microsoft platforms.
- Windows Server 2008 R2 Enterprise
- IIS 7.5
- php 5.3.17
- wincache 1.1.0630.0
- MSSQL 10.50.1807.0
- SQLSRV DB driver
We are currently experiencing some commonly reported problems on our production environment.
1. cronjob failing
2. DB backups failing
3. Updating a file in an existing file resource
All three look like they may be related to the sqlsrv DB driver issue where:
"New transaction is not allowed because there are other threads running in the session"
We have been tuning our systems left right and center over the last two weeks and I am reluctant to switch from the SQLSRV driver to the FreeTDS driver based on lost of conflicting reports in the community.
I have recently brought it down to two realistic options:
1. Switch to FreeTDS driver for MSSQL DB
2. Override the sqlsrv to use a new DB connection only for new transactions where there is already an existing recordset active which has not been freed and the new query is for a delete or update.
I would much rather option one above as it is the most obvious.
Our site has about 2000 courses and about 15000 users.
Would anyone out there using FreeTDS for production with similar user and course number advise of their experiences and recommendations please?