DRAG DROP -
You have a SQL Server 2014 database.
You plan to create a stored procedure that will retrieve the following information:
✑ The XML content of the query plans that is stored in memory
✑ The number of times each query plan is used
You need to identify which dynamic management objects must be used to retrieve the required information for the stored procedure.
Which dynamic management objects should you identify?
To answer, drag the appropriate dynamic management object to the correct requirement in the answer area.
Select and Place:
Drag Drop You H 1 (33.29 KiB) Viewed 98 times
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!