| |
| |
| Foreword | |
| |
| |
| Preface | |
| |
| |
| The team that wrote this redbook | |
| |
| |
| Comments welcome | |
| |
| |
| |
| Introduction | |
| |
| |
| |
| Three phases | |
| |
| |
| |
| Netfinity Performance Lab | |
| |
| |
| |
| IBM Center for Microsoft Technologies | |
| |
| |
| |
| This redbook | |
| |
| |
| |
| Understanding server types | |
| |
| |
| |
| Domain controllers | |
| |
| |
| |
| Windows 2000 Active Directory domain controllers | |
| |
| |
| |
| File and print servers | |
| |
| |
| |
| Print server | |
| |
| |
| |
| Database servers | |
| |
| |
| |
| E-mail servers | |
| |
| |
| |
| Web servers | |
| |
| |
| |
| Groupware servers | |
| |
| |
| |
| Multimedia server | |
| |
| |
| |
| Communication server | |
| |
| |
| |
| Terminal server | |
| |
| |
| |
| Server subsystems | |
| |
| |
| |
| Introduction | |
| |
| |
| |
| Processors and cache subsystem | |
| |
| |
| |
| Processors | |
| |
| |
| |
| Pentium | |
| |
| |
| |
| Pentium Pro | |
| |
| |
| |
| Pentium II | |
| |
| |
| |
| Pentium II Xeon | |
| |
| |
| |
| Pentium III and Pentium III Xeon processors | |
| |
| |
| |
| Processor summary | |
| |
| |
| |
| SMP design and performance | |
| |
| |
| |
| Hardware scaleability | |
| |
| |
| |
| Software scaleability | |
| |
| |
| |
| Processor performance | |
| |
| |
| |
| L2 cache size | |
| |
| |
| |
| CPU clock speed | |
| |
| |
| |
| Number of processors | |
| |
| |
| |
| Rules of thumb | |
| |
| |
| |
| CPU rules of thumb | |
| |
| |
| |
| L2 cache rules of thumb | |
| |
| |
| |
| CPU scaleability rules of thumb | |
| |
| |
| |
| PCI bus subsystem | |
| |
| |
| |
| Design | |
| |
| |
| |
| PCI bus operation | |
| |
| |
| |
| PCI bus performance | |
| |
| |
| |
| PCI bridges and multiple PCI buses | |
| |
| |
| |
| PCI chipsets | |
| |
| |
| |
| Intel 440LX chipset | |
| |
| |
| |
| Intel 440BX chipset | |
| |
| |
| |
| Intel 440GX chipset | |
| |
| |
| |
| Intel 450GX chipset | |
| |
| |
| |
| Intel 450NX chipset | |
| |
| |
| |
| Reliance Champion 2.0 LE chipset | |
| |
| |
| |
| Reliance Champion 2.0 HE chipset | |
| |
| |
| |
| ServerWorks ServerSet III LE chipset | |
| |
| |
| |
| Intel Profusion chipset | |
| |
| |
| |
| Memory subsystem | |
| |
| |
| |
| Memory types | |
| |
| |
| |
| Specifying memory performance | |
| |
| |
| |
| Fast page mode memory | |
| |
| |
| |
| FPM performance | |
| |
| |
| |
| Extended data out (EDO) memory | |
| |
| |
| |
| EDO performance | |
| |
| |
| |
| Synchronous Dynamic Random Access Memory (SDRAM) | |
| |
| |
| |
| Registered and unregistered DIMMs | |
| |
| |
| |
| PC 100 and PC 133 memory | |
| |
| |
| |
| SDRAM performance | |
| |
| |
| |
| Double Data Rate memory (DDR) | |
| |
| |
| |
| DDR performance | |
| |
| |
| |
| Rambus memory | |
| |
| |
| |
| Memory interleaving | |
| |
| |
| |
| Netfinity 8500R performance | |
| |
| |
| |
| Netfinity 7000 M10 performance | |
| |
| |
| |
| Addressing memory above 4 GB | |
| |
| |
| |
| PAE-36 and PSE-36 | |
| |
| |
| |
| Physical Address Extension (PAE) | |
| |
| |
| |
| Page Size Extension (PSE) | |
| |
| |
| |
| Address Windowing Extensions (AWE) | |
| |
| |
| |
| Advanced ECC memory (Chipkill) | |
| |
| |
| |
| Memory rules of thumb | |
| |
| |
| |
| Disk subsystem | |
| |
| |
| |
| SCSI bus overview | |
| |
| |
| |
| SCSI | |
| |
| |
| |
| SCSI-2 | |
| |
| |
| |
| Ultra SCSI | |
| |
| |
| |
| Ultra2 SCSI | |
| |
| |
| |
| Ultra3 SCSI | |
| |
| |
| |
| SCSI controllers and devices | |
| |
| |
| |
| SCSI IDs | |
| |
| |
| |
| Disk array controller architecture | |
| |
| |
| |
| Disk array controller operation | |
| |
| |
| |
| RAID summary | |
| |
| |
| |
| RAID-0 | |
| |
| |
| |
| RAID-1 | |
| |
| |
| |
| RAID-1E | |
| |
| |
| |
| RAID-5 | |
| |
| |
| |
| RAID-5E | |
| |
| |
| |
| Composite RAID levels | |
| |
| |
| |
| ServeRAID RAID-5 algorithms | |
| |
| |
| |
| Read/modify write algorithm | |
| |
| |
| |
| Full XOR algorithm | |
| |
| |
| |
| Sequential write commands | |
| |
| |
| |
| Factors affecting disk array controller performance | |
| |
| |
| |
| RAID strategy | |
| |
| |
| |
| Number of drives | |
| |
| |
| |
| Drive performance | |
| |
| |
| |
| Logical drive configuration | |
| |
| |
| |
| Stripe size | |
| |
| |
| |
| SCSI bus organization and speed | |
| |
| |
| |
| Disk cache write-back versus write-through | |
| |
| |
| |
| RAID adapter cache size | |
| |
| |
| |
| Device drivers | |
| |
| |
| |
| Firmware | |
| |
| |
| |
| Fibre Channel | |
| |
| |
| |
| Fibre Channel performance issues | |
| |
| |
| |
| Tuning with Netfinity FAStT Storage Manager | |
| |
| |
| |
| Disk subsystem rules of thumb | |
| |
| |
| |
| Network subsystem | |
| |
| |
| |
| Operation | |
| |
| |
| |
| Performance | |
| |
| |
| |
| Network design | |
| |
| |
| |
| Device drivers | |
| |
| |
| |
| Load balancing | |
| |
| |
| |
| Adaptive load balancing (ALB) | |
| |
| |
| |
| Fast EtherChannel (FEC) | |
| |
| |
| |
| Gigabit EtherChannel (GEC) | |
| |
| |
| |
| Data transmission unit size tuning | |
| |
| |
| |
| Media and link layer | |
| |
| |
| |
| Transport layer | |
| |
| |
| |
| TCP/IP tuning | |
| |
| |
| |
| LAN rules of thumb | |
| |
| |
| |
| Operating system | |
| |
| |
| |
| Introducing Windows 2000 | |
| |
| |
| |
| Tuning | |
| |
| |
| |
| Application performance boost | |
| |
| |
| |
| Virtual memory | |
| |
| |
| |
| Optimizing for Windows paging | |
| |
| |
| |
| Specifying the server type | |
| |
| |
| |
| Disabling unnecessary services | |
| |
| |
| |
| Remove unnecessary networking protocols and services | |
| |
| |
| |
| Optimize the protocol binding order | |
| |
| |
| |
| Log off the server | |
| |
| |
| |
| Install the latest device drivers | |
| |
| |
| |
| Distribute the work load | |
| |
| |
| |
| File systems | |
| |
| |
| |
| Disabling short name generation | |
| |
| |
| |
| CPU intensive applications | |
| |
| |
| |
| Tuning TCP/IP | |
| |
| |
| |
| Tuning domain controllers | |
| |
| |
| |
| Monitoring tools | |
| |
| |
| |
| Performance monitoring tools | |
| |
| |
| |
| Comparing the tools | |
| |
| |
| |
| Using Performance Monitor | |
| |
| |
| |
| Using Capacity Manager | |
| |
| |
| |
| Windows 2000 Performance console | |
| |
| |
| |
| Overview | |
| |
| |
| |
| System Monitor | |
| |
| |
| |
| Performance Logs and Alerts | |
| |
| |
| |
| Objects, counters and instances | |
| |
| |
| |
| System Monitor | |
| |
| |
| |
| Adding counters | |
| |
| |
| |
| Deleting objects | |
| |
| |
| |
| Saving object and counter settings | |
| |
| |
| |
| Highlighting an object counter | |
| |
| |
| |
| Performance Logs and Alerts | |
| |
| |
| |
| Counter logs | |
| |
| |
| |
| Alerts | |
| |
| |
| |
| Trace logs | |
| |
| |
| |
| Key objects and counters | |
| |
| |
| |
| Customizing the Performance console | |
| |
| |
| |
| Using the Performance console with other tools | |
| |
| |
| |
| Missing performance objects | |
| |
| |
| |
| Resource Kit tools for performance | |
| |
| |
| |
| Capacity Manager | |
| |
| |
| |
| What's new? | |
| |
| |
| |
| Capacity Manager data files | |
| |
| |
| |
| Installing Capacity Manager | |
| |
| |
| |
| Monitor Activator | |
| |
| |
| |
| Report Generator | |
| |
| |
| |
| Creating a new report definition | |
| |
| |
| |
| Working with predefined reports | |
| |
| |
| |
| Generating a report | |
| |
| |
| |
| Report Viewer | |
| |
| |
| |
| Setting thresholds | |
| |
| |
| |
| The System pane | |
| |
| |
| |
| The Monitor pane | |
| |
| |
| |
| The Graph pane | |
| |
| |
| |
| Performance analysis | |
| |
| |
| |
| Reports produced | |
| |
| |
| |
| Types of bottlenecks | |
| |
| |
| |
| Setting critical and warning threshold values | |
| |
| |
| |
| Forecast | |
| |
| |
| |
| Task Manager | |
| |
| |
| |
| Starting Task Manager | |
| |
| |
| |
| Processes tab | |
| |
| |
| |
| Performance tab | |
| |
| |
| |
| Working with bottlenecks | |
| |
| |
| |
| Spotting a bottleneck | |
| |
| |
| |
| Step 1: Questions to ask | |
| |
| |
| |
| Step 2: Analyzing the server's performance | |
| |
| |
| |
| Processor subsystem | |
| |
| |
| |
| Memory subsystem | |
| |
| |
| |
| Disk subsystem | |
| |
| |
| |
| Network subsystem | |
| |
| |
| |
| Step 3: How can it be fixed? | |
| |
| |
| |
| Conclusion | |
| |
| |
| |
| Analyzing bottlenecks | |
| |
| |
| |
| Basic tuning strategy | |
| |
| |
| |
| Factors affecting server performance | |
| |
| |
| |
| Application considerations | |
| |
| |
| |
| Performance bottlenecks | |
| |
| |
| |
| Measuring current performance | |
| |
| |
| |
| CPU bottlenecks | |
| |
| |
| |
| Finding CPU bottlenecks | |
| |
| |
| |
| Performance tuning options | |
| |
| |
| |
| Memory bottlenecks | |
| |
| |
| |
| Paged and non-paged RAM | |
| |
| |
| |
| Virtual memory system | |
| |
| |
| |
| Hard page faults | |
| |
| |
| |
| Finding memory bottlenecks | |
| |
| |
| |
| Performance tuning options | |
| |
| |
| |
| Disk bottlenecks | |
| |
| |
| |
| Finding disk bottlenecks | |
| |
| |
| |
| Performance tuning options | |
| |
| |
| |
| Network bottlenecks | |
| |
| |
| |
| Finding network bottlenecks | |
| |
| |
| |
| Performance tuning options | |
| |
| |
| |
| Monitoring network protocols | |
| |
| |
| |
| Anticipating future bottlenecks | |
| |
| |
| |
| Detecting future bottlenecks | |
| |
| |
| |
| Performance analysis | |
| |
| |
| |
| Performance summary and configuration tips | |
| |
| |
| |
| CPU rules of thumb | |
| |
| |
| |
| Disk subsystem rules of thumb | |
| |
| |
| |
| Memory rules of thumb | |
| |
| |
| |
| LAN rules of thumb | |
| |
| |
| |
| McKnight's rule of server behavior | |
| |
| |
| |
| Summary | |
| |
| |
| |
| Case studies | |
| |
| |
| |
| Lotus Notes server | |
| |
| |
| |
| Performance measurement | |
| |
| |
| |
| Data analysis | |
| |
| |
| |
| Summary | |
| |
| |
| |
| File server | |
| |
| |
| |
| Performance measurement | |
| |
| |
| |
| Data analysis | |
| |
| |
| |
| Summary | |
| |
| |
| |
| ERP application server | |
| |
| |
| |
| Data analysis | |
| |
| |
| |
| Summary | |
| |
| |
| |
| Applications | |
| |
| |
| |
| File server | |
| |
| |
| |
| The effect of server hardware on performance | |
| |
| |
| |
| Optimizing operating system performance | |
| |
| |
| |
| Application responsiveness | |
| |
| |
| |
| System cache | |
| |
| |
| |
| Virtual memory | |
| |
| |
| |
| Performance monitoring | |
| |
| |
| |
| Lotus Domino | |
| |
| |
| |
| Important subsystems | |
| |
| |
| |
| Sizing and optimizing the hardware | |
| |
| |
| |
| Memory subsystem | |
| |
| |
| |
| Processor subsystem | |
| |
| |
| |
| Disk subsystem | |
| |
| |
| |
| Optimizing operating system performance | |
| |
| |
| |
| Application responsiveness | |
| |
| |
| |
| System cache | |
| |
| |
| |
| NTFS allocation unit and stripe size considerations | |
| |
| |
| |
| Optimizing Lotus Domino performance | |
| |
| |
| |
| Changing statements in the notes.ini file | |
| |
| |
| |
| Configuring server tasks | |
| |
| |
| |
| Optimizing database performance | |
| |
| |
| |
| Improving mail performance | |
| |
| |
| |
| Calendaring and scheduling resource usage | |
| |
| |
| |
| Minimizing logging activity | |
| |
| |
| |
| Improving Agent Manager performance | |
| |
| |
| |
| Managing server sessions | |
| |
| |
| |
| Controlling user access | |
| |
| |
| |
| Improving replication performance | |
| |
| |
| |
| Enabling of transaction logging | |
| |
| |
| |
| Improving Web server performance | |
| |
| |
| |
| Using port encryption | |
| |
| |
| |
| Lotus Domino partitioning | |
| |
| |
| |
| Balancing workload in a Lotus Domino cluster | |
| |
| |
| |
| Maintaining Lotus Domino servers | |
| |
| |
| |
| Planning for future growth | |
| |
| |
| |
| Top 10 ways to improve your server's performance | |
| |
| |
| |
| Summary | |
| |
| |
| |
| Microsoft Exchange Server | |
| |
| |
| |
| Mail server | |
| |
| |
| |
| Network subsystem | |
| |
| |
| |
| Memory subsystem | |
| |
| |
| |
| CPU subsystem | |
| |
| |
| |
| Disk subsystem | |
| |
| |
| |
| Groupware server | |
| |
| |
| |
| Other server performance factors | |
| |
| |
| |
| Exchange Server performance settings | |
| |
| |
| |
| Using the Performance console | |
| |
| |
| |
| Predefined charts | |
| |
| |
| |
| Basic counters | |
| |
| |
| |
| Exchange Server performance monitoring | |
| |
| |
| |
| Capacity management using LoadSim | |
| |
| |
| |
| Generating scores using LsLog | |
| |
| |
| |
| Performance tools and LoadSim | |
| |
| |
| |
| Performance criteria | |
| |
| |
| |
| SAP R/3 | |
| |
| |
| |
| SAP R/3 application servers | |
| |
| |
| |
| Important subsystems | |
| |
| |
| |
| Optimizing Windows NT and Windows 2000 performance | |
| |
| |
| |
| Application responsiveness | |
| |
| |
| |
| System cache | |
| |
| |
| |
| Virtual memory | |
| |
| |
| |
| Disable unnecessary Windows NT or Windows 2000 services | |
| |
| |
| |
| SAP R/3 monitoring and tuning | |
| |
| |
| |
| Tuning SAP R/3 performance | |
| |
| |
| |
| Tuning Microsoft SQL Server 7.0 for SAP R/3 performance | |
| |
| |
| |
| Hardware tuning and configuration tips | |
| |
| |
| |
| System configuration | |
| |
| |
| |
| Disk array controller optimization | |
| |
| |
| |
| Summary | |
| |
| |
| |
| Microsoft SQL Server 7.0 | |
| |
| |
| |
| What's new in Microsoft SQL Server 7.0 | |
| |
| |
| |
| SQL Server performance tuning basics | |
| |
| |
| |
| Important subsystems | |
| |
| |
| |
| Optimizing Windows NT and Windows 2000 | |
| |
| |
| |
| Application responsiveness | |
| |
| |
| |
| System cache | |
| |
| |
| |
| Virtual memory | |
| |
| |
| |
| The database environment | |
| |
| |
| |
| Optimizing SQL Server subsystems | |
| |
| |
| |
| Max async I/O | |
| |
| |
| |
| Worker threads | |
| |
| |
| |
| LazyWriter | |
| |
| |
| |
| Checkpoint | |
| |
| |
| |
| Log manager | |
| |
| |
| |
| Read-ahead manager | |
| |
| |
| |
| Separating data and selecting RAID levels | |
| |
| |
| |
| SQL Server indexes | |
| |
| |
| |
| Non-clustered Indexes | |
| |
| |
| |
| Clustered Indexes | |
| |
| |
| |
| Covering indexes | |
| |
| |
| |
| Automatic covering indexes or covered queries | |
| |
| |
| |
| Index selection | |
| |
| |
| |
| Clustered index selection | |
| |
| |
| |
| Importance of FILLFACTOR and PAD_INDEX | |
| |
| |
| |
| SQL Server 7.0 performance objects | |
| |
| |
| |
| Oracle | |
| |
| |
| |
| Oracle architecture | |
| |
| |
| |
| Memory | |
| |
| |
| |
| Processes | |
| |
| |
| |
| DBMS files | |
| |
| |
| |
| OLTP vs OLAP | |
| |
| |
| |
| Online transaction processing | |
| |
| |
| |
| Online analytical processing | |
| |
| |
| |
| Important subsystems | |
| |
| |
| |
| Operating system optimization | |
| |
| |
| |
| Oracle memory optimization | |
| |
| |
| |
| Shared pool | |
| |
| |
| |
| Database buffer cache | |
| |
| |
| |
| Redo log buffer cache | |
| |
| |
| |
| Oracle disk I/O optimization | |
| |
| |
| |
| Monitoring database performance | |
| |
| |
| |
| Performance Monitor counters | |
| |
| |
| |
| Summary | |
| |
| |
| |
| Windows 2000 Terminal Services | |
| |
| |
| |
| Important subsystems | |
| |
| |
| |
| Memory | |
| |
| |
| |
| Processor | |
| |
| |
| |
| Network | |
| |
| |
| |
| Tuning | |
| |
| |
| |
| Paging file | |
| |
| |
| |
| Network load balancing | |
| |
| |
| |
| Applications | |
| |
| |
| |
| Performance boost options | |
| |
| |
| |
| Citrix MetaFrame | |
| |
| |
| |
| Citrix load balancing | |
| |
| |
| |
| Appendixes | |
| |
| |
| |
| Special notices | |
| |
| |
| |
| Related publications | |
| |
| |
| |
| IBM Redbooks | |
| |
| |
| |
| IBM Redbooks collections | |
| |
| |
| |
| Referenced Web sites and online documents | |
| |
| |
| How to get IBM Redbooks | |
| |
| |
| IBM Redbooks fax order form | |
| |
| |
| Abbreviations and acronyms | |
| |
| |
| Index | |
| |
| |
| IBM Redbooks review | |