Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook
England K.
In his second volume on SQL Server, England (a consultant and trainer) takes you through the goals of performance tuning and the elements of the physical database design process, including data volume analysis and transaction analysis. He then describes SQL Server storage structures, introduces clustered and nonclustered indexes, the query optimizer, the interaction between SQL Server and Windows 2000 in the area of CPU, and memory and disk I/O. The remaining chapters explain SQL Server locking mechanism, performance monitoring, and provides a performance tuning aide-m
Категорії:
Рік:
2001
Видавництво:
NEWNES
Мова:
english
Сторінки:
293
ISBN 10:
1555582044
ISBN 13:
9781555582043
Файл:
PDF, 6.72 MB
IPFS:
,
english, 2001