• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 362
  • Last Modified:

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.
0
anushahanna
Asked:
anushahanna
  • 3
  • 2
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
system scan ???
0
 
anushahannaAuthor Commented:
dm_db_index_usage_stats.system_scans
0
 
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
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 
Raja Jegan RSQL 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
 
anushahannaAuthor Commented:
Thanks. It is probably the Auto Update Statistics.
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Welcome..
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now