Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server 2012 Activity Monitor Expand / Collapse
Author
Message
Posted Thursday, September 5, 2013 12:23 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, December 12, 2014 5:29 AM
Points: 121, Visits: 392
I opened SQL Server 2012 Activity Monitor and was trying to understand the data it was displaying. I saw a statement under "Recent Expensive Queries" and I clicked the dropdown for databases. I then opened the "Processes" section in Activity Monitor and clicked the dropdown for "Database". The database that was using the query in the "Recent Expensive Queries" section was not in the list. How is it possible for the database to be using a query, yet not in the database list in the dropdown under "Processes"?

Thank you in advance,

Charlie
Post #1491907
Posted Thursday, September 5, 2013 1:12 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 6:49 AM
Points: 227, Visits: 1,784
The name is self explanatory.

"This pane shows information about the most expensive queries that have been run on the instance over the last 30 seconds."
http://technet.microsoft.com/en-us/library/cc879320%28v=sql.105%29.aspx
Post #1491924
Posted Thursday, September 5, 2013 1:24 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, December 12, 2014 5:29 AM
Points: 121, Visits: 392
Thank you for the explanation.

Charlie
Post #1491930
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse