单选题You are investigating the performance of the server and see the following information: Events_waits_summary_global_by_event_name in the performance schema shows that the wait/synch/mutex/sql/LOCK_table_cache event is dominating other wait events. The table_open_cache_overflows status variable is 0. Which action should be taken to remove the performance bottleneck described here?（）AIncrease the value of table_definition_cacheBIncrease the value of table_open_cache_instancesCDecrease the value of table_open_cache_instancesDIncrease the value of table_open_cacheEDecrease the value of table_definition_cacheFDecrease the value of table_open_cache
单选题
You are investigating the performance of the server and see the following information: Events_waits_summary_global_by_event_name in the performance schema shows that the wait/synch/mutex/sql/LOCK_table_cache event is dominating other wait events. The table_open_cache_overflows status variable is 0. Which action should be taken to remove the performance bottleneck described here?（）
A
Increase the value of table_definition_cache
B
Increase the value of table_open_cache_instances
C
Decrease the value of table_open_cache_instances
D
Increase the value of table_open_cache
E
Decrease the value of table_definition_cache
F
Decrease the value of table_open_cache
参考解析
解析：
暂无解析
相关考题：
You are investigating the performance of the server and see the following information: Events_waits_summary_global_by_event_name in the performance schema shows that the wait/synch/mutex/sql/LOCK_table_cache event is dominating other wait events. The table_open_cache_overflows status variable is 0.Which action should be taken to remove the performance bottleneck described here?（）A.Increase the value of table_definition_cacheB.Increase the value of table_open_cache_instancesC.Decrease the value of table_open_cache_instancesD.Increase the value of table_open_cacheE.Decrease the value of table_definition_cacheF.Decrease the value of table_open_cache
You notice a performance change in your production Oracle database and you want to know which change has made this performance difference.You generate the Compare Period Automatic Database Diagnostic Monitor (ADDM) report to further investigation.Which three findings would you get from the report?（）A. It detects any configuration change that caused a performance difference in both time periods.B. It identifies any workload change that caused a performance difference in both time periods.C. It detects the top wait events causing performance degradation.D. It shows the resource usage for CPU, memory, and I/O in both time periods.E. It shows the difference in the size of memory pools in both time periods.F. It gives information about statistics collection in both time periods.
Your database supports an online transaction processing (OLTP) application.The application is undergoing some major schema changes, such as addition of new indexes and materialized views.You want to check the impact of these changes on workload performance.What should you use to achieve this?（）A. Database replayB. SQL Tuning AdvisorC. SQL Access AdvisorD. SQL Performance AnalyzerE. Automatic Workload Repository compare reports
You have a server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2).Users report that it takes a long time to open shared files on Server1. Users do not report this performance problem when they open files on other servers.You notice the following performance statistics on Server1:You need to optimize the performance of Server1.What should you do?（）A. Add more ram.B. Upgrade the processor.C. Increase the size of the PageFile.D. Disable Data Execution Prevention (DEP).
You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. Now according to the company requirement, you are designing a consolidated repository of performance data. You must make sure that the four requirements below are met: the data collector is used to gather performance information; a single database stores performance information for all instances; performance information that is older than 15 days is deleted; reduce the administrative effort to manage performance to the least. So what action should you perform to achieve this goal? （） A、You should create a SQL Agent job process on each instance to store and delete performance data in a single database for all instances. B、You should configure a management data warehouse process on each instance, then use this process to store and delete performance data in a single database for all instances. C、You should configure an automated server-side trace process on each instance, then use this process to store and delete performance data in a single database for all instances. D、You should create and schedule a single Microsoft SQL Service Integration Services (SSIS) package process, then use this process to store and delete performance data in a single database for all instances.
Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance. What should you use to achieve this?（）A、Database replayB、SQL Tuning AdvisorC、SQL Access AdvisorD、SQL Performance AnalyzerE、Automatic Workload Repository compare reports
You are investigating the performance of the server and see the following information: Events_waits_summary_global_by_event_name in the performance schema shows that the wait/synch/mutex/sql/LOCK_table_cache event is dominating other wait events. The table_open_cache_overflows status variable is 0. Which action should be taken to remove the performance bottleneck described here?（）A、Increase the value of table_definition_cacheB、Increase the value of table_open_cache_instancesC、Decrease the value of table_open_cache_instancesD、Increase the value of table_open_cacheE、Decrease the value of table_definition_cacheF、Decrease the value of table_open_cache
When tuning Automatic PGA Memory Management， which of the following views will provide the information specified？（） A、 The V$PGA_TARGET_ADVICE view shows the predicted cache hit-ratio improvement if you increase PGA_AGGREGATE_TARGETB、 The V$PGA_TARGET_ADVICE view shows how the V$SQL_WORKAREA histogram will change if you change the value of PGA_AGGREGATE_TARGETC、 The V$PGA_TARGET_ADVICE_HISTOGRAM view shows how the V$SQL_WORKAREA_HISTOGRAM will change if you switch between Manual and Automatic PGA Memory ManagementD、 The V$PGA_TARGET_ADVICE view shows how performance will improve for the different work areas if you switch from Manual to Automatic PGA Memory Management
In what view are you likely to see the following output？（） SID SERIAL# EVENT SECONDS_IN_WAIT 121 269 RMAN backup recovery I/O 2 129 415 SQL*Net message from client 63 130 270 SQL*Net message from client A、 V$SESSION_EVENTB、 V$SESSIONC、 V$WAITSD、 V$WAITSTATE、 V$SYSSTAT
Your network consists of a single Active Directory domain. All servers run Windows Server 2008 R2.You have a server named Server1 that hosts shared documents. Users report extremely slow response times when they try to open the shared documents on Server1.You log on to Server1 and observe real-time data indicating that the processor is operating at 100 percent of capacity.You need to gather additional data to diagnose the cause of the problem. What should you do?（）A、In the Performance Monitor console, create a counter log to track processor usage.B、In Event Viewer, open and review the application log for Performance events.C、In Resource Monitor, use the Resource View to see the percentage of processor capacity used by each application.D、In Performance Monitor, create performance counter alert that will be triggered when processor usage exceeds 80 percent for more than five minutes on Server1.
Your network contains a server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2). You create a domain account named Admin1. You need to configure the security for Admin1 to meet the following requirements: Allow Admin1 to monitor events in the system event log and the application event logAllow Admin1 to create and view counter logs in Performance MonitorMinimize the user rights assigned to Admin1 To .which group should you add Admin1?（）A、Power Users.B、Administrators.C、Performance Log Users.D、Performance Monitor Users.
You are a database administrator for your company. The company runs a popular database-driven Web site against a SQL Server 2005 computer named SQL2. You need to ensure a quick response time and appropriate audit trail in the event that SQL2 experiences excessive traffic due to denial-of-service （DoS） attacks. Which two actions should you perform？（）A、Create a new performance alert to monitor the Current Bandwidth counter.B、Create a new performance alert to monitor the Bytes Total/sec counter.C、Configure the new performance alert to start a SQL Server Profiler trace.D、Configure the new performance alert to start a Network Monitor capture.
You are a systems administrator responsible for managing a Windows Server 2008 SMTP server.Recently， users have complained that a Web application running on the same server is experiencing performance problems at specific times of the day. You suspect that the problem might be related to loadplaced on the SMTP Server service. Which of the following methods should you use to monitor theperformance of an SMTP virtual server over time？（）A、The Current Sessions section of IIS 6.0 ManagerB、SMTP Server counters collected by Performance MonitorC、Windows Event Viewer： Application LogD、Windows Event Viewer： System Log
You are a professional level SQL Sever 2008 Database Administrator in an international corporation named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing and sustaining the database life cycle. In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization. A SQL Server 2008 infrastructure is managed by you. After a regular test, you find that performance degradation is experienced by an instance for the three reasons: Excessive CPU usage, Server processes paging and Deadlocks. A monitoring solution should be implemented to provide data, monitor and troubleshoot performance issues. And detailed deadlock information should be contained in the provided data. You should utilize the least amount of administrative effort to finish the task. Which tool will you utilize to finish the task?（） A、To finish the task, you should utilize Resource Governor. B、To finish the task, you should utilize Database Engine Tuning Advisor.C、To finish the task, you should utilize Extended Events. D、To finish the task, you should utilize Performance Monitor (SYSMON).
You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. More than a month ago， the SQL 2005 Server computer is deployed in operation. There are some query performance problems last week. Therefore， you perform an investigation on the locking contention. From the sys.dm_os_wait_stats dynamic management view （DMV）， you can see a high value in the max_wait_time_ms column. You want to check out whether this value is a factor which leads to the current performance problems. In addition， the impact on database users should e cut to the least. Which action should be performed to achieve the goal？（）A、To achieve the goal， the UPDATE STATISTICS command should be excuted.B、To achieve the goal， the SQL Server Service should be restarted.C、To achieve the goal， the SQL Server computer should be restarted.D、To achieve the goal， the statistics in the dynamic management view （DMV） should be reset.
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
You notice a performance change in your production Oracle database and you want to know which change has made this performance difference. You generate the Compare Period Automatic Database Diagnostic Monitor (ADDM) report to further investigation. Which three findings would you get from the report?（）A、It detects any configuration change that caused a performance difference in both time periods.B、It identifies any workload change that caused a performance difference in both time periods.C、It detects the top wait events causing performance degradation.D、It shows the resource usage for CPU, memory, and I/O in both time periods.E、It shows the difference in the size of memory pools in both time periods.F、It gives information about statistics collection in both time periods.
单选题In what view are you likely to see the following output？（） SID SERIAL# EVENT SECONDS_IN_WAIT 121 269 RMAN backup recovery I/O 2 129 415 SQL*Net message from client 63 130 270 SQL*Net message from clientA V$SESSION_EVENTB V$SESSIONC V$WAITSD V$WAITSTATE V$SYSSTAT
单选题You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. More than a month ago， the SQL 2005 Server computer is deployed in operation. There are some query performance problems last week. Therefore， you perform an investigation on the locking contention. From the sys.dm_os_wait_stats dynamic management view （DMV）， you can see a high value in the max_wait_time_ms column. You want to check out whether this value is a factor which leads to the current performance problems. In addition， the impact on database users should e cut to the least. Which action should be performed to achieve the goal？（）ATo achieve the goal， the UPDATE STATISTICS command should be excuted.BTo achieve the goal， the SQL Server Service should be restarted.CTo achieve the goal， the SQL Server computer should be restarted.DTo achieve the goal， the statistics in the dynamic management view （DMV） should be reset.
单选题You are a professional level SQL Sever 2008 Database Administrator in an international corporation named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing and sustaining the database life cycle. In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization. A SQL Server 2008 infrastructure is managed by you. After a regular test, you find that performance degradation is experienced by an instance for the three reasons: Excessive CPU usage, Server processes paging and Deadlocks. A monitoring solution should be implemented to provide data, monitor and troubleshoot performance issues. And detailed deadlock information should be contained in the provided data. You should utilize the least amount of administrative effort to finish the task. Which tool will you utilize to finish the task?（）ATo finish the task, you should utilize Resource Governor. BTo finish the task, you should utilize Database Engine Tuning Advisor.CTo finish the task, you should utilize Extended Events. DTo finish the task, you should utilize Performance Monitor (SYSMON).
单选题You are a network administrator for your company. The network contains four Windows Server 2003 computers configured as a four-node server cluster. Each cluster node is the preferred owner of a clustered instance of Microsoft SQL Server 2000， and each cluster node is configured as a possible owner of all other instances of SQL Server. All nodes have identically configured hardware. All four nodes operate at a sustained 70 percent CPU average. You add a server that has identically configured hardware to the cluster as a fifth node. You want each SQL Server instance to continue operating at the same level of performance in the event of a single node failure. What should you do？ （）A Clear the Affect group check box in the cluster resource properties for each SQL Server instance.B Configure the fifth node as the only possible owner other than the existing preferred owner of the cluster resources that are associated with each SQL Server instance.C Configure the fifth node as the preferred owner of each cluster group that contains an SQL Server instance.D Enable failback on each group that contains an SQL Server instance.
单选题When tuning Automatic PGA Memory Management， which of the following views will provide the information specified？（）A The V$PGA_TARGET_ADVICE view shows the predicted cache hit-ratio improvement if you increase PGA_AGGREGATE_TARGETB The V$PGA_TARGET_ADVICE view shows how the V$SQL_WORKAREA histogram will change if you change the value of PGA_AGGREGATE_TARGETC The V$PGA_TARGET_ADVICE_HISTOGRAM view shows how the V$SQL_WORKAREA_HISTOGRAM will change if you switch between Manual and Automatic PGA Memory ManagementD The V$PGA_TARGET_ADVICE view shows how performance will improve for the different work areas if you switch from Manual to Automatic PGA Memory Management
单选题You are a systems administrator responsible for managing a Windows Server 2008 SMTP server.Recently， users have complained that a Web application running on the same server is experiencing performance problems at specific times of the day. You suspect that the problem might be related to loadplaced on the SMTP Server service. Which of the following methods should you use to monitor theperformance of an SMTP virtual server over time？（）AThe Current Sessions section of IIS 6.0 ManagerBSMTP Server counters collected by Performance MonitorCWindows Event Viewer： Application LogDWindows Event Viewer： System Log
单选题Your network consists of a single Active Directory domain. All servers run Windows Server 2008 R2.You have a server named Server1 that hosts shared documents. Users report extremely slow response times when they try to open the shared documents on Server1.You log on to Server1 and observe real-time data indicating that the processor is operating at 100 percent of capacity.You need to gather additional data to diagnose the cause of the problem.What should you do？（）AIn the Performance Monitor console, create a counter log to track processor usage.BIn Event Viewer, open and review the application log for Performance events.CIn Resource Monitor, use the Resource View to see the percentage of processor capacity used by each application.DIn Performance Monitor, create performance counter alert alert that will be triggered when processor usage exceeds 80 percent for more than five minutes on Server1.
单选题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?（）Asys.dm_os_wait_stats Bsys.dm_exec_requests Csys.dm_exec_sessions Dsys.dm_exec_query_stats
单选题You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. Now according to the company requirement, you are designing a consolidated repository of performance data. You must make sure that the four requirements below are met: the data collector is used to gather performance information; a single database stores performance information for all instances; performance information that is older than 15 days is deleted; reduce the administrative effort to manage performance to the least. So what action should you perform to achieve this goal? （）AYou should create a SQL Agent job process on each instance to store and delete performance data in a single database for all instances. BYou should configure a management data warehouse process on each instance, then use this process to store and delete performance data in a single database for all instances. CYou should configure an automated server-side trace process on each instance, then use this process to store and delete performance data in a single database for all instances. DYou should create and schedule a single Microsoft SQL Service Integration Services (SSIS) package process, then use this process to store and delete performance data in a single database for all instances.
单选题Your company has a network that has 100 servers. A server named Server1 is configured as a file server. Server1 is connected to a SAN and has 15 logical drives.You want to automatically run a data archiving script if the free space on any of the logical drives is below 30 percent.You need to automate the script execution.You create a new Data Collector Set. What should you do next？（）AAdd the Event trace data collector.BAdd the Performance counter alert.CAdd the Performance counter data collector.DAdd the System configuration information data collector.