Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Recently I noticed one interesting issue in our production server. We have an app server (IIS and asp .net framework) and a DB server (SQL Server 2008) installed.

During peak time when I try to telnet my DB server on 1433 it keeps getting failed but sometimes it gets connected. Both these servers are blade server and are in same chassis. No network firewall is in between all the two servers.

Also in application logs its shows error like

A network-related or instance-specific error occurred while establishing a connection to SQL Server. 
The server was not found or was not accessible. 
Verify that the instance name is correct and that SQL Server is configured to allow remote ... 
Provider, error: 40 - Could not open a connection to SQL Server

I checked number of connections on my DB using the command

SELECT  COUNT(dbid) as TotalConnections 
FROM sys.sysprocesses 
WHERE  
dbid > 0 

it returns approximately 140-150 connections while we have multiple databases (~100) on it.

I will appreciate if anybody can help me in troubleshooting this issue.

We are making connection strings as <add name="DBNAME" connectionString="Data Source=10.X.X.X;Initial Catalog=DBNAME;User ID=sa;Password=test" providerName="System.Data.SqlClient" />

Also in web config we have <sessionState timeout="10" />

share|improve this question
    
What are your configuration settings regarding connections? –  dezso Oct 31 '12 at 9:57
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.