Connection pooling ? Just trust the framework, don't be a wise ass
Just before the weekend I thought I was having a serious problem with the connections my app had with the sql server. To get some metrics I grabbed perfmon and did see real trouble. It looked like connection pooling was not behaving like it promised. After a first rather stupid attempt I gave it another shot. A very constructive comment by Joshua Flanagan, who also had some doubts on connectionpooling led me to starting from scratch. I completely reset the server and ran the same tests again. All problems are gone..................
Yes I've been chasing ghosts in a rat hole. Spoiled my weekend. The framework's connection pooling does live up to its promises. As long as the server is OK. You do have a license to spill .. And now I need a drink.