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
- Optimize cube and measure group design
- Define effective aggregations
- Use partitions
- Write efficient MDX
- Use the query engine cache efficiently
- Ensure flexible aggregations are available to answer queries.
- Tune memory usage
- Tune processor usage
- Scale up where possible
- 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 (https://blog.sqlauthority.com)
3 Comments. Leave new
Very good blog, very rich and nice pictures and articles, congratulations !!!
Dave,
I love your web site very much. Can you give the sample by
screen shot, then I can understand better.
JC
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 https://docs.microsoft.com/en-us/previous-versions/office/project-server-2007/cc197552(v=office.12).
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?