Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook
โ Scribed by England K.
- Year
- 2001
- Tongue
- English
- Leaves
- 293
- Category
- Library
No coin nor oath required. For personal study only.
โฆ Synopsis
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<'e>moire.
๐ SIMILAR VOLUMES
Database professionals will find that this new edition aids in mastering the latest version of Microsoft's SQL Server. Developers and database administrators (DBAs) use SQL on a daily basis in application development and the subsequent problem solving and fine tuning. Answers to SQL issues can be qu
Dive deep into the internals of query tuning and optimization in SQL Server 2005 with this comprehensive reference. Understanding the internals of SQL Server helps database developers and administrators to better create, access, and effectively process information from enterprise data. Written by ex
The SQL Server 6.5 Performance Optimization and Tuning Handbook takes a detailed look at the factors that influence database performance, beginning with good physical design. The internal storage structures are covered next, because an understanding of these is essential to performance tuning. The c