Monitoring SQL  «Prev  Next»

Lesson 12

SQL and SQL-EM Conclusion

This module discussed how to monitor SQL Server using SQL and SQL-EM. Some of the things you learned include how to:
  1. Monitor SQL Server connections
  2. Use SQL-EM to montior connections
  3. Monitor SQL Server locks
  4. Use SQL-EM to monitor locks
  5. Monitor overall system performance
  6. Monitor SQL Server with database consistency checker
  7. Use dbcc buffer to monitor the data cache
  8. Use dbcc to monitor overall performance
  9. Monitor SQL Server with trace flags
  10. Monitor SQL Server with built-in functions

SQL-Server 2019

Glossary Terms

The following terms were introduced to you in this module:
  1. Connection: A person or application that has logged onto SQL Server.
  2. DBCC: Database consistency checker - a set of utilities for verify a database and performing various system administrator tasks.
  3. Deadlock: When two connections each hold locks on resources that the other connection wants.
  4. Least recently used (LRU): The in memory data page that has gone the longest time without being accessed.
  5. Lock: A SQL Server mechanism use to ensure transaction isolation levels.
  6. Most recently used (MRU): The in memory data page that was the last data page to be accessed.
  7. Procedure cache: The amount of memory that SQL Server reserves for storing stored procedures.
  8. Scalar functions: A function that returns a single value.
  9. System stored procedure: A procedure stored in the master database which begins with sp_ that is used to perform system functions.
  10. 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.

Sql-em - Exercise

Click the Exercise link below to see how well you've mastered the concepts in this module.
Sql-em - Exercise