Troubleshooting | Microsoft SQL Server 2008 R2 Administration Cookbook

Sign In Start Free Trial

Book Overview & Buying
Table Of Contents

Microsoft SQL Server 2008 R2 Administration Cookbook

By : Satya Shyam K Jayanty

4 (6)

Microsoft SQL Server 2008 R2 Administration Cookbook

4 (6)

By: Satya Shyam K Jayanty

Overview of this book

Microsoft SQL Server 2008 R2 Administration Cookbook

Microsoft SQL Server 2008 R2 Administration Cookbook

Credits

Credits

Foreword

Foreword

About the Author

About the Author

Acknowledgment

Acknowledgment

About the Reviewers

About the Reviewers

www.PacktPub.com

www.PacktPub.com

Preface

Preface

Free Chapter

Getting Started with SQL Server 2008 R2

Getting Started with SQL Server 2008 R2

Introduction

Adding SQL Server 2008 R2 Service Pack features using Slipstream technology

Designing a best practice approach to upgrading to SQL Server 2008 R2

There's more.

Working with Data-Tier applications

Designing and adopting SQL Server 2008 R2 solutions

Designing applications to use federated servers

Administrating the Core Database Engine

Administrating the Core Database Engine

Introduction

Designing automated administration practices

Implementing Security feature enhancements

Implementing Availability feature enhancements

Implementing, Monitoring, and Tuning for performance

Administering SQL Server workloads with Resource Governor

Designing SQL Server Agent scheduled jobs for ETL processes

Troubleshooting multi-server instances with utility administration

Administering SQL Server Replication processes

Managing the Core Database Engine

Managing the Core Database Engine

Introduction

Implementing Central Management feature enhancements

Designing Multi-server management from SQL Server 2008 R2

Managing the Utility Control Point data warehouse database

Implementing Utility & Non-utility collection sets

Designing and refreshing a Scalable Shared database

Managing SQL Server Replication processes

Implementing security for SQL Server Agent jobs management

Multiserver Management Using Utility Explorer

Administering Core Business Intelligence Services

Administering Core Business Intelligence Services

Introduction

Preparing and installing SQL Server Analysis Services

Implementing Scale-Out of SQL Server Analysis Services

Administering SQL Server Reporting Services

Implementing Scale-Out deployment of SQL Server Reporting Services

Preparing and installing SQL Server Integration Services

Managing the ETL process efficiently

Managing Core SQL Server 2008 R2 Technologies

Managing Core SQL Server 2008 R2 Technologies

Introduction

Planning and implementing Self-Service Business Intelligence services

Implementing Microsoft StreamInsight Technologies Platform

Implementing SQL Azure connectivity features

Installing and configuring a Master Data Services Solution

Designing and deploying framework to use Master Data Services

Improving Availability and enhancing Programmability

Improving Availability and enhancing Programmability

Introduction

Preparing new Failover Cluster features

Installing and configuring Failover Cluster Services

Recovering and troubleshooting Failover Cluster Failure

Implementing Database Mirroring features and performance enhancements

Managing Database Mirroring in a Failover Cluster environment

Managing Log Shipping scenarios in a Database Mirroring environment

Improving Replication scalability at multiple sites

Implementing compressed storage features for tables and indexes

Designing a storage solution for unstructured data and new collations

Designing data partitioning solutions for tables and indexes

Implementing sparse columns and wide table features

Designing spatial data storage methods

Deploying and managing data-tier applications

Implementing New Manageability Features and Practices

Implementing New Manageability Features and Practices

Introduction

Implementing auditing and service level security features

Managing server-level securable and database-level permissions

Implementing backup compression for a VLDB environment

Designing change tracking methodology

Implementing Policy-Based Management features

Implementing and running PowerShell for SQL Server features

Implementing the SQL Server Best Practices Analyzer

Designing Transparent Data Encryption features

Maintenance and Monitoring

Maintenance and Monitoring

Introduction

Implementing performance baseline practices

Monitoring resource usage with Extended Events

Implementing Management Data Warehouse features

Designing maintenance tasks on a mission-critical environment

Implementing Piecemeal restore strategies

Planning and designing of a Disaster Recovery environment

Implementing sustainable index maintenance practices for a VLDB & 24/7 environment

Configuring a manageable database consistency and integrity process for multiple databases and a VLDB environment

Configuring a server storage system for scalability

Configuring SQL server storage architecture for quick recovery

Managing a storage system for analyzing bottlenecks

Troubleshooting

Troubleshooting

Introduction

Implementing systematized monitoring methods for data platform optimization

Designing a filtered indexes and statistics feature

Implementing table hints for advanced query tuning performance

Implementing query hints for optimized performance

Designing sustainable locking methods to improve concurrency

Implementing parallel query processing methods

Implementing the plan guide to enhance compile-time and run-time execution plans

Configuring and managing storage systems for optimized defragmentation processes

Building best usage processes of Dynamic Management Views

Implementing a benchmarking framework on multiple instances

Learning the Tricks of the Trade

Learning the Tricks of the Trade

Introduction

Automated administration across an enterprise

Administrating resource health policies

Administrating multiple Analysis Services using Tools

Managing events capture to troubleshoot problems

More DBA Manageability Best Practices

More DBA Manageability Best Practices

Building best usage processes of Dynamic Management Views

Dynamic Management Views (DMV) and functions are a useful resource for a DBA to obtain the server and database state information. The status of internal and implementation-specific data can be obtained along with the schemas. DMVs and functions are divided into two types: server-scoped and database-scoped. Further, each of them is organized into different categories such as Database mirroring, disk, CPU, Change Data Capture, Extended Events, SQLOS, Resource Governor, and many more. In this recipe, we will go through the recommended practices and best usage processes of DMVs in the SQL Server environment.

How to do it...

The following steps are formed as a guidance in building best usage processes of DMVs. For the record, there are a total of 136 DMVs and functions available in SQL Server 2008 R2.

Note

The number of DMVs will be changed based on the service pack releases and in future versions of SQL Server.

1. To obtain the list of DMVs...

CONTINUE READING

83

Tech Concepts

36

Programming languages

73

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

Microsoft SQL Server 2008 R2 Administration Cookbook

Search

Your notes and bookmarks