Browse by Tags

All Tags » Analysis Services 2005 (RSS)
OLAPQueryLog analysis
We can learn a lot about cube usage and actual aggregation usage from the OLAPQueryLog table. I attached here my demo from Tech Ready 6. In the attached file you can find a Word document which guides you what to do, T-SQL Scripts and SSRS reports. More...
Posted 06 February 2008 02:13 PM by ThePremiers | with no comments
Filed under: , ,
New Best Practices Articles Published - Analysis Services Many-to-Many Dimensions: Query Performance Optimization Techniques
Carl Rabeler, Program Manager in the SQL CAT Best Practices Team publshed a new white paper: Analysis Services Many-to-Many Dimensions: Query Performance Optimization Techniques http://www.microsoft.com/downloads/details.aspx?FamilyID=3494E712-C90B-4A4E...
Posted 26 December 2007 11:15 PM by ThePremiers | with no comments
Filed under: ,
Integrate the Aggregation Manager in Business Intelligence Development Studio
Microsoft provides an Aggregation Manager sample application which gives an advanced interface for manually editing aggregations. We have taken this sample code and integrated it into BIDS Helper. This way, it can be run from Visual Studio when you're...
Posted 22 September 2007 12:41 PM by ThePremiers | with no comments
Filed under: , , ,
Scale-Out Querying with Analysis Services Using SAN Snapshots
Hi Here is a new document from the SQL CAT team: Summary : This SQL Server Best Practices white paper describes the use of virtual copy SAN snapshots in a load-balanced scalable querying environment for Microsoft SQL Server 2005 Analysis Services to increase...
Posted 17 September 2007 11:46 PM by ThePremiers | with no comments
Filed under: , , ,

Search

Go

This Blog

Syndication