Pro SQL server 2012 practices
Pro SQL Server 2012 Practices is an anthology of high-end wisdom from a group of accomplished database administrators who are quietly but relentlessly pushing the performance and feature envelope of Microsoft SQL Server 2012. With an emphasis upon performance—but also branching into release manageme...
| Otros Autores: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
[Berkeley, Calif.] :
Apress
2012.
|
| Edición: | 1st ed. 2012. |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009628857506719 |
Tabla de Contenidos:
- Title Page; Copyright Page; Contents at a Glance; Table of Contents; About the Authors; About the Technical Reviewers; Acknowledgments; Introduction; Chapter 1 Be Your Developer's Best Friend; My Experience Working with SQL Server and Developers; Reconciling Different Viewpoints Within an Organization; Preparing to Work with Developers to Implement Changes to a System; Step 1: Map Your Environment; Step 2: Describe the New Environment; Step 3: Create a Clear Document; Step 4: Create System-Management Procedures; Step 5: Create Good Reporting; Ensuring Version Compatibility; Setting Limits
- Logon TriggersPolicy-Based Management; Logging and Resource Control; Next Steps; Chapter 2 Getting It Right: Designing the Database for Performance; Requirements; Table Structure; A Really Quick Taste of History; Why a Normal Database Is Better Than an Extraordinary One; (Semi-)Formal Definition; Practical Application; Columns; Table/row uniqueness; Columns depend only on an entire key; Keys always represent a single expression; Physical Model Choices; Datatype; Constraints; Indexing; Design Testing; Conclusion; Chapter 3 Hidden Performance Gotchas; Predicates; Residuals; Spills; Conclusion
- Chapter 4 Dynamic Management ViewsUnderstanding the Basics; Naming Convention; Groups of Related Views; Varbinary Hash Values; Common Performance-Tuning Queries; Retrieving Connection Information; Showing Currently Executing Requests; Locking Escalation; Finding Poor Performing SQL; Using the Power of DMV Performance Scripts; Divergence in Terminology; Optimizing Performance; Inspecting Performance Stats; Top Quantity Execution Counts; Physical Reads; Physical Performance Queries; Locating Missing Indexes; Partition Statistics; System Performance Tuning Queries
- What You Need to Know About System Performance DMVsSessions and Percentage Complete; Conclusion; Chapter 5 From SQL Trace to Extended Events; SQL Trace; Trace rowset provider; SQL Server Profiler; Trace file provider; Event Notifications; Extended Events; Events; Predicates; Actions; Types and Maps; Targets; Sessions; Built in Health Session; Extended Events .NET provider; Extended Events UI; Session Creation UI; Extended Events Profiler UI; Conclusion; Chapter 6 The Utility Database; Start with Checklists; Daily Checklist Items; Longer-Term Checklist Items; Utility Database Layout
- Data StorageUsing Schemas; Using Data Referential Integrity; Creating the Utility Database; Table Structure; Historical Data Tables; Current Health Tables; Archive Tables; Gathering Data; System Tables; Extended Stored Procedures; CLR; DMVs; Storage; Database File Sizes; Finding the Amount of Free Space; Processors; Error Logs; Indexes; Stored Procedure Performance; Failed Jobs; Reporting Services; Mirroring; AlwaysOn; Managing Key Business Indicators; Using the Data; Automating the Data Collection; Scheduling the Data Collection; Conclusion; Chapter 7 Indexing Outside the Bubble
- The Environment Bubble
