Troubleshooting SQL database growth issues in SoftGrid

A SQL Database issue that we have seen in the field with SoftGrid 4.1 Servers is the SoftGrid SQL database growing very large and reaching a point where the SoftGrid server becomes sluggish and starts showing signs of intermittent connectivity problems with the SQL Server. You will see 1105 SQL errors in the system application […]

A SQL Database issue that we have seen in the field with SoftGrid 4.1 Servers is the SoftGrid SQL database growing very large and reaching a point where the SoftGrid server becomes sluggish and starts showing signs of intermittent connectivity problems with the SQL Server. You will see 1105 SQL errors in the system application log and numerous entries like the following in the sft-server.log:

[2007-07-05 15:00:09.875] SFTHOST1 3424 3464 SW_SQLOutputHandler::HandleMessage -
- - - 1 41538 "Failed to log message to SFTHOST1. Got unknown error while creating record in data store."

On a clean install of SQL 2000 or SQL 2005 and SoftGrid 4.1 by default the SQL Server Agent service is not enabled and the 3 or 4 SoftGrid SQL Jobs (3 for 3.2 and 4 for 4.1) never run which causes unrestricted growth of the SoftGrid Database. Please be sure to enable this service by right clicking on SQL Server Agent and selecting start from the context menu.

Full Article