Client/Server Databases with SYBASE A High Performance and Fine Tuning Guide

Name: Client/Server Databases with SYBASE A High Performance and Fine Tuning Guide
Price: 46.31 USD
Availability: InStock
ISBN: 9780070016972

ISBN-10: 0070016976

ISBN-13: 9780070016972

Edition: 1996

Authors: George W. Anderson

List price: $55.00

30 day, 100% satisfaction guarantee!

Marketplace

2 new & used from $46.31

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

This guide to SYBASE focuses on release 11. It highlights the major issues involved in fine-tuning RDBMSs, compares SYBASE with its leading competitors such as Oracle and Informix, and considers the broad implications for database design.

Book details

List price: $55.00
Copyright year: 1996
Publisher: McGraw-Hill Companies, The
Binding: Hardcover
Pages: 580
Size: 6.75" wide x 9.50" long x 1.75" tall
Weight: 2.486
Language: English

Foreword	p. xix
Preface	p. xxi
Acknowledgments	p. xxv
Sybase System 11 Overview and Architecture	p. 1
Introduction	p. 3
Implementation Trends and Features	p. 10
Relational DBMS architecture for scalability	p. 12
DBMS performance and efficiency features	p. 16
DBMS connectivity	p. 24
Advanced RDBMS features	p. 26
DBMS Reliability and Availability	p. 31
Robustness, transactions, recovery, and consistency	p. 31
Client/Server RDBMS Solutions	p. 37
IBM DATABASE 2 AIX/6000	p. 38
Oracle	p. 41
Informix-OnLine	p. 45
Sybase MPP	p. 47
SQL Server Introduction	p. 61
SQL Server Architecture	p. 62
SQL Server Product Line and Features	p. 72
Sybase System 11 feature set (technical summary)	p. 72
Structured Query Language (SQL, support)	p. 73
Referential integrity	p. 75
Data integrity	p. 79
Applications development	p. 81
Disk file management	p. 82
Backup and recovery	p. 84
Security and auditing	p. 86
Sybase Systems Management	p. 87
Sybase SQL Server Manager	p. 88
Sybase Enterprise SQL Server Manager	p. 90
Sybase SQL Server SNMP Subagent	p. 91
The SQL Server Catalog	p. 97
The Catalog	p. 97
Database object identifiers	p. 98
Querying the catalog	p. 99
Updating the catalog	p. 99
System Procedures	p. 101
Using system procedures	p. 101
System Databases	p. 103
The master database	p. 104
The model database	p. 105
The tempdb database	p. 105
The sybsystemprocs database	p. 108
Optional databases	p. 108
Understanding Database Roles	p. 109
Roles required for SA tasks	p. 110
SQL Server roles	p. 110
The database owner	p. 112
The database object owner	p. 113
SQL Server Storage Structure	p. 115
Storage Hierarchy	p. 115
System Tables	p. 117
Storage Summary	p. 119
Page and Object Allocation	p. 120
Indexes	p. 134
Deletes and Updates	p. 139
Hardware	p. 147
RISC Architectures	p. 149
64-bit systems	p. 152
Multiprocessor Systems (Symmetric Multiprocessor Systems)	p. 153
SMP design	p. 154
SMP implementations	p. 157
Clustering	p. 158
MPP	p. 159
IBM RS/6000 SP2	p. 162
Redundant Array of Inexpensive Disks (RAID)	p. 163
Hardware Cache	p. 165
Solid-State Disk	p. 166
Performance Tuning	p. 167
Memory Utilization and Server Configuration	p. 169
Memory Utilization	p. 169
Buffer Manager Overview	p. 172
SQL Server Configuration	p. 176
Group: Configuration Options	p. 185
Backup and recovery	p. 185
Cache manager	p. 186
Disk I/O	p. 187
General information	p. 188
Languages	p. 188
Lock manager	p. 188
Memory use	p. 190
Network communication	p. 190
O/S resources	p. 191
Group: Physical Resources	p. 191
Physical memory	p. 192
Processors	p. 192
SQL Server administration	p. 193
User environment	p. 198
Summary	p. 200
The Reconfigure Command	p. 200
Multiple-Network Engines	p. 201
Monitoring SQL Server	p. 203
Sybase SQL Server Monitor	p. 203
Feature set	p. 203
SQL Server Monitor architecture	p. 204
Implementation	p. 207
Monitoring SQL Server	p. 207
SQL Server activity	p. 208
Determining who is logged into a server	p. 210
SQL Server lock activity	p. 212
System activity reports	p. 215
SQL Server Monitor	p. 216
Killing SQL Server processes	p. 221
The syslogshold Table	p. 221
Memory	p. 225
Virtual Memory	p. 225
More on SQL Server Memory	p. 230
Data and Procedure Cache	p. 230
Named Data Caches	p. 236
Implementation	p. 242
Usage guidelines and tuning	p. 251
Cache Analysis Tool	p. 257
DBCC Commands	p. 257
Input/Output	p. 261
Table and Index Segments	p. 262
System Procedures	p. 262
Segment Summary	p. 266
Table and Index Splitting	p. 267
Table and Index Disk Striping	p. 268
Disk Controllers	p. 268
The tempdb Database	p. 270
Transaction Logs	p. 272
Replication Server--secondary log truncation point	p. 273
Private log cache	p. 275
PLC architecture	p. 275
System Procedures	p. 277
Data Partitioning	p. 278
The Sybase implementation	p. 278
Addendum to Chap. 5--Effects of data partitioning on storage structure	p. 280
Basic implementation	p. 282
I/O Strategies	p. 287
Hot Spots	p. 288
Monitoring I/O	p. 289
Central Processing Unit	p. 293
Uniprocessor	p. 294
Symmetric Multiprocessors	p. 294
Assessing whether CPU Is Busy	p. 300
Assessing whether CPU is busy	p. 300
CPU requirements for Sybase	p. 303
Tuning SQL Server Engines	p. 305
Design and Indexing	p. 309
Database Design	p. 309
Types of Indexes	p. 315
Queries	p. 321
Types of queries	p. 322
Stored procedures	p. 323
Joins	p. 323
Cache strategy and I/O size	p. 324
Index selection	p. 326
Select arguments	p. 326
Summary	p. 327
Monitoring Query Plans	p. 327
Update in Place	p. 331
Referential Integrity	p. 332
Rules and defaults	p. 333
Views	p. 334
Declarative referential integrity	p. 335
Naming Standards	p. 339
Tuning Long-Running Jobs	p. 341
Improving Sort Performance	p. 342
Temporary Tables	p. 342
Enlarging the Buffer Cache	p. 346
Using the Bulk-Copy Program	p. 347
Command line options	p. 348
Loading data (copy in)	p. 348
Unloading Data (copy out)	p. 349
Bulk-copy library	p. 349
BCP tips	p. 349
Tuning performance	p. 351
The DBCC tune interface	p. 353
Running Jobs in Parallel	p. 354
Third-Party Tools	p. 356
SyncSort	p. 357
Platinum Technologie's Image Analyzer	p. 359
Creating Indexes after Inserts	p. 361
Tuning in the Client/Server Environment	p. 363
Sybase Open Client	p. 363
Open Client libraries	p. 365
Environment variables	p. 369
The interfaces file	p. 370
Embedded SQL	p. 373
Client/Server Performance Issues	p. 374
Distributed Databases	p. 375
Monitoring the Network	p. 376
Running Long-Running Jobs at the Server	p. 379
Tuning Open Client	p. 379
Transaction Management	p. 381
Locking and Concurrency	p. 383
Introduction	p. 383
Locking Levels	p. 385
Ansi isolation levels	p. 386
Sybase Locking Strategy	p. 387
Page locks	p. 387
Table locks	p. 388
Extent locks	p. 389
Demand locks	p. 389
Row-level locking	p. 390
Transaction modes	p. 390
Isolation levels	p. 390
Dirty reads	p. 391
Parallel Lock Manager	p. 391
Configurable lock promotion	p. 393
Select Syntax	p. 395
Keyword holdlock	p. 395
Keyword shared	p. 395
Keyword at isolation	p. 396
Deadlocks and Lock Monitoring	p. 396
The print deadlock information option	p. 397
Obtaining Lock-Wait information	p. 397
The sp_sysmon procedure	p. 398
Avoiding Deadlocks	p. 399
Other Vendors' Locking Strategies	p. 400
Oracle	p. 401
Informix	p. 402
Distributed Transaction Management	p. 405
Database Transactions	p. 405
Distributed Transaction Management	p. 407
Two-phase commit protocol	p. 408
Distributed two-phase commit	p. 410
Transaction monitors	p. 411
Sybase and Distributed Transaction Management	p. 413
X/Open DTP reference model	p. 414
SYBASE Replication Server	p. 416
Site autonomy	p. 417
Replication transparency	p. 418
Data replication versus two-phase commit	p. 418
High availability	p. 421
Performance	p. 421
The Sybase implementation--SYBASE on-line asynchronous replication	p. 421
Replication Server application architecture	p. 425
Microsoft's SQL Server	p. 427
Transact-SQL	p. 429
Stored Procedures	p. 431
The Procedure Cache	p. 432
Stored Procedures	p. 433
Related commands	p. 435
Output parameters	p. 437
Transactions and save points	p. 438
Isolation levels	p. 439
Security issues	p. 440
Creating System Procedures	p. 442
SQL Server Error Checking	p. 444
More global variables	p. 445
Stored-procedure return codes	p. 446
Severity levels	p. 446
SQL-92 enhancements	p. 449
Stored-Procedure Tips	p. 450
Stored-Procedure Monitoring	p. 452
Triggers	p. 453
Related Commands	p. 455
Transaction Processing	p. 455
Triggers as Security Mechanisms	p. 458
Examples	p. 459
Triggers in Replication Server Environments	p. 464
Summary and Tips	p. 465
Cursors	p. 467
Transact-SQL Extensions	p. 468
Common SQL Statements	p. 469
Advanced Features	p. 470
Scrollable cursors	p. 470
Cursor locking	p. 471
A Cursor Example	p. 472
Comments	p. 475
Microsoft Implementation	p. 475
Housekeeping and Maintenance	p. 477
The Housekeeper	p. 477
Index Maintenance	p. 480
Clustered index	p. 480
Maintaining heap tables	p. 480
Maintaining Partitioned Tables	p. 483
Statistics and Stored-Procedure Maintenance	p. 484
Log File Maintenance	p. 487
Patching a Database	p. 488
The patching process	p. 489
Data Workbench	p. 490
DBCC commands	p. 490
Platinum Log Analyzer	p. 491
Conclusion	p. 493
Data Warehousing	p. 493
Warehouse WORKS	p. 494
SYBASE IQ	p. 496
SQL Server: Future Trends	p. 499
Other Trends	p. 503
Distributed computing environment	p. 503
Wireless communications	p. 509
Multimedia	p. 510
Object transport system	p. 510
PowerSoft Optima++	p. 512
System 11 Connectivity	p. 512
Open Client/Open Server	p. 513
Embedded SQL	p. 515
Glossary	p. 517
SQL Server System Specifications	p. 533
SQL Server System Catalog	p. 535
System Stored Procedures	p. 537
SYBASE Data Types	p. 543
CT-Library API Calls	p. 545
DBCC Commands	p. 547
Suggested Publications	p. 549
C. J. Date's Distributed Database Rules	p. 551
SQL Server Trace Flags	p. 561
Acronyms	p. 563
Log Record Types	p. 569
Index	p. 571
Table of Contents provided by Syndetics. All Rights Reserved.