The SQL Server uses two types of cache storage: buffer cache, used for storing recently used database pages, and plan cache, which stores execution plans. For details, see glossary definitions of and .
The process by which Foglight for SQL Server determines the maximum and minimum values for every dataflow on the home page, by observing data moving through the database system. This information helps Foglight for SQL Server display the dataflows correctly.
A measure of the number of unique values within a column or index. The higher the cardinality of an index, the fewer the number of rows that are returned by an exact lookup of a key value (and hence the more useful the index).
© ALL RIGHTS RESERVED. Feedback Conditions d’utilisation Confidentialité Cookie Preference Center