Sunday, April 23, 2006
Connection Pooling
This is a very interesting funny notice :
Connection Strings must be IDENTICAL . so what is new ?
Conn1 : "Server=SQL01;Database=AdventureWorks;Integrated
Security=SSPI;Pooling=true"
Conn2 : "Server=SQL01;Database=AdventureWorks;Integrated Security=SSPI
;Pooling=true"
These are not identical since the second connection string has a SPACE after
the word SSPI, so they generate two different pools.you can examine that by
SQL Profiler .
It is very interesting ha .
