December 23, 2008 at 4:19 am
I know we can use profiler but not sure if this can cause performance overhead if we run it continously on the production and that's why looking for some good tool
I need to capture usage report for all the user accessing different cubes in AS2005
thanks
SNT
December 23, 2008 at 5:02 am
By default there are the FlightRecorderTrace files that you can reference unless you have turned these off which are stored in the Log directory. These are only available for the last two hours (circular files) or depending on the activity there is a file size limit and that depends on the settings in the SSAS instance properties.
You can also enable the QueryLog and store the information in a table and you might already be doing this to use the information to perform your partition aggregations using the Usage Based Optimization.
Here is a list of options that I pulled from this location - http://ssas-info.com/analysis-services-tools - that you might find useful and I also pulled another project from CodePlex that is useful. The SQL CAT team is working on a project similar to the DMVStats for SQL Server that you will be able to use for SSAS 2008 utilizing all of the nice DMVs that are available now (lot of this you can get using the ASSP project on CodePlex, so you should be able to use with SSAS 2005 also).
Methodology for Monitoring 2005/2008 SSAS Using Profiler trace files
Companion for MS Analysis Server by SQL Minds Inc.
SQL Server Analysis Services 2005/2008 Activity Viewer
ASSP - Analysis Services Stored Procedure Project
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply