SQL Server Freezing Up
Posted on 2006-04-20
I have a Windows 2003 Server running an ASP.Net application against a SQL Server Database. Each client on the system has its own instance of the database. We were recently the victim of several attacks including several aimed at SQL Server itself. We have tightened our defenses with firewall setting that deny everything except manually entered IP address. Since we have changed our security policy SQL Server has started to freeze up under normal traffic conditions and requires a reboot of the server to clear it and then its fine again for about a day then the same thing. Our app times out when making requests to SQL.
The SQL Logs reflect a large number of rollbacks/rollforward messages. These are very small databases and the Trans Logs are less than 5 Mbs.
I need help please.