Microsoft Download Center Archive

Analysis Services Distinct Count Optimization

  • Published:
  • Version: 1.0
  • Category: Document
  • Language: English

This whitepaper provides optimization techniques for Analysis Services Distinct Count

  • Distinct count (such as unique visitor counts on a Web site) calculations provide valuable information but come with a number of performance challenges. This white paper describes tests that were performed to determine how best to optimize these calculations and includes best practices based on the test results.


Status: Live

This download is still available on The downloads below will come directly from the Microsoft Download Center.

FileSHA1 HashSize
SSASDistinctCountOpt.docx5c2813a797dfe00deab0ad969b0a5ac48d22c813230 KB

File sizes and hashes are retrieved from the Wayback Machine’s indexes. They may not match the latest versions of files hosted on Microsoft servers.

System Requirements

Operating Systems: Windows Server 2003, Windows Server 2008, Windows Vista, Windows XP

  • Microsoft Word 2007

Installation Instructions

  • Click Save to save the document to your hard disk
    Click Open to open the document immediately