SQL Server Management Studio Reports: Why no open transactions?
- by Sleepless
On a server with several hundred user connections, when I open the SQL Server 2008 SP1 Management Studio report "Database - User Statistics", the result page shows the following results:
Login Name: appUser
Active Sessions: 243
Active Connections: 243
Open Transactions: 374
Still, when I open the report "Database - All Transactions" on the same DB, it doesn't show any connections ("Currently, there are no transactions running for [Database Name] Database"). What gives? Is this a bug in Management Studio? This is not the only report where this kind of behavious happens...
Thanks all!