Saturday, October 4, 2014

Scaling SQL Server 2012 – Part 1

Pluralsight – Scaling SQL Server 2012 – Part 1
When considering how to improve the scalability of a SQL Server workload, many people jump to the conclusion that scaling up or scaling out are the only answers. This course will show you that there are a huge number of things you can do to improve performance and scalability before you should even think of scale-up or scale-out. The bulk of the course describes architecture and design issues in both the application and the database that can affect scalability, along with demonstrations of some of the issues and detailed scripts to help you find the issues in the first place. The course ends with a section on common indexing problems that can drastically limit a workload’s scalability, along with how to identify and fix them. Save your company a bunch of money by postponing the scaling decision through fixing your existing scalability bottlenecks, not ignoring them! This course is perfect for anyone who is responsible for improving the performance and scalability of a SQL Server workload, with most topics applicable to SQL Server 2005 onward.

Table of content

  • Introduction
    • Introduction
    • Top Scalability Issues with SQL Server 2012
    • Postponing the Scaling Decision
    • Application Architecture and Design Issues
    • Database Architecture and Design Issues
    • Indexing Strategy and Maintenance
    • Summary
    • Course Structure
  • Top Scalability Issues with SQL Server 2012
    • Introduction
    • Largest SQL Server Implementations and Your Nightmare
    • Top Scalability Issues with SQL Server 2012
    • Handling Scalability Issues
    • Summary
    • What is Next?
  • Postponing the Scaling Decision
    • Introduction
    • Postponing the Scaling Decision
    • Preventing Scalability Problems
    • Finding Your Bottlenecks and Improving Them
    • Demo: Sample 911 Emergency Script Part 1
    • Demo: Sample 911 Emergency Script Part 2
    • Using Diagnostic Tools to Find Bottlenecks
    • Common Performance Bottlenecks
    • Working with Consultants
    • Working with Developers
    • Demo: The Bad Man Queries
    • Working with Stakeholders
    • Summary and Return on Investment
    • What is Next?
  • Application Architecture and Design
    • Introduction
    • Application Architecture and Design Issues
    • Application Refactoring
    • Overuse of ORM Code Generators
    • Using Ad Hoc T-SQL from the Application
    • Overuse of XML Data
    • SQL Server Scalar User-Defined Functions
    • Demo: T-SQL Scalar UDFs
    • Too Much Business Logic in the Database
    • Using DML Triggers for Application Logic
    • Using CLR Assemblies for Application Logic
    • Requesting Too Much Data from the Database
    • User-Controlled, Long-Running Transactions
    • Overuse of New SQL Server Features
    • Doing Row-by-Agonizing-Row Processing
    • Demo: Set-Based vs. RBAR Processing
    • Not Having a Data Archiving Strategy
    • Not Having a Reporting Strategy
    • Not Using Middle-Tier Caching
    • Common Middle-Tier Caching Tools
    • Summary
    • What is Next?
  • Database Architecture and Design
    • Introduction
    • Database Architecture and Design Issues
    • Using Default Database Properties
    • Demo: Creating a New Database
    • Data File Physical Layout
    • Transaction Log File Physical Layout
    • Transaction Log File Configuration
    • Poor Database Normalization
    • Lack of Check Constraints
    • Lack of Foreign Keys
    • Heap Tables
    • Inappropriate Data Types
    • Wide Data Types
    • Poor Query Design (1)
    • Demo: Implicit Conversions
    • Poor Query Design (2)
    • SQL Server is a Database Server!
    • Not Using T-SQL Stored Procedures
    • Overuse of ORM Query Generators
    • Additional ORM Query Considerations
    • Summary
    • What is Next?
  • Indexing Strategy and Maintenance
    • Introduction
    • Common Indexing Issues
    • Too Many Indexes
    • Demo: Finding Unused Indexes
    • Having High Impact Missing Indexes
    • Demo: Finding Missing Indexes
    • Finding Missing Index Warnings
    • Missing Index Warning Example
    • Demo: Finding Missing Index Warnings
    • Database Tuning Advisor Issues
    • Demo: Using the DTA Command-Line Utility
    • Having Poorly-Maintained Indexes
    • Improper Index Maintenance
    • Using the SQL Maintenance Plan Wizard
    • Common XML Index Issues
    • Common Spatial Index Issues
    • Not Using Data Compression
    • Data Compression Considerations
    • Demo: Data Compression
    • Not Using Columnstore Indexes
    • Course Summary  


Contact Form


Email *

Message *

Copyright © 2013
Designed By Blogger Templates