Connection pooling/limit for SQL Server and Linq-to-SQL

Question

I found this article regarding Linq-to-SQL and SQL Server connection pooling: MSDN Blog

From what I assume from the article, is that Linq-to-SQL using the same Max Pool Size setting just as if it was an ADO object.

I have an C# app that is hitting the database pretty hard. Is there a way to tell if I am hitting my connection limit? How can I tell if my connections are being queued?

Ladislav Mrnka · Accepted Answer · 2011-06-24 13:20:04Z

3

Use performance counters. You should be interested in following counters:

NumberOfPooledConnections - how many connections your pool mantain
NumberOfActiveConnections - how many connections are in use
NumberOfFreeConnections - how many connections are not in use

Last two counters require some modification in your application configuration.

Another article about working with these counters.

answered Jun 24, 2011 at 13:20

Ladislav Mrnka

365k60 gold badges666 silver badges673 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

marc_s · Accepted Answer · 2011-06-24 12:59:17Z

1

you could open a connection and execute this stored procedure; assuming you use sql server.

EXEC SP_WHO

you could compare all connections to the dbname with status != sleeping.

edited Jun 24, 2011 at 12:59

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Jun 24, 2011 at 12:57

NickD

2,6467 gold badges37 silver badges60 bronze badges

1 Comment

NickD Over a year ago

i found this interesting article: msdn.microsoft.com/en-us/library/aa175863%28SQL.80%29.aspx

Collectives™ on Stack Overflow

Connection pooling/limit for SQL Server and Linq-to-SQL

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related