system scan

What is a system scan of an index? Why does the system scan a index when it is not used?

Thanks for any insights.
LVL 6
anushahannaAsked:
Who is Participating?
 
Raja Jegan RConnect With a Mentor SQL Server DBA & ArchitectCommented:
>> Why would system tables like to scan an index that is not being used by the user?

Kindly confirm whether a DB Reindex or Reorganize scripts are running in the background..
Because that would be done by your system to keep the index statistics up to date without an INSERT or UPDATE or DELETE statements..

Even If you have Auto Update Statistics Set to ON, this might occur..
Because Auto Update Statistics will be performed by Server in times when ther is less load on the server.
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
system scan ???
0
 
anushahannaAuthor Commented:
dm_db_index_usage_stats.system_scans
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
anushahannaAuthor Commented:

The user seeks/scans/lookups/updates are all 0, but system scan is 2, for this index. Why would system tables like to scan an index that is not being used by the user?
0
 
anushahannaAuthor Commented:
Thanks. It is probably the Auto Update Statistics.
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Welcome..
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.