Matching
Matching :
Premises:
a message generated automatically in response to a system event or when a performance condition is met
a mechanism that enables certain server-level or database-level events to be captured and written to a target
rules defined by placing a threshold on the value of a specific performance counter monitored by SQL Server Agent
contains system events as well as certain user-defined events for the SQL Server instance
a numerical indicator that describes the type of SQL Server error; can be used to specify whether an alert should be generated
a dynamic management view or function that operates at the level of the SQL Server instance
A dynamic management view or function that allows information in an individual user database to be retrieved
a feature of the Management Data Warehouse on a SQL Server instance that is used to capture several different types of data
the process of using a baseline to compare against current system performance
an alias for an individual or group of people with their email or pager information
Responses:
SQL Server Audit
severity level
database-scoped
operator
data collector
benchmarking
alert
performance conditions
SQL Server log
server-scoped
Correct Answer:
Premises:
Responses:
a message generated automatically in response to a system event or when a performance condition is met
a mechanism that enables certain server-level or database-level events to be captured and written to a target
rules defined by placing a threshold on the value of a specific performance counter monitored by SQL Server Agent
contains system events as well as certain user-defined events for the SQL Server instance
a numerical indicator that describes the type of SQL Server error; can be used to specify whether an alert should be generated
a dynamic management view or function that operates at the level of the SQL Server instance
A dynamic management view or function that allows information in an individual user database to be retrieved
a feature of the Management Data Warehouse on a SQL Server instance that is used to capture several different types of data
the process of using a baseline to compare against current system performance
an alias for an individual or group of people with their email or pager information
Premises:
a message generated automatically in response to a system event or when a performance condition is met
a mechanism that enables certain server-level or database-level events to be captured and written to a target
rules defined by placing a threshold on the value of a specific performance counter monitored by SQL Server Agent
contains system events as well as certain user-defined events for the SQL Server instance
a numerical indicator that describes the type of SQL Server error; can be used to specify whether an alert should be generated
a dynamic management view or function that operates at the level of the SQL Server instance
A dynamic management view or function that allows information in an individual user database to be retrieved
a feature of the Management Data Warehouse on a SQL Server instance that is used to capture several different types of data
the process of using a baseline to compare against current system performance
an alias for an individual or group of people with their email or pager information
Responses:
Related Questions
Q18: What tool do you use to record
Q19: Ideally, database administrators will monitor SQL Server
Q20: What are dynamic management views and dynamic
Q21: It is always preferable to quantitatively measure
Q22: Which range of SQL Server error message
Q24: When is the ideal time to measure
Q25: What is the first priority of a
Q26: For which type of event are notifications
Q27: A data collector set is a collection
Q28: What permissions must a user have in