Document ID: 32645-01-1100
This manual is intended for:
Sybase® System Administrators
Database designers
Application developers
This book contains the following chapters:
Chapter 1, "Introduction to Performance Analysis," describes the major components to be analyzed when addressing performance.
Chapter 2, "Database Design and Denormalizing for Performance," provides a brief description of relational databases and good database design.
Chapter 3, "Data Storage," describes Sybase SQL Server(TM) page types, how data is stored on pages, and how queries on heap tables are executed.
Chapter 4, "How Indexes Work," provides information on how indexes are used to resolve queries.
Chapter 5, "Estimating the Size of Tables and Indexes," describes different methods for determining the current size of database objects, and for estimating their future size.
Chapter 6, "Indexing for Performance," provides guidelines and examples for choosing indexes.
Chapter 7, "The SQL Server Query Optimizer," describes the operation of the SQL Server query optimizer.
Chapter 8, "Understanding Query Plans," provides examples of showplan messages.
Chapter 9, "Advanced Optimizing Techniques," describes advanced tools for tuning query performance.
Chapter 10, "Transact-SQL Performance Tips," contains tips and workarounds for specific types of queries.
Chapter 11, "Locking on SQL Server," describes locking on SQL Server and techniques for reducing lock contention.
Chapter 12, "Cursors and Performance," details some issues with cursors and performance.
Chapter 13, "Controlling Physical Data Placement," describes the uses of segments and partitions for controlling the physical placement of data on storage devices.
Chapter 14, "tempdb Performance Issues," stresses the importance of the temporary database, tempdb, and provides suggestions for improving its performance.
Chapter 15, "Memory Use and Performance," describes how SQL Server uses memory for the procedure and data caches.
Chapter 16, "Networks and Performance," describes network issues.
Chapter 17, "Using CPU Resources Effectively," provides information for tuning servers with multiple CPUs.
Chapter 18, "Maintenance Activities and Performance," describes the performance impact of maintenance activities.
Chapter 19, "Monitoring SQL Server Performance with sp_sysmon," describes how to use a system procedure that monitors SQL Server performance.
SQL Server relational database management system documentation is designed to satisfy both the inexperienced user's preference for simplicity and the experienced user's desire for convenience and comprehensiveness. The user's guide and the reference manuals address the various needs of end users, database and security administrators, application developers, and programmers.
Other manuals you may find useful are:
SQL Server installation and configuration guide, which describes the installation procedures for SQL Server and the operating system-specific system administration, security administration, and tuning tasks.
SQL Server Reference Manual, which contains detailed information on all of the commands and system procedures discussed in this manual.
SQL Server Reference Supplement, which contains a list of the Transact-SQL® reserved words, definitions of system tables, a description of the pubs2 sample database, a list of SQL Server error messages, and other reference information that is common to all the manuals.
SQL Server Security Administration Guide explains how to use the security features provided by SQL Server to control user access to data. The manual includes information about how to add users to SQL Server, how to give them controlled access to database objects and procedures, and how to manage remote SQL Servers.
SQL Server Security Features User's Guide explains how to use the security features of SQL Server.
SQL Server System Administration Guide, which provides in-depth information about administering servers and databases. The manual includes instructions and guidelines for managing physical resources and user and system databases, and specifying character conversion, international language, and sort order settings.
The SQL Server utility programs manual, which documents the Sybase utility programs such as isql and bcp, that are executed at the operating system level.
Transact-SQL User's Guide, which documents Transact-SQL, the Sybase enhanced version of the relational database language. This manual serves as a textbook for beginning users of the database management system.