70-028 Administering Microsoft SQL Server 7.0
Note 2: 70-028 Answers are not shown in demo questions.
Exhibits and Answers are only provided in the Full Version.
Demo Question 1.
EliteCertify 's server running SQL Server is on the same BDC as the server running Microsoft Exchange Server. Exchange Server is performing poorly. The SQL Server set working set size option is at the settings you configured for the min server memory and max server memory options. What should you do to improve the performance of the server running Exchange Server while not adversely affecting SQL Server?
A. Increase the memory allocated to the procedure cache option.
B. Set the set working set size option to 1.
C. Decrease the min server memory setting.
D. Increase the min server memory setting.
Display Answer
Purchase Full Version:
70-028 Printable PDF Prep Guide $59.95 BUY NOW!
70-028 Test Simulation Engine $69.95 BUY NOW!
70-028 PDF & Test Simulation Engine $99.95 BUY NOW!
Answer: D.
Explanation: SQL Server and MS Exchange server are running at the same server, not the ideal solution, and
are competing for resources. They have different memory management models and SQL Server have to be
manually configured to improve performance.
The server memory options, min server memory and max server memory, are used to configure the amount of
memory (in MB. in the buffer pool that Microsoft SQL Server uses. By default, SQL Server can change its
memory requirements dynamically based on available system resources. The default setting for min server
memory is 0, and the default setting for max server memory is 2147483647.
By increasing min server memory from 0 to 32MB performance would improve.
Incorrect answers:
A. The procedure cache object was used in SQL Server 6.5 and earlier. It is not supported or configurable
in SQL Server 7.0.
B. Setting the working set size option to 1, default value 0, would force SQL Server to use a fixed amount
of memory. It would not be allowed to dynamically adjust its memory usage.Basically SQL Server
would grab memory and not release it. This is not an optimal solution.
C. The default min server memory setting is 0. It cannot be decreased further.
- Based on the latest 70-028 exam objectives!
- Designed like actual 70-028 exam questions!
- 100% Verified Realistic 70-028 Exam Questions and Answers!
- Exhibits, Drag&Drop and Simulation 70-028 Questions Included!
- Constantly Updated Guide to Reflect the Current 70-028 Exams!
- Detailed Explanations for Most Guide Practice Exams!
Sponsored Links
india
India
UK
Keyword
