试题详情
单项选择题 You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. The instance contains a database named DB1. An application which is continuously connected uses DB1. The application extensively uses the INSERT command and triggers the population of multiple tables. Now you notice that the application has a poor performance. You doubt that this problem has something to do with blocking. You have to monitor the state of the instance at regular intervals while not affecting the application performance further.  Which tool should you use? （） 

A、You should use Dynamic Management Views 

B、You should use SQL Server Resource Governor 

C、You should use SQL Server Profiler 

D、You should use Windows System Monitor

  • A

  • 关注下方微信公众号，在线模考后查看

热门试题