The following terms were introduced to you in this module:
- Extent: SQL Server allocation unit. An extent is 8 data pages.
- Fragmentation: A condition that occurs when data is not stored consecutively.
- Leaf page: The lowest level of an index.
- Single user mode: A database that is configured to allow only one user to access it.
- Statistics: Track the data distribution.
The next module will cover how to use SQL Server Profiler to monitor SQL Server.
Before you continue, click the Exercise link below to check your understanding of monitoring and maintaining databases.
Develop Database Maintenance Plan - Exercise