Report Portal

Basic OlapQueryLog Analysis

SSAS can log query execution information to a relational database. This Transact-SQL script provides a basic query which split the object path data to

  • server name
  • database ID
  • cube ID
  • measure group ID (!always the ID, not the friendly name!)
Further it calculates the granularity, count of cube dimensions & attributes With the basic query you can analyse query executions, like e.g.
  • overview query executions + total duration per object path
  • long / often running queries
  • execution history
  • how often hits a query the cache (duration = 0)
  • daily usage per server
  • and so on.
Remove the comments of the statement of your interest.

Read more...

Tags: management, performance, script

 

2007-2015 VidasSoft Systems Inc.