October 25, 2010 at 9:45 am
What tools can I use to monitor and optimize the processing of an SSAS database?
I am a DBA who knows very little about the actual structure and data of the cube and dimensions in the database.
Is there an efficient way to identify red flags (in terms of performance) during the processing phase and work with the developers to fix those?
__________________________________________________________________________________
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]
October 25, 2010 at 11:11 pm
I have not come across any standard tool for SSAS so far... but you can monitor performance in profiler by starting new trace and capturing related events. Mainly facts take lot of time so you can concentrate on finding time taken by each fact/partition. If anyone is using some tool, please share the details.
Thanks,
Amit G
http://www.msbiconcepts.com
October 26, 2010 at 8:06 am
amit_gupta01 (10/25/2010)
I have not come across any standard tool for SSAS so far... but you can monitor performance in profiler by starting new trace and capturing related events. Mainly facts take lot of time so you can concentrate on finding time taken by each fact/partition. If anyone is using some tool, please share the details.
Thanks, I will certainly share it here if I come across anything.
I wish there was a book out there on Analysis Services aimed at DBAs; so far everything I have seen is targetting developers with some admin stuff thrown in, but IMO nothing substantial.
I am using the SQL Sentry Performance Advisor to monitor SSAS performance; great tool, but - in my view - thin on documentation.
Another tool are the new Dynamic Management Views for SSAS in SQL 2008.
I hope that there will be more focus on DBA side of SSAS in terms of books, blogs etc. in the future...
__________________________________________________________________________________
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 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply