Identify a performance impact when using the Performance Sch

题目
单选题
Identify a performance impact when using the Performance Schema.()
A

There is no impact on performance

B

The overhead depends on the settings of the Performance Schema

C

There is an overhead for querying the Performance Schema but not for having it enabled

D

There is a constant overhead regardless of settings and workload

参考答案和解析
正确答案: A
解析: 暂无解析
如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

Consider the events_% tables in performance Schema.Which two methods will clear or reset the collected events in the tables?()

A.Using DELETE statements, for example, DELETE FROM performance_schema.events_watis_current

B.Using the statement RESET PERFORMANCE CACHE

C.Using the statement FLUSH PERFORMANCE CACHE

D.Using TRUNCATE statements, for example, TRUNATE TABLE performance_schema.events_waits_current

E.Disabling and re-enabling all instruments

F.Restarting Mysql


参考答案:D, F

第2题:

You are the administrator of a Windows Server 2003 computer named Testking1.An application on Testking1 gradually uses more and more memory until it causesTestking1 to stop responding. If you restart the application before it uses theavailable memory, there is no interruption of user services.You need to configure Testking1 to notify you when it encounters a low-memorycondition.What should you do?()

A. Using Task Scheduler, schedule a repeating task that runs the tracert command.

B. Using Performance Logs and Alerts, configure an alert for the appropriate performance object.

C. Using System Monitor, configure the appropriate performance object to display.

D. Using Startup and Recovery Settings, configure Testking1 to send an Administrative Alert.


参考答案:B

第3题:

(ii) Briefly discuss THREE disadvantages of using EVA? in the measurement of financial performance.

(3 marks)


正确答案:
(ii) Disadvantages of an EVA approach to the measurement of financial performance include:
(i) The calculation of EVA may be complicated due to the number of adjustments required.
(ii) It is difficult to use EVA for inter-firm and inter-divisional comparisons because it is not a ratio measure.
(iii) Economic depreciation is difficult to estimate and conflicts with generally accepted accounting principles.
Note: Other relevant discussion would be acceptable.

第4题:

A customer has an x445 and uses the internal LSI adapter to manage two 146GB drives in the chassis.  The customer is noticing performance issues when deploying a database with significant write activity on the internal drives.  Should they consider using a ServeRAID-6M with 256MB of cache instead, and why or why not?()

  • A、Yes, the internal LSI SCSI adapter has no write cache.
  • B、Yes, the internal LSI SCSI adapter is unreliable.
  • C、No, the downtime to install the card and reformat the drives would be cost prohibitive.
  • D、No, there will be no performance benefit, because drive performance is the bottleneck.

正确答案:A

第5题:

Which three statements about performance analysis by SQL Performance Analyzer are true? ()

  • A、It detects changes in SQL execution plans.
  • B、It produces results that can be used to create the SQL plan baseline.
  • C、The importance of SQL statements is based on the size of the objects accessed.
  • D、It generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.
  • E、It shows only the overall impact on workload and not the net SQL impact on workload.

正确答案:A,B,D

第6题:

You need to identify if malware is causing performance issues on your computer.What should you do?()

A.A

B.B

C.C

D.D


参考答案:A

第7题:

You have a server that runs Windows Server 2003 Service Pack 2 (SP2). The server has one hard disk that contains one volume.You need to receive a notification when the volume has less than 15 percent free disk space.What should you do? ()

A. Configure a Trace Log by using the File details system provider.

B. Configure a Trace Log by using the Disk input/output system provider.

C. Configure an Alert by using a counter from the Logical Disk performance object.

D. Configure an Alert by using a counter from the Physical Disk performance object.


参考答案:C

第8题:

Certkiller.com is currently using a performance counter named HitCounter.You are required to increment each time a user accesses the UI classes within the application.To do this, you start by creating performance counters using the following code:GRAFIK - wird nicht für Antwort ben?tigt !!!You have to adjust the HitCounter performance counter when a hit occurs.What should you do?()

A.

B.

C.

D.


参考答案:A

第9题:

The application workload on your database is same between 10 a.m. and 11 a.m. on weekdays. Suddenly you observe poor performance between 10 a.m. and 11 a.m. in the middle of the week. How would you identify the changes in configuration settings, workload profile,and statistics to diagnose the possible causes of the performance degradation?()

  • A、by using the SQL access advisor
  • B、by using the Automatic Workload Repository report
  • C、by running the Automatic Database Diagnostic Monitor (ADDM)
  • D、by using the Automatic Workload Repository Compare Period report
  • E、by analyzing the output of the V$ACTIVE_SESSION_HISTORY view

正确答案:D

第10题:

What does the "allow performance information collection" button do in the Hardware Management Console (HMC) GUI? ()

  • A、 It allows you to get inter partition reports, or cross partition performance activity.
  • B、 It will allow IBM remote technical support to get performance information from the machine.
  • C、 It is effective only on POWER6 and when Live Partition Mobility operations are planned.
  • D、 It will start standard performance monitoring tools when an LPAR boots up, the output will be saved to the /etc/perf directory by default.

正确答案:A

更多相关问题