Query Analyzer gets disconnected, sleeping connections?
Posted on 2006-05-24
For the second time we are running in to this problem:
We have a database server running MS SQL Server. We have about 5 main databases running. We have a webserver running web based applications and a few workstations running 'normal' app's that all connect to the database server.
For some unclear reason at a certain moment I can not seem to connect to the database using the query analyzer. I connect normaly (SA user + password), I get my SQL query window, but as soon as I try to execute a query I get a new logon screen. If I then log on again, I get a blank query window, and so on...
Other processes (e.g. web pages using the database server) seem to work fine.
Restarting the SQL service will solve my problem... but it is far from a good solution.
I'm not a star DBA, but I began my search through the enterprise manager's reports. Using the 'Process Info' I find that there are a huge amount of sleeping processes (about 300!). Is this something to worry about, and could it have anything to do with my logon troubles in the query analyer.
Please help me