Chapter 14. Maintenance and tuning issues 463
Another way to increase SQL server performance is to use multiple processors.
Choose the Processor tab as shown in Figure 14-22 and check the boxes for
Boost SQL Server Priority on Windows NT and Use all Available Processors. Do
not check Use Windows NT fibers.
Figure 14-22 SQL Server Properties Processor window
464 Tivoli Business Systems Manager Version 2.1: End-to-End Business Impact Management
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.