單項(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 has databases for a finance application and a manufacturing application. You want to put some limitation on the maximum CPU query time allowed by the applications, so you configure the Resource Governor to achieve this. But you notice that certain reports do not execute successfully any longer on the manufacturing application. You have to allow the manufacturing application to consume more CPU time, so you have to change the Resource Governor configuration.
Which Resource Governor component should you configure?（）

A.The workload group which is used by default
B.The workload group which is used by the finance application
C.The classifier function which identifies the finance application
D.The workload group which is used by the manufacturing application

你可能感興趣的試題

單項(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 which contains a database. Now your company CIO assigns a task to you. You have to check the performance of the SQL Server 2008 instance. You have to find out which common language runtime (CLR) queries takes the longest-running time.
So in the options below, which dynamic management view should you choose to use?（）

A.sys.dm_os_wait_stats
B.sys.dm_exec_requests
C.sys.dm_exec_sessions
D.sys.dm_exec_query_stats

單項(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 which contains a database. According to the company requirement， you have to move the application from Microsoft SQL Server 2000 to Microsoft SQL Server 2008. You have to monitor the SQL Server instance to record the use of features.
These features will be discontinued. What should you do？（）

A.The SQL Server 2008 Upgrade Advisor should be used.
B.The SQL Server Profiler which captures the SQL:BatchCompleted and Exception event classes should be used.
C.A SQL server-side trace that captures the Deprecation Announcement and Deprecation Final Support event classes should be used
D.A SQL server-side trace that captures the SQL:BatchCompleted and Exception event classes should be used.

99色精品-9色在线-99色在线-99色视频 国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精

你可能感興趣的試題

99色精品-9色在线-99色在线-99色视频国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精