You are a database administrator for a company that has an on-premises Microsoft SQL Server environment and Microsoft Azure SQL Database instances. The environment hosts several customer databases, and each customer uses a dedicated instance.

You are a database administrator for a company that has an on-premises Microsoft SQL Server environment and Microsoft Azure SQL Database instances. The environment hosts several customer databases, and each customer uses a dedicated instance.

The environments that you manage are shown in the following table.

You need to configure monitoring for Tailspin Toys.

In the table below, identify the monitoring tool that you must use for each activity.

NOTE: Make only one selection in each column.

Hot Area:

View Answer

Answer:

Explanation:

Monitoring from application: Transact-SQL

Transact-SQL can be used to monitor a customized application.

Trend analysis: System Monitor

System Monitor can provide trend analysis.

Tailspin Toys has a custom application that accesses a hosted database named TSpinDB. The application will monitor TSpinDB and capture information over time about which database objects are accessed and how frequently they are accessed.

References: https://docs.microsoft.com/en-us/sql/relational-databases/performance/performance-monitoringand-tuning-tools