Relational databases place heavy demands on their underlying hardware and many of these databases are mission-critical resources for multiple applications, where performance bottlenecks are immediately noticeable and often very costly to the business. Despite this, many database administrators are not very knowledgeable about server hardware. Many medium-to-large companies have completely separate departments that are responsible for hardware selection, configuration, and maintenance, and the DBA with no knowledge of hardware is often completely at their mercy.
Likewise, many DBAs are also unaware of the performance implications of the various options and configurations for SQL Server, and the Operating System on which it is installed. Glenn Berry is a highly experienced Database Architect, teacher and SQL Server MVP, and his book is designed to provide the fundamental knowledge and resources you need to make intelligent choices about optimal installation and configuration of SQL Server hardware, operating system and the SQL Server RDBMS.
With what you learn in this book, you'll be able to ensure that your SQL Server instances can handle gracefully the CPU, memory and IO workload generated by your applications, and that the operating system and SQL Server itself are installed, patched, and configured for maximum performance and reliability.
Table of contents
- Processors and Associated Hardware
- The Storage Subsystem
- Benchmarking Tools
- Hardware Discovery
- Operating System Selection and Configuration
- SQL Server Version and Edition Selection
- SQL Server Installation and Configuration
- Intel and AMD Processors and Chipsets
- Installing a SQL Server 2008 R2 Cumulative Update
- Abbreviations
| Pages : | 318 |
| Size : | 9.0 MB |
| Downloads: | 136 |
| Created: | 2022-02-03 |
| License: | For personal or educational use |
| Author(s): | Glen Berry |
Warning: Trying to access array offset on false in /home/tutovnfz/public_html/amp/article-amp.php on line 263
Others related eBooks about SQL Server Hardware
PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural ..., download free PL/SQL tutorial in PDF (440 pages) created by Saurabh K. Gupta .
Download free course SQL Interview Questions free PDF, pdf file on 17 pages by tutorialkart.com.
Download free course PostgreSQL Shell Commands free PDF, pdf file on 8 pages by tutorialkart.com.
This course about PostgeSQL is a pdf document intended to beginners who wants to learn the basics of PostgreSQL SBGD.
This book written to provide clear and concise explanation of topics for programmers both starting to learn the Structured Query Language (SQL) as well as those diving in more complex topics. Most examples are linked to online playground that allows you to change the code and re-run it.