The following terms were introduced to you in this module:
- Connection: A person or application that has logged onto SQL Server.
- DBCC: Database consistency checker - a set of utilities for verify a database and performing various system administrator tasks.
- Deadlock: When two connections each hold locks on resources that the other connection wants.
- Least recently used (LRU): The in memory data page that has gone the longest time without being accessed.
- Lock: A SQL Server mechanism use to ensure transaction isolation levels.
- Most recently used (MRU): The in memory data page that was the last data page to be accessed.
- Procedure cache: The amount of memory that SQL Server reserves for storing stored procedures.
- Scalar functions: A function that returns a single value.
- System stored procedure: A procedure stored in the master database which begins with sp_ that is used to perform system functions.
- trace flags: A SQL Server dbcc option that changes the behavior of SQL Server.
The next module will cover how to monitor and maintain databases.