Post reply

Viewing SQL Code Generated When Hyperion Writes to SQL Server

  • November 25, 2010 at 1:42 pm

    #231928

    I have a Hyperion Essbase implementation. It is an OLAP Database, but uses relational RDBMS to keep application metadata such as provisioning information, configuration settings etc. Now Hyperion is constantly writing to, and reading from SQL Server. Does anybody here know how to view the SQL code that is executed when Hyperion writes to SQL Server? Or generally speaking when any application writes to SQL Server, where can I see that SQL code? I'm hoping it's somewhere within SQL Server, which is why I'm posting this question on this forum.

    Happy Thanksgiving!

  • November 25, 2010 at 2:01 pm

    #1255649

    You could create a server side trace and catch all these calls.

    Or you can use the DMV dm_exec_requests join with dm_exec_sessions join with dm_exec_query_plan. This one will give the session that are currently active.

    But the best bet would be Server Side trace.

    -Roy

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply