You deploy a SQL Server instance named SQLProd that uses SQL Server 2014. You need to recommend a solution to monitor the transactions that are running currently against SQLProd. The solution must minimize the amount of custom code required. What should you recommend?

A. Statistics
B. A dynamic management view
C. A trigger
D. User-defined views

  Discussion forum


Leave an answer