Hi experts! To find the unused index, i use to check for the columns User_Seeks = 0 and User_scans = 0 and User_lookups = 0 of "
sys.dm db index usage stats" DMV, but here i can see system_seek, system_scan, System_Lookups column also. My question is, does i need to care system_seek, system_scan, System_Lookups columns also? what does system_seek, system_scan, System_Lookups columns mean and its importance?
What WilliamD said. Just remember that this DMO is reset when the server is started, the database is detached, or when the database is closed. So before you start dropping indexes based on the information provided, be sure it's covering an adequate period of time so you don't drop indexes that are going to be needed in overnight or weekly reports or something along those lines.