單項(xiàng)選擇題

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

你可能感興趣的試題

單項(xiàng)選擇題

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. A SQL Server Agent job is failing. You find that the job history information is incomplete and seems to be truncated after you review it. All information produced by a job must be available for viewing.
So what action should you perform to achieve this goal? （）

A.You should enable notifications to the Windows application event log when the job completes.
B.You should enable write OEM file
C.You should enable all job steps, making them send the output to a file
D.You should include execution trace messages in the SQL Agent Error log

單項(xiàng)選擇題

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. There is a database named DB1 in the instance. TheDB1 database includes spatial data types. On DB1 databse, you have to perform a database consistency check to include the spatial indexes. Besides this, you must make sure that you can reduce the effect on the database concurrency to the least.
So which Transact-SQL statement should you run? （）

A.DBCC CHECKCATALOG (DB1);
B.DBCC CHECKALLOC (DB1) WITH TABLOCK;
C.DBCC CHECKDB (DB1) WITH TABLOCK, PHYSICAL_ONLY;
D.DBCC CHECKDB (DB1) WITH EXTENDED_LOGICAL_CHECKS;

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美 国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

你可能感興趣的試題

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线