SQL SERVER – Microsoft White Papers – Analysis Services Query Best Practices – Partial Database Availability

Microsoft TechNet frequently releases White Papers on SQL Server Technology. I have read the following two white papers recently. The summary of its content is here.

Analysis Services Query Performance Top 10 Best Practices

  1. Optimize cube and measure group design
  2. Define effective aggregations
  3. Use partitions
  4. Write efficient MDX
  5. Use the query engine cache efficiently
  6. Ensure flexible aggregations are available to answer queries.
  7. Tune memory usage
  8. Tune processor usage
  9. Scale up where possible
  10. Scale out when you can no longer scale up

Partial Database Availability

Writer: Danny Tambs
Download Word Document

As databases become larger and larger, the infrastructure assets and technology that provide availability become more and more important. The database filegroups feature introduced in previous versions of SQL Server enables the use of multiple database files in order to host very large databases (VLDB) and minimize backup time. In SQL Server 2005 specific files can be set to offline or online.

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

About these ads

3 thoughts on “SQL SERVER – Microsoft White Papers – Analysis Services Query Best Practices – Partial Database Availability

  1. Hi pinal,

    Presently, I have set up a server machine for SQL2K5 – Analysis Services with Service Pack 2 where OS is WINDOWS Server 2003, as per guidelines given on following Microsoft’s site http://technet.microsoft.com/en-us/library/cc197552.aspx.

    But I observed that whenever I create a new Analysis Service database the repository database is not getting refreshed?

    Can you please help me out in solving this query?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s