Cargando…
Professional Microsoft SQL Server 2012 Administration.
Chapter 10: Configuring the Server for Optimal Performance; What Every DBA Needs to Know About Performance; What the Developer DBA Needs to Know About Performance; What the Production DBA Needs to Know About Performance; CPU; Memory; I/O; Summary; Chapter 11: Optimizing SQL Server 2012; Application...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Otros Autores: | , , |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Hoboken :
John Wiley & Sons,
2012.
|
| Temas: | |
| Acceso en línea: | Texto completo |
| Sumario: | Chapter 10: Configuring the Server for Optimal Performance; What Every DBA Needs to Know About Performance; What the Developer DBA Needs to Know About Performance; What the Production DBA Needs to Know About Performance; CPU; Memory; I/O; Summary; Chapter 11: Optimizing SQL Server 2012; Application Optimization; The Silent Killer: I/O Problems; Table and Index Partitioning; Data Compression; CPU Considerations; Memory Considerations and Enhancements; Resource Governor; Summary; Chapter 12: Monitoring Your SQL Server; The Goal of Monitoring; Choosing the Appropriate Monitoring Tools. An essential how-to guide for experienced DBAs on the most significant product release since 2005!Microsoft SQL Server 2012 will have major changes throughout the SQL Server and will impact how DBAs administer the database. With this book, a team of well-known SQL Server experts introduces the many new features of the most recent version of SQL Server and deciphers how these changes will affect the methods that administrators have been using for years. Loaded with unique tips, tricks, and workarounds for handling the most difficult SQL Server admin issues, this how-to guide deciphers topics su. |
|---|---|
| Notas: | Improving Query Performance with Indexes. |
| Descripción Física: | 1 online resource (1684 pages) |
| ISBN: | 9781118286845 1118286847 |