Next privilege 200 Rep.
See reduced ads
Next badge 0/1
~2k people reached
- 0 posts edited
- 0 helpful flags
- 0 votes cast
SQL server availability issue: large query stops other connections from connecting
My colleague's DB is optimized, with an index, specifically for what he is querying. I don't think he's joining anything, it's just a massive, massive table. I'm connecting with an ADO.NET application, and my connection times out. Also, we are on logically different databases, if that means anything. You probably do get paging with such a huge query, but why should it affect the little connection? Could it be the huge query is jamming up the network socket, so that I'm not getting my connect message through?
Problem remotely managing Exchange Server 2010
I shall check your list in the morning when I get into the office. Thanks for now.