Hi

I was hoping an MVP could clarify the following: Does the query log and the
usage based optimization work on 64 bit SSAS 2000?

For some reason, the log is showing up empty. I have the 'boxes' checked in
the SSAS properties manager and the log count set to every 10th query. But I
get no logged queries.

Any ideas?

thx
Avi

do you log into the Access database or to an SQL Server database?

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

all 64 bit installations go to SQL Server by default. The connection string
(as set by the install) is

Provider=SQLOLEDB.1;Integrated Security=SSPI;Initial
Catalog=OLAPQueryLog;Data Source=myServer;Use Procedure for Prepare=1;Auto
Translate=True;Packet Size=4096;Use Encryption for Data=False;Tag with column
collation when possible=False

"Jeje" wrote:

do you see any security error in the event log?
does the account used to run the AS Service is allowed to write in the
database?
do you see any access using the SQL profiler?

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

Thx Jeje

as far as I can tell the accounts have security access. I am finding it it
hard to track the sql activity via the profiler.

nothing exactly related in the event logs either.

any other ideas? registry settings?

thx

"Jeje" wrote:

tracking using the profiler is simple.
to simplify the process, add this in the connection string:
Application Name=OLAPLog

then in the profiler, start a new session where you filter event for the
application name "OLAPLog" only.
and you'll see only the right events.


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

Jeje

Of course, nothing shows up!!!...I'm not surprised, since I think this is
the crux of the problem. For whatever reason, SSAS is not writing the logs to
the specified server.

So back to square one

Avi

"Jeje" wrote: