The Ultimate SQL Data Loading Performance Guide

For all of you whom wanted to know about how to load data within SQL Server, please refer to the "Ultimate" SQL Data Loading Performance Guide at: http://sqlcat.com/whitepapers/archive/2009/02/15/the-data-loading-performance-guide-2008.aspx   This document described techniques for bulk loading large data sets into SQL Server. It covers both the available techniques as well as methodologies to performance tune and optimize the bulk loading process.   Enjoy!  

Rate this:

Reporting Services Performance Optimization

The final technical note as part of the Building and Deploying Large Scale SQL Server Reporting Services Environments technical note series on Reporting Services Performance Optimization has just been published at Reporting Services Performance Optimization.   This technical note provides guidance on the reasons to use 64-bit, how to handle large workloads, Monitoring Reporting Services (which includes a link to a sample SSRS project to view the ExecutionLog2 view), and Memory Configurations.   Enjoy!    

Rate this:

ExecutionLog2 View – Analyzing and Optimizing Reports

An excellent blog explaining the ExecutionLog2 view within Reporting Services has been written by Robert Bruckner at: http://blogs.msdn.com/robertbruckner/archive/2009/01/05/executionlog2-view.aspx   Quoted from Robert: Before you can optimize particular reports or your entire system, you need metrics and understand what they tell you.  In this posting, I want to focus on how to effectively interpret and utilize the data present in the new ExecutionLog2 view in the Reporting Services 2008 catalog database.     

Rate this:

Reintroducing Usage-Based Optimization in SQL Server 2008 Analysis Services

With the release of the SQL Server 2008 Analysis Services, there is the new and improved version of the Usage-based Optimization algorithm.  The best practices and recommendations to use this feature can be found out this recently published technical note Reintroducing Usage-Based Optimization in SQL Server 2008 Analysis Services.   Enjoy!  

Rate this:

Reaching Compliance: SQL Server 2008 Compliance Guide

Organizations across the globe are being inundated with regulatory requirements. They also have a strong need to better manage their IT systems to ensure they are operating efficiently and staying secure. Microsoft is often asked to provide guidance and technology to assist organizations struggling with compliance. The SQL Server 2008 Compliance Guidance white paper was written to help organizations and individuals understand how to use the features of the Microsoft® SQL Server® 2008 database software to address their compliance needs. This paper serves as an accompaniment to the SQL Server 2008 compliance software development kit (SDK), which provides sample code…

Rate this:

Technet Webcast: Building SQL Server Reporting Services 2008 Large-Scale Solutions

Check out my Technet webcast on Building SQL Server Reporting Services 2008 Large-Scale Solutions.   In this webcast, you learn about successful configuration and architecture principles to maximize the scalability of your enterprise Microsoft SQL Server 2008 Reporting Services (SSRS) environment. Join us as we provide you details, based on real customer scenarios, on how to make the most of your SSRS 2008 environment. Have fun!    

Rate this:

Reporting Services Scale-Out Deployment Best Practices

Check out the the third of five technical note as part of the Building and Deploying Large Scale SQL Server Reporting Services Environments Technical Note Series: Reporting Services Scale-Out Deployment Best Practices This technical note reviews the SSRS Scale-Out Architecture Report Catalog sizing The benefits of File System snapshots for SSRS 2005 Why File System snapshots may not help for SSRS 2008 Using Cache Execution Load Balancing your Network Isolate your workloads Report Data Performance Considerations  Enjoy!  

Rate this: