SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

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

James Serra's Blog

James is a big data and data warehousing technology specialist at Microsoft. He is a thought leader in the use and application of Big Data technologies, including MPP solutions involving hybrid technologies of relational data, Hadoop, and private and public cloud. Previously he was an independent consultant working as a Data Warehouse/Business Intelligence architect and developer. He is a prior SQL Server MVP with over 30 years of IT experience. James is a popular blogger (JamesSerra.com) and speaker, having presented at dozens of PASS events including the PASS Business Analytics conference and the PASS Summit. He is the author of the book “Reporting with Microsoft SQL Server 2012”. He received a Bachelor of Science degree in Computer Engineering from the University of Nevada-Las Vegas.


Leave a comment on the original post [www.jamesserra.com, opens in a new window]

Loading comments...