The powers at be have decided that they would like to automatically run
a trace on one of our analysis servers when it processes a cube in the
early hours of the morning. Now I have no problem creating a SQL
Profile to run and store the results in a database table for them, but
I have no idea how to automate it so that it runs everyday, any help
would be greatly appreciated. My apologises for posting this in forums
Option B - Not sure what information you want to capture from trace but if you are processing your cube using SSIS package you can capture log in database table at package level and cube level both. In cube level log there are many options you can select like sql, start, end time and lot more. This way when your SSIS package will run your database table will also get populated.
-Ashok
|||SP2 is going to come out with little sample application ASTrace. This tiny sample installs as a service and knows how to subsribe to Analysis Services trace and output this trace into SQL Server table.
Drop me a line if you are in urgent need to solve this problem and cant wait for SP2 (which is pretty close).
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
No comments:
Post a Comment