SQLAuthority News – Fast Track Data Warehouse Reference Guide for SQL Server 2012

I have always enjoyed learning about Fast Track Data Warehousing Technology. The goal of a Fast Track Data Warehouse reference architecture is to achieve an efficient resource balance between SQL Server data processing capability and realized component hardware throughput.

Recently Fast Track Data Warehouse Reference Architecture is updated for SQL Server 2012. Here are the changes in the FT 4.0.

Description Version Note
SQL Server 2012 4.0 Links to other SQL Server Best Practices documents
SQL Server 2012 4.0 Benchmarking and validation
SQL Server 2012 4.0 Memory requirements
SQL Server 2012 4.0 xVelocity memory-optimized columnstore indexes
SQL Server 2012 4.0 Solid state storage
SQL Server 2012 4.0 Validation and columnstore indexes
SQL Server 2012 4.0 Validation of baseline I/O

Fast Track database component architecture

following are key principles of the Fast Track program:

  • Workload-specific benchmarks. System design and configuration are based on real concurrent query workloads.
  • Detailed and validated hardware component specifications.
  • Component architecture balance between database capability and key hardware resources.

Please read the complete whitepaper over here.

Reference: Pinal Dave (http://blog.sqlauthority.com)

About these ads

SQL SERVER – Technical Reference Guides for Designing Mission-Critical Solutions – A Must Read

Yesterday I was reading architecture reference material helping my friend who was looking for material in this respect. While working together we were searching twitter, facebook and search engines to find relevant material.While searching online we end up on very interactive reference point. Once I send the same to him, he replied he may not need anything more after referencing this material.

The best part of this article was it gives access to various aspect of the technology of the image map.

Here is the abstract of the original article from the site:

The Technical Reference Guides for Designing Mission-Critical Solutions provide planning and architecture guidance for various mission-critical workloads deployed by users. These guides reflect the knowledge gained by Microsoft while working with customers on mission-critical deployments. Each guide provides not only the key technical concepts and information helpful for design, but also “lessons learned,” best practices, and references to customer case studies.

Once you click on any of the desired topic, you will see further detailed image map of the selected topic.

Personally once I ended up on this site, I was there for more than 2 hours clicking through various links.

Click on image to see larger image

Read more here: Technical Reference Guides for Designing Mission-Critical Solutions

Reference: Pinal Dave (http://blog.sqlauthority.com)

SQLAuthority News – Microsoft SQL Server AlwaysOn Solutions Guide for High Availability and Disaster Recovery

SQL Server 2012 is has very exciting new feature of SQL Server AlwaysOn. This new feature reduces planned and unplanned downtime and maximize application available. Additionally it provides data protection keeping database always available. Microsoft has released a whitepaper on this subject where it discusses common context business stakeholders, technical decision makers, system architects, infrastructure engineers, and database administrators.

This whitepaper discusses two major points. Following is the abstract from book online:

High Availability and Disaster Recovery Concepts. Provide a brief discussion of the drivers and challenges of planning, managing, and measuring the business objectives of a highly available database environment. This discussion is followed by a brief overview of the high availability and disaster recovery capabilities of SQL Server 2012 AlwaysOn and Windows Server solutions.

SQL Server AlwaysOn Layers of Protection. Provide a deeper discussion of the feature capabilities, rationale, and dependencies of the layers of protection offered by a SQL Server AlwaysOn solution. It will cover infrastructure availability, SQL Server instance-level protection, database-level protection, and data tier application capabilities.

Microsoft SQL Server AlwaysOn Solutions Guide for High Availability and Disaster Recovery

Reference: Pinal Dave (http://blog.sqlauthority.com)

SQLAuthority News – Implementing a Microsoft SQL Server Parallel Data Warehouse Using the Kimball Approach

This white paper explores how the Kimball approach to architecting and building a data warehouse/business intelligence (DW/BI) system works with Microsoft’s Parallel Data Warehouse, and how you would incorporate this new product as the cornerstone of your DW/BI system. For readers who are not familiar with the Kimball approach, we begin with a brief overview of the approach and its key principles. We then explore the Parallel Data Warehouse (PDW) system architecture and discuss its alignment with the Kimball approach. In the last section, we identify key best practices and pitfalls to avoid when building or migrating a large data warehouse to a Microsoft SQL Server PDW system.

Download the Whitepaper from here.

Note: Abstract taken from whitepaper.

Reference:  Pinal Dave (http://blog.SQLAuthority.com)

SQLAuthority News – Automation of Data Mining Using Integration Services

This article is a walkthrough that illustrates how to build multiple related data models by using the tools that are provided with Microsoft SQL Server Integration Services. In this walkthrough, you will learn how to automatically build and process multiple data mining models based on a single mining structure, how to create predictions from all related models, and how to save the results to a relational database for further analysis. Finally, you view and compare the predictions, historical trends, and model statistics in SQL Server Reporting Services reports.

This solution also introduces the concept of ensemble models for data mining, which are sets of multiple related models. For most data mining projects, you need to create several models, analyze the differences, and compare outputs before you can select a best model to use operationally. Integration Services provides a framework within which you can easily generate and manage ensemble models.

Download the whitepaper from here.

Note: Abstract taken from whitepaper.

Reference:  Pinal Dave (http://blog.SQLAuthority.com)

SQLAuthority News – Whitepaper – Running SQL Server with Hyper-V Dynamic Memory Best Practices and Considerations – Consolidating Databases Using Virtualization Planning Guide

I was recently looking for best practices for Hyper-V and SQL Server and I ended up whitepaper which was published in July earlier this year. I really wish I had come across this whitepaper earlier but any way still it is better to be late then never.

Download Running SQL Server with Hyper-V Dynamic Memory – Best Practices and Considerations

Memory is a critical resource to Microsoft SQL Server workloads, especially in a virtualized environment where resources are shared and contention for shared resources can lead to negative impact on the workload. Windows Server 2008 R2 SP1 introduced Hyper-V Dynamic Memory, which enables virtual machines to make more efficient use of physical memory resources. Hyper-V Dynamic Memory treats memory as a shared resource that can be reallocated automatically among running virtual machines. There are unique considerations that apply to virtual machines that run SQL Server workloads in such environments. This document provides insight into considerations and best practices for running SQL Server 2008 R2 in Hyper-V Dynamic Memory configurations on Windows Server 2008 R2 SP1.

Download Consolidating Databases Using Virtualization Planning Guide

he purpose of this guide is to provide a description of the technologies and best practices utilized to design a database consolidation solution; guidance will be appropriately defined throughout to prescribe configurations and considerations to implement for best results. Documentation of specific tasks will be very limited.

This white paper consider the following three potential strategies:

  • Using a single physical machine to host multiple virtual machines running the Microsoft SQL Server database software
  • Using a single machine to host multiple SQL Server instances
  • Using a single instance of SQL Server to host multiple databases

Note: Above abstract is from Microsoft Official documentation.

Reference:  Pinal Dave (http://blog.SQLAuthority.com)

SQLAuthority News – Download Whitepaper – SQL Server 2008 R2 Analysis Services Operations Guide

SQL Server Analysis Service (SSAS) has been always interesting subject for research. Analysis Services cubes are a very powerful tool in the hands of the business intelligence (BI) developer. They provide an easy way to expose even large data models directly to business users. Microsoft has published very informative white paper on Analysis Services Operations Guide. This white paper is authored by Thomas Kejser, John Sirmon, and Denny Lee.

In this guide you will find information on how to test and run Microsoft SQL Server Analysis Services in SQL Server 2005, SQL Server 2008, and SQL Server 2008 R2 in a production environment. The focus of this guide is how you can test, monitor, diagnose, and remove production issues on even the largest scaled cubes. This paper also provides guidance on how to configure the server for best possible performance. It is the goal of this guide to make your operations processes as painless as possible, and to have you run with the best possible performance without any additional development effort to your deployed cubes. In this guide, you will learn how to get the best out of your existing data model by making changes transparent to the data model and by making configuration changes that improve the user experience of the cube.

Download SQL Server 2008 R2 Analysis Services Operations Guide

Note: Abstract taken white paper.

Reference: Pinal Dave (http://blog.SQLAuthority.com)