I assume the recommended approach for setting up the query log in SSAS2005 is
to write it to a SQL Server database. I have a couple of questions about best
practices...

1. Is msdb the suggested database to put it in?

2. If SQL Server (relational) service isn't started by the time that
analysis services service tries to start, you get an error that it can't
connect to the query log. Is the best practice to make SSAS service dependent
upon the SQL relational service to ensure it's started before SSAS starts?

i recommand to use a dedicated database for sizing reason.
regarding the volume of log you expect, the database size will growth
quickly and the backup should be created correctly.
so using msdb can provide issues for you other applications (like SSIS);
specially if you have to restore the database!

to add some precedence in the services try to add a key in the registry:
HKLM\system\currentcontrolset\services\MSOLAP
DependOnService (multi string value) = MSSQLSERVER

(search for sample values, or the SQLSERVERAGENT registry key values)


"FurmanGG" <FurmanGG (AT) discussions (DOT) microsoft.com> wrote