458 Tivoli Business Systems Manager Version 2.1: End-to-End Business Impact Management
11.Figure 14-16 shows the summary window for the plan. Provide the name for
your plan and click Finish to save and activate the plan.
Figure 14-16 Database Maintenance Plan Wizard summary
14.3 Microsoft SQL Server and Windows 2000 tuning
This section provides some customization tips to boost SQL server performance
and tune Windows 2000 to work optimally with IBM Tivoli Business Systems
Manager. The discussion covers:
򐂰 14.3.1, Windows 2000 Advanced Server tuning on page 458
򐂰 14.3.2, Microsoft SQL Server 2000 tuning on page 462
14.3.1 Windows 2000 Advanced Server tuning
Windows 2000 offers tuning tips that can maximize Microsoft SQL Server
performance. Because SQL server runs as a service on the operating system,
setting our IBM Tivoli Business Systems Manager servers to give background
services higher priority helps SQL servers perform better. To change this setting,
run the System applet from Start -> Settings -> Control Panel, select the
Advanced tab, and click Performance Options as shown in Figure 14-17 on
page 459.
Chapter 14. Maintenance and tuning issues 459
Figure 14-17 Windows 2000 System Properties
Check the Background services option in the Performance Options window as
shown in Figure 14-18.
Figure 14-18 Windows2000 Performance Options
460 Tivoli Business Systems Manager Version 2.1: End-to-End Business Impact Management
Another tuning customization available in Windows 2000 maximizes the data
throughput for network applications. Right-click the My Network Places icon and
select Properties. Open the Properties page of the active Local Area Network
device, as shown in Figure 14-19.
Figure 14-19 Windows 2000 Local Area Connection Properties
Chapter 14. Maintenance and tuning issues 461
In the Sharing tab, choose the option Maximize data throughput for network
applications, as shown in Figure 14-20.
Figure 14-20 Windows 2000 File and Printers Sharing Properties
462 Tivoli Business Systems Manager Version 2.1: End-to-End Business Impact Management
14.3.2 Microsoft SQL Server 2000 tuning
Microsoft SQL Server can be configured for optimal memory utilization. We
found that the best configuration is for allowing Windows 2000 to use dynamic
memory allocation, setting the /3GB switch in the boot.ini file. In this way the SQL
server can use up to 3GB of memory. To reserve physical memory for your SQL
server and allow dynamic memory allocation, open the SQL Server Properties
dialog from the SQL Server Enterprise Manager and choose the Memory tab as
shown in Figure 14-21.
Figure 14-21 SQL Server Properties Memory window

Get Tivoli Business Systems Manager V2.1 End-to-end Business Impact Management now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.