Query plans produced from an ad hoc Transact-SQL query, including auto-parameterized queries. SQL Server stores such query plans in the plan cache for later reuse, if an identical Transact-SQL statement is later executed.
A SQL Server Agent object that performs an action when a condition is satisfied. Categorized as either Event Alerts or Performance Alerts. The action performed can be to send an e-mail, pager or Net Send message, or to run an SQL Agent job.
A SQL Server configuration parameter that determines if system tables can be modified using standard INSERT, UPDATE, DELETE statements. A value of 0 means updates are not allowed, and 1 indicates they are allowed.