November 2, 2017 at 5:54 am
Does anyone know how to monitor or track SSAS Database backups..(need to know current % complete and time to completion)
I used xmla scripts to backup the cube database
November 2, 2017 at 2:34 pm
R.KU.PA_DBA - Thursday, November 2, 2017 5:54 AMDoes anyone know how to monitor or track SSAS Database backups..(need to know current % complete and time to completion)
I used xmla scripts to backup the cube database
I'm not aware of anything other than the Progress Report tracing - which iterates through everything being backed up by objects but doesn't report on percent complete. The Progress Report tracing is available in profiler or extended events.
There are some powershell scripts that do the backup and include the session trace(progress report). You can also fire off extended events sessions in xmla scripts but I'm not sure if you want to try watching those live. The closest I can think of if you want to "view" the live progress using the progress report tracing is to use a Powershell script and run that from the console and monitor the progress. If you want to just see how that works and what you get, you can follow the example in this script:
Backup Ssas Databases with SessionTrace Output
Here is some documentation on using extended events if you are interested in looking at that:
Monitor Analysis Services with SQL Server Extended Events
Sue
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply