Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

James Serra's Blog

James is currently a Senior Business Intelligence Architect/Developer and has over 20 years of IT experience. James started his career as a software developer, then became a DBA 12 years ago, and for the last five years he has been working extensively with Business Intelligence using the SQL Server BI stack (SSAS, SSRS, and SSIS). James has been at times a permanent employee, consultant, contractor, and owner of his own business. All these experiences along with continuous learning has helped James to develop many successful data warehouse and BI projects. James has earned the MCITP Business Developer 2008, MCITP Database Administrator 2008, and MCITP Database Developer 2008, and has a Bachelor of Science degree in Computer Engineering. His blog is at .

SQL Server 2012: SSAS enhancements

My previous blog, SQL Server 2012 (“Denali”): Details on the next version of SSAS, talked about the major new feature in SSAS, which is BISM.  But what other changes are there?  Well, not much.  Here are details on the few changes I have found:

  • All development work is now done in Visual Studio 2010, with BIDS replaced by SQL Server Data Tools (SSDT)
  • String stores in dimensions attributes or partitions has a 4 GB maximum file size per store (strings are stored separately from numeric data to allow for optimizations based on characteristics of the data).   If your dimensions or partitions include string stores of this size, you can work around the file size constraint by changing the string storage architecture to the new “scalable string storage”.   The maximum limit for scalable string storage is 4 billion unique strings or 4 billion records, whichever occurs first
  • Queries that include DistinctCount in a ROLAP process can run faster, assuming certain criteria are met
  • NUMA is now supported, allowing for more than 64 processors
  • You can now use SQL Server Extended Events (XEvents) to monitor Analysis Services
  • New Profiler events: Resource Usage (you can capture the number of reads or writes, reads or writes as measured in kilobytes, CPU time in milliseconds, rows scanned, and rows returned)
  • New Trace events:  Locks Acquired, Locks Released, and Locks Waiting
  • New Analysis Services PowerShell provider and cmdlet

More info:

What’s new in Analysis Services 2012 Multidimensional?

[SQLServer 2012] Analysis Services New Feature : Scalable String Storage

Analysis Services Thread Pool Changes in SQL Server 2012

Analysis Services 2012 Faster Processing

Analysis Services PowerShell Provider (SQLAS) in SQL Server 2012


Leave a comment on the original post [, opens in a new window]

Loading comments...