How to measure connection pooling SQLOLE
Our web app has been having some problems with ” [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.” error at random times. The connection string is fine, the app runs without any dramas, but at random times it will display this error message. After consultation with other people we think that the connection pooling may be failing on some areas of our app. I wasn’t really sure how to measure this in a test environment, so after some research I found out that you can use perfmon to do this.
Using perfmon to measure connection pools
Start > run > perfmon
Add the counter for SQL Server: General Statistics > Logins/sec
If this stays moderately low, at about 1 or 0 it should be fine, which was consistent with a majority of the different parts of our system until we ran a report. The screen shot shows logging in which was next to nothing in the graph, the large spike was running 1 report.
connection pools in perfmon
And as you can see my computer name is deathstar….orsm! The next step is to find out why the connection is not pooling correctly in our reporting engine…
Leave a Reply