I am using SQL Server 2005. I have very large value for Full Scans / Sec. Though I am newbie in performance tuning, I want to find out the following values.
Can somebody tell me how to find the following values using SYS.DM_DB_INDEX_USAGE_STATS or any other DMV? A query that reurns these values will be exaclty what I am looking for.
1. The table that undergone Full Table Scan
2. The query that caused the table to undergo Full Table Scan
3. Time of Scan
4. Time taken for completing the scan
View Complete Post