Database Performance Tuning HandbookDatabase administrators, programmers, system programmers, and technical specialist are responsible for optimizing database usage to improve system performance, but recent changes in database marketplace and the advent of Open Data Base Connectivity have forced them to learn and manage more than one database product.Fortunately, Jeffrey Allan Dunham's Database Performance Tuning Handbook covers all major database products and performance issues in one comprehensive volume. |
Contents
Mainframe Blocking and Buffering | 101 |
PC Files and Buffers | 125 |
DB2 System Tuning | 137 |
Copyright | |
25 other sections not shown
Common terms and phrases
3000-STATISTICS THRU ACCEPT WORK-DBKEY allocation ANY-STATUS NEXT SENTENCE application backup batch block buffer pool bytes CA-IDMS CALL-TYPE Cobol command COMP Computer CURRENCY ON ANY-STATUS data cache database deadlocks default Delphi devices disk DISP=SHR DISPLAY DISPLAY4 example execution EXHIBIT NAMED EXIT Figure IDMS init.ora invoice load locking LOOP-CNT EQUAL mainframe Manager memory Microsoft Microsoft SQL Server MOVE multiple MVS/ESA Newsgroup optimizer option Oracle output packet parameter partition percent PERFORM 2000-STATISTICS THRU PERFORM 3000-STATISTICS PERFORM 500-BUMP-IT Performance Monitor PIC S9 processing processor query records redo rows segment SHOWPLAN Software sort sp_configure sp_sysmon space spinlock SQL Server SQLBench statistics storage stored procedures Sybase Sybase IQ Sybase SQL Server table scans tablespace tempdb transaction tuning UNIX update usage Usenet Usenet Newsgroup utility VARYING LOOP-CNT VSAM Windows 95 Windows NT