The Foglight database stores all system, application, and performance data. Over time, it becomes an invaluable source of historical information for planning future system capacity requirements and for doing point-in-time analysis. The information in the database can also be made available for use in external systems.
When a row in a table that does not have a clustering index is updated, and if the modified row no longer fits on the old page, then SQL Server moves the row to a new page and leaves a forwarding pointer in the old page. The forwarding pointer saves the need to modify the non-clustered indexes to make them reflect the row’s new location; however, extra I/O resources are now required for subsequent retrieval of this row using non-clustered indexes.
© ALL RIGHTS RESERVED. Feedback Conditions d’utilisation Confidentialité Cookie Preference Center