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

Object Execution StatisticsReport Expand / Collapse
Author
Message
Posted Tuesday, February 10, 2009 3:42 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, October 14, 2014 8:44 AM
Points: 330, Visits: 974
Hi,

IN SQL Server 2005, we have Object Execution Statistics Report. I would like to know from where does the information gets fetched or is there any table in which the information of the reports gets fetched.


With Regards
Dakshina Murthy
Post #653536
Posted Tuesday, February 10, 2009 4:27 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, June 20, 2013 2:04 AM
Points: 222, Visits: 331
The best thing that you can do is to run profiler at the back end for these kind of requirements while you check that report. This can tell you from where the report is getting data from
.


Sriram

Post #653558
Posted Tuesday, February 10, 2009 4:37 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Thursday, April 24, 2014 3:59 AM
Points: 106, Visits: 328
i think sql server collects the data at the back and store them in resource database (a hidden database).
after that, we can pull the data via DMVs.
this is what i guess. :)
Post #653562
Posted Tuesday, February 10, 2009 4:42 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, October 14, 2014 8:44 AM
Points: 330, Visits: 974
Thanks for the reply, any idea how to access resource DB and from which table or where we can get the information of the statistics.


With Regards
Dakshina Murthy
Post #653565
Posted Tuesday, February 10, 2009 6:48 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, October 17, 2014 12:12 PM
Points: 2,049, Visits: 3,587
This post from Buck Woody explains the report and there is a link on there that refers to the fact that this is part of the plan cache. You will need to hit the DMV's to get this information. Not sure exactly what ones this is pulling from though. I would run the trace to see what DMV it is using. Post back here with what you find. I know I would be interested.

David

@SQLTentmaker
SQL Tentmaker
“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
Post #653650
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse