SQL Server Performance Forum – Threads Archive

Ok here is the issue

When i run this SELECT spid, dbid,uid=rtrim(loginame), Program_name=rtrim(Program_name), dbname=db_name(dbid), status=rtrim(status) FROM master.dbo.sysprocesses I see the connection showing up and in the next second it is gone. The connectionstring i have is Provider=SQLOLEDB.1;Integrated Security=SSPI<img src=’/community/emoticons/emotion-4.gif’ alt=’;P’ />ersist Security Info=False<img src=’/community/emoticons/emotion-4.gif’ alt=’;p’ />ooling=true;Min Pool Size=3;Max Pool Size=5;Connection Lifetime=120;Initial Catalog=test;Data Source=TESTMACHINESQLEXPRESS; And then in the log, the log grows almost every second 3 entiries !! "Login succeeded for user ‘TESTMACHINEUser’. Connection: trusted…." "Login succeeded for user ‘TESTMACHINEUser’. Connection: trusted…." "Login succeeded for user ‘TESTMACHINEUser’. Connection: trusted…."

In SQL 2005? Most if not all ‘system tables’ that you know from SQL 7.0 and 2000 have been replaced. And you should not be querying them anyway (unless there really is no other way to get at the information in a format that is useful to you).

yes it is sql 2005. dont worry about the query to system tables.
even sp_who gives me the same result. The point is that the connection drops and reconnects every second even though i have pooling setup. That is the problem !

Then play around with the specifics in the connect string: Min Pool Size=3;Max Pool Size=5;Connection Lifetime=120 — looks like a disruption waiting to happen, I’d drop all of them.

Im sorry im not sure I understand what you are saying

You’re instructing SQL Server to work with very specific settings for connection pooling, and a time-out. As usual, SQL probably knows best if you leave it to figure it out all by itself – so drop those parameters, and use a case-identical connection string to get the pooling going.

Even if i drop all the parameters and just have pooling=true still it does not hold on to the connections. Please help !!!!!!!!!!!!!! my customer is really unhappy with this <img src=’/community/emoticons/emotion-6.gif’ alt=’

‘ />((

check that your application doen’t clear all existing pools when it ends (or ends a part of its code)

]]>