Microsoft SQL server 2000 : performance optimization and tuning handbook / Ken England.

Format:

Book

Author/Creator:

England, Ken, 1955-

Language:

English

Subjects (All):

Client/server computing.

Relational databases.

SQL server.

Physical Description:

1 online resource (386 p.)

Other Title:

Microsoft SQL server two thousand

Place of Publication:

Boston : Digital Press, c2001.

Language Note:

English

Summary:

Learn from a SQL Server performance authority how to make your database run at lightning speed. Ken England's SQL Server 6.5 Performance Optimization and Tuning Handbook is recognized by SQL Server administrators as the indispensable guide to tuning and optimization. Now he's revised the book for Microsoft's new SQL Server 2000, the most advanced and powerful version yet of SQL Server, which takes full advantage of Windows 2000's new processing capabilities. The book details the factors that determine database performance and offers readers tools, techniques and best practices they can

Contents:

Cover; Contents; Preface; Acknowledgments; 1 Introducing Performance Tuning and Physical Database Design; What is performance tuning?; The physical database design process; Data volume analysis; Transaction analysis; Hardware environment considerations; Where to next?; 2 SQL Server Storage Structures; Introduction; Databases and files; Creating databases; Increasing the size of a database; Decreasing the size of a database; The autoshrink database option; Shrinking a database in the SQL Server Enterprise Manager; Shrinking a database Using DBCC statements; Removing database files

Modifying filegroup propertiesSetting database options; Displaying information about databases; System tables used in database configuration; Units of storage; Database pages; Looking into database pages; Pages for space management; The BankingDB database; 3 Indexing; Introduction; Data retrieval with no indexes; Clustered indexes; Nonclustered indexes; The role of indexes in insertion and deletion; A note about updates; So how do you create indexes?; The Transact-SQL CREATE INDEX statement; The SQL Enterprise Manager; The Query Analyzer; The Create Index wizard

The SQL Distributed Management Framework ( SQL- DMF)Dropping and renaming indexes; Displaying information about indexes; The SQL Server Enterprise Manager; The system stored procedure sp_helpindex; The system table Sysindexes; Using metadata functions to obtain information about indexes; The DBCC statement DBCC SHOWCONTIG; Creating indexes on views; Creating indexes with computed columns; Using indexes to retrieve data; Retrieving a single row; Retrieving a range of rows; Covered queries; Retrieving a single row with a clustered index on the table

Retrieving a range of rows with a clustered index on the tableCovered queries with a clustered index on the table; Retrieving a range of rows with multiple nonclustered indexes on the table; Choosing indexes; Why not create many indexes?; Online transaction processing versus decision support; Choosing sensible index columns; Choosing a clustered index or a nonclustered index; 4 The Query Optimizer; Introduction; When is the query optimized?; Query optimization; Query analysis; Index selection; Join order selection; How joins are processed; Tools for investigating query strategy

Influencing the query optimizerStored procedures and the query optimizer; Non-stored procedure plans; The Syscacheobjects system table; 5 SQL Server 2000 and Windows 2000; SQL Server 2000 and CPU; Introduction; An overview of Windows 2000 and CPU utilization; How SQL Server 2000 uses CPU; Investigating CPU bottlenecks; Solving problems with CPU; SQL Server 2000 and memory; Introduction; An overview of Windows 2000 virtual memory management; How SQL Server 2000 uses memory; Investigating memory bottlenecks; Solving problems with memory; SQL Server 2000 and disk I/O; Introduction

An overview of Windows 2000 and disk I/O

Notes:

Description based upon print version of record.

Includes bibliographical references (p. 371) and index.

ISBN:

1-281-04922-0

9786611049225

0-08-047945-6

OCLC:

171131358