SQL Server Management Studio Reports: Why no open transactions?

Posted by Sleepless on Server Fault See other posts from Server Fault or by Sleepless
Published on 2010-03-23T18:32:29Z Indexed on 2010/03/23 18:33 UTC
Read the original article Hit count: 363

Filed under:

sqlservermanagementstudio

|

database-performance

|

transactions

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!

© Server Fault or respective owner

Related posts about sqlservermanagementstudio

Set a login with username/password for SQL Server 2008 Express

as seen on Server Fault - Search for 'Server Fault'
I would like to set a password and username for connecting to a server with SQL Management Studio 2008. I set up SQL Server 2008 Express on a customer's computer to host a DB used by an Access 2007 app. The customer should not be able to access the DB or connect with SQL Management Studio. How do… >>> More
SQL Server 2005 Reporting Services - Configuration Manager & Management Studio Problems

as seen on Server Fault - Search for 'Server Fault'
When I open Reporting Services Configuration Manager on my server, an error message appears that says: Reporting Services Configuration Manager An unknown error has occurred in the WMI Provider. Error Code 800706B3 This error appears before I can even attempt to connect to an SSRS instance. In… >>> More
Can't remotely connect through SQL Server Management Studio

as seen on Server Fault - Search for 'Server Fault'
I have setup a SQL Server 2008 Express instance on a dedicated Windows 2008 Server hosted by 1and1.com. I cannot connect remotely to the server through management studio. I have taken the following steps below and am beyond any further ideas. I have researched the site and cannot figure anything else… >>> More
Don't see job schedule added by sp_add_jobschedule in SQL Mgmt UI

as seen on Server Fault - Search for 'Server Fault'
I'm running a script like below on a SQL Server box and, even though it finishes correctly, then when, on SQL Mgmt UI, I right click on that job's properties, go to Schedules, I cannot see the schedule just added... what am I missing? (I'm using the right job_name param, etc) thanks! BEGIN TRY BEGIN… >>> More
attach / detach mssql 2008 sql server manager [SOLVED]

as seen on Server Fault - Search for 'Server Fault'
An external consult wrote a guide on how to copy a database. Step two was detach the database using Sql Server Manager. After the detach the database was not visible in the SQL Server Manager... Not much to do but write a mail to the service provider asking to have the database attached again. The… >>> More

Related posts about database-performance

A Perspective on Database Performance Tuning

as seen on SQL Server Central - Search for 'SQL Server Central'
Fundamentally, database performance tuning is done for two basic reasons, to reduce response time and to reduce resource usage, both of which can apply for any given situation. Julian Stuhler looks at database performance tuning, and why it remains one of the most important topics for any DBA, developer… >>> More
A Perspective on Database Performance Tuning

as seen on Internet.com - Search for 'Internet.com'
Fundamentally, database performance tuning is done for two basic reasons, to reduce response time and to reduce resource usage, both of which can apply for any given situation. Julian Stuhler looks at database performance tuning, and why it remains one of the most important topics for any DBA, developer… >>> More
Will Check Constraints Improve Database Performance?

as seen on SQL Server Performance - Search for 'SQL Server Performance'
[Read Full Article] >>> More
Database Performance Across 3 NetApp FAS2050

as seen on Server Fault - Search for 'Server Fault'
I recently inherited a SQL Server 2005 box that has LUNs mounted on it from three different NetApp FAS2050 filers. The reason there are three is because the first two filers are out of space and our databases continually need more of it. What kind of performance impact (if any) does this setup have… >>> More
Database performance benchmark

as seen on Stack Overflow - Search for 'Stack Overflow'
Any good articles out there comparing Oracle vs SQL Server vs MySql in terms of performance? I'd like to know things like: INSERT performance SELECT performance Scalability under heavy load Based on some real examples in order to gain a better understanding about the different RDBMS. >>> More