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