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 |
Tabla de Contenidos:
- Cover; Contents; Chapter 1: SQL Server 2012 Architecture; SQL Server 2012 Ecosystem; New Important Features in 2012; SQL Server Architecture; Editions of SQL Server; Summary; Chapter 2: Installing SQL Server 2012 Best Practices; Planning the System; Installing SQL Server; Installing Analysis Services; Installing PowerPivot for SharePoint; Burning in the System; Post-Install Configuration; Uninstalling SQL Server; Troubleshooting a Failed Install; Summary; Chapter 3: Upgrading SQL Server 2012 Best Practices; Why Upgrade to SQL Server 2012?; Upgrading to SQL Server 2012.
- Pre-Upgrade Steps and ToolsBackward Compatibility; SQL Server Component Considerations; Post-Upgrade Checks; Summary; Chapter 4: Managing and Troubleshooting the Database Engine; Configuration and Administration Tools; Troubleshooting Tools; Management Studio; Monitoring Processes in T-SQL; Multiserver Management; Trace Flags; Getting Help from Support; Summary; Chapter 5: Automating SQL Server; Maintenance Plans; Automating SQL Server with SQL Server Agent; SQL Server Agent Security; Configuring SQL Server Agent; Database Mail; Multiserver Administration; Summary.
- Chapter 6: Service Broker in SQL Server 2012Asynchronous Messaging; Configuring SQL Server Service Broker; Using SQL Server Service Broker; Summary; Chapter 7: SQL Server CLR Integration; Introduction to the CLR; Creating CLR Assemblies; Securing CLR; Performance Monitoring; Summary; Chapter 8: Securing the Database Instance; Authentication Types; Authorizing Securables; Row Level Security; Summary; Chapter 9: Change Management; Creating Solutions and Projects; Policy-Based Management; DDL Trigger Syntax; Trigger Views; Scripting Overview; Creating Change Scripts; Data-Tier Applications.
- Performance MonitorMonitoring Events; Monitoring with Dynamic Management Views and Functions; Monitoring Logs; Management Data Warehouse; SQL Server Standard Reports; System Center Management Pack; SQL Server Best Practice Analyzer; System Center Advisor; Summary; Chapter 13: Performance Tuning T-SQL; Physical Query Processing Part One: Compilation and Recompilation; Physical Query Processing Part Two: Execution; Summary; Chapter 14: Indexing Your Database; Noteworthy Index-Related Features in SQL Server; Partitioned Tables and Indexes; Index Maintenance.