Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
We are looking to continuously run server side trace on Analysis Services and record its output in a table in database in the Database Services.
There are tons of articles showing server side trace for Database Services but I have yet to find one for Analysis Services.
Any suggestions on where to start recording and automating server-side traces for Analysis Services to run always?
maybe you can setup the query log in the ssas instance properties.
It depends on what kind of data you want to Capture.
I've just set up tracing as @MBuschi has suggested, but IMO it's pretty limited. To enable it I reccomend you create a small database for it to write to, and change the flag show above for "CreateQueryLogTable" to true. You also need to provide the connection string to your logging location, and the login you provide needs enough credentials to create the table. Then just restart SSAS. It should create the table and start logging for you. Here's the offical doco
I've also been playing with Extended events, and learned how to start and stop a session via script. Extended events give you a lot of configuration flexiblity to target specific technical details.
The most useful thing i've found so far are the flight recorder files stored in your SSAS Data or log directory. (Maybe I just prefer the layout of them). However these files overwrite themselves. So although they are useful for diagnosis, they're not ideal for long term logging.
