Looking to select last time tables were queried

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » T-SQL (SS2K8) » Looking to select last time tables were...

14 posts, Page 2 of 2

««1 2

Looking to select last time tables were queried

Rate Topic

Display Mode

Topic Options

Author

Message

GilaMonster

Posted Monday, February 25, 2013 8:09 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 4:11 PM
Points: 37,741, Visits: 30,020

Sean Lange (2/25/2013)

That only shows index usage. If your queries are not sargable or you have a heap your results may not be exactly what you are looking for.

A scan is a use of an index, and the index usage DMV does include heaps and clusters. SELECT * from HeapTable will put an entry in that DMV.

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1423630

Jason-299789

Posted Monday, February 25, 2013 8:17 AM

SSC Eights!

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 1:30 AM
Points: 803, Visits: 2,124

Gail,

wouldn't the Database level Audit be enough, as this seems to handle events for Select, Insert, Update, and Delete Actions? Or would the overhead be significant?

_________________________________________________________________________
SSC Guide to Posting and Best Practices

Post #1423635

Sean Lange

Posted Monday, February 25, 2013 8:36 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 1:17 PM
Points: 8,641, Visits: 8,273

GilaMonster (2/25/2013)

Sean Lange (2/25/2013)

That only shows index usage. If your queries are not sargable or you have a heap your results may not be exactly what you are looking for.

A scan is a use of an index, and the index usage DMV does include heaps and clusters. SELECT * from HeapTable will put an entry in that DMV.

I didn't realize that heaps would end up in there. Thanks for the correction Gail.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

Post #1423637

GilaMonster

Posted Monday, February 25, 2013 8:41 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 4:11 PM
Points: 37,741, Visits: 30,020

Jason-299789 (2/25/2013)

wouldn't the Database level Audit be enough, as this seems to handle events for Select, Insert, Update, and Delete Actions?

That should work too, might have to aggregate, I don't know offhand how the audit shows results.

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1423642

« Prev Topic | Next Topic »

14 posts, Page 2 of 2

««1 2

Permissions