PdfPrep.com

How should you complete the Transact-SQL statement?

HOTSPOT

You manage a Microsoft SQL Server environment with a database named obi. You notice that queries take longer to complete than they did a year ago. You increase the file size for the database named tempdb, but it does not resolve the problem.

You need to capture runtime statistics for all querie s.

How should you complete the Transact-SQL statement? To answer, configure the appropriate Transact-SQL segments in the answer area. NOTE: Each correct selection is worth one point.

Answer:

Explanation:

Use the ALTER DATABASE statement to enable the query store. For example:

ALTER DATABASE AdventureWorks2012 SET QUERY_STORE = ON;

The SQL Server Query Store feature provides you with insight on query plan choice and performance. It simplifies performance troubleshooting by helping you quickly find performance differences caused by query plan changes. Query Store automatically captures a history of queries, plans, and runtime statistics, and retains these for your review.

References: https://docs.microsoft.com/en-us/sql/relational-databases/performance/monitoring­performance-by-using-the-query-store

Exit mobile version