<div>
SQL doesn't capture that info. &nbsp;You would need to set up something to capture that info if you need it.
</div>


SQL doesn't capture that info.  You would need to set up something to capture that info if you need it.

<div>
No way to have that information unless you create an audit system and store all captured data in a database for later use.
</div>


No way to have that information unless you create an audit system and store all captured data in a database for later use.

<div>
<div class="content wysiwyg-content">
DMVs have tons of great info but what I am looking for is simple -- how frequently is a table, query, proc touched or run? &nbsp;When was the last time, first time, etc. &nbsp;What DMV &nbsp;(or any other tool) can show me this? &nbsp;Seeing last time Exec plan was run is not accurate, because exec &nbsp;plan can be refreshed.
</div>
</div>


DMVs have tons of great info but what I am looking for is simple -- how frequently is a table, query, proc touched or run?  When was the last time, first time, etc.  What DMV  (or any other tool) can show me this?  Seeing last time Exec plan was run is not accurate, because exec  plan can be refreshed.

Sql Server DMV   --- log of object use?

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.