Sample Header Ad - 728x90

Number of full table scans

4 votes
1 answer
2458 views
I would like to see information on how many times has a table been fully scanned. I was hoping for something like sys.dm_db_index_usage_stats but for table scans. There is a method described at the blog [keepitsimleandfast](http://www.keepitsimpleandfast.com/2011/11/how-to-find-table-scans-in-your.html) , but I would rather get all scans since server started. What I am looking for is also similiar to pg_stat_all_tables.seq_scan in PostgreSQL.
Asked by dreptak (153 rep)
Jun 22, 2018, 09:00 AM
Last activity: Jun 22, 2018, 03:47 PM