Comparing Performance monitor counters for SQL.UserConnections Vs. SSRS.ActiveConnections
-
I'm trying to debug whether or not a SSRS app is leaving open sql connections. I wrote a test app that uses a custom SSRS reporting object (written in VB.net) that calls reports in a loop. Each time the reporting object is destroyed and recreated. The server is 2008 R2 and the SQL server is 2008 R2. I have Performance Monitor open on the server with the following counters added in: ReportServer:Service - Active Connections SQLServer:General Statistics - User Connections SSRS.ActiveConnections is displaying 97 current connections. SQL.UserConnections is displaying 38 current connections. If I open Management Studio and use the Activity Monitor, selecting all databases - there are exactly 38 connections. If I run sp_who2 and remove the lines that are for the master DB and sa account, there are again 38 connections (prior 64) I'm very confused on the different #s being reported in the counters. Can anyone shed light into this? Is the ReportServer:Service - Active Connections actual DB connections or connections to the service? Should the SQL.UserConnections include SSRS report connections?
"There's no such thing as a stupid question, only stupid people." - Mr. Garrison