June 20, 2008 at 11:56 am
I'm considering upgrading an Analysis Services instance from Standard to Enterprise Edition and I have this question:
What are the benefits of Enterprise vs. Standard Edition for Analysis Services 2005?
I have looked at this link - http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx - but would like some more info.
Also, is there a difference in CPU/parallelidm utilization in the 2 editions? Is parallelism enabled in the Standard Edition?
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
June 27, 2008 at 12:50 pm
First of all you won't be limited to the number of processors you can utilize on the server. SSAS Enterprise will provide parallel processing capabilities, partitioning your measure groups, creating perspectives, providing SSIS components to process your SSAS objects, semi-additive measures, and proactive caching capabilities (real-time data warehousing):) These are the majority of the major differences. Others include writeback capabilities, synchronization, SSIS fuzzy logic capabilities, etc.
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
June 27, 2008 at 4:00 pm
Dan English (6/27/2008)
First of all you won't be limited to the number of processors you can utilize on the server. SSAS Enterprise will provide parallel processing capabilities, partitioning your measure groups, creating perspectives, providing SSIS components to process your SSAS objects, semi-additive measures, and proactive caching capabilities (real-time data warehousing):) These are the majority of the major differences. Others include writeback capabilities, synchronization, SSIS fuzzy logic capabilities, etc.
Thank you.
I guess I will need to monitor the performance of our SSAS solution for a while before deciding whether it is worth upgrading to the Enterprise Edition.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
June 29, 2008 at 9:19 pm
Well, you can check your Cube(s) (Analysis Services Database) Complexity against Performance.
If you have Many Dimensions and Fact Tables and Millions of Rows and it is a performance hit on your existing Environment, then track and compare its performance against the ENT Version. Parallel Index Operations is a Major Advantage over standard. APS per the comparision: " Provides automated caching for greater scalability and performance "
Maninder
www.dbanation.com
June 30, 2008 at 10:26 am
Mani Singh (6/29/2008)
Well, you can check your Cube(s) (Analysis Services Database) Complexity against Performance.If you have Many Dimensions and Fact Tables and Millions of Rows and it is a performance hit on your existing Environment, then track and compare its performance against the ENT Version. Parallel Index Operations is a Major Advantage over standard. APS per the comparision: " Provides automated caching for greater scalability and performance "
Thank you!
Regarding "Parallel Index Operations": does parallelization come in when the index is being used or when it is being created?
Also, any links you may have in mind would be appreciated.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply