Feeds:
Posts
Comments

Posts Tagged ‘Performance’

ExecutionLog2 View – Analyzing and Optimizing Reports

Posted in Reporting Services, tagged on January 8, 2009 | Leave a Comment »

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 [...]

Read Full Post »

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

Posted in Reporting Services, Uncategorized, tagged , on October 24, 2008 | Leave a Comment »

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 [...]

Read Full Post »

Reporting Services Scale-Out Deployment Best Practices

Posted in Reporting Services, tagged on October 22, 2008 | Leave a Comment »

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 [...]

Read Full Post »

Top 10 SQL Server Integration Services Best Practices

Posted in Integration Services, tagged on October 3, 2008 | Leave a Comment »

Check out my latest paper: Top 10 SQL Server Integration Services Best Practices.  We had written this paper based on the many enteprise SSIS issues we encountered and we should have covered most of "main" issues.  Enjoy!

Read Full Post »

Reporting Services Performance and Scalability Technical Notes

Posted in Reporting Services, tagged on July 1, 2008 | Leave a Comment »

Over the next few months, I will be publishing a series of technical notes on sqlcat.com that provide guidance on how to build and deploy large scale SQL Server Reporting Services environments.  This series provides general guidance on how to set up, implement, and optimize an enterprise scale-out architecture for your SQL Server Reporting Services (SSRS) environment; [...]

Read Full Post »

Analysis Services Distinct Count Optimization

Posted in Analysis Services, tagged , on April 17, 2008 | Leave a Comment »

Finally, after about 7 months of analysis, customer validation, and just general randomization – I have finally propped up the Analysis Services Distinct Count Optimization whitepaper which is available here: http://sqlcat.com/whitepapers/archive/2008/04/17/analysis-services-distinct-count-optimization.aspx . Quick summary of this whitepaper: Distinct count (such as unique visitor counts on a Web site) calculations provide valuable information but come with [...]

Read Full Post »

« Newer Posts

Follow

Get every new post delivered to your Inbox.

Join 1,049 other followers