I’m starting to look at using a data warehouse and would like to have some
tracking of the queries ran against the data warehouse.

I’ve gone through several articles about the MS Access database msmdqlog.mdb
and I’m just looking for ways to implement the auditing and I have a few
questions.

I guess the easy thing is to generate reports from the Access database using
Access itself to help me figure out if who is looking at the data, how long
it takes the queries to run… But my real question is are there better things
to do with it.

I read that it might be best to migrate the logging away from Access and
into SQL Server directly but following that thought it lead me to some horror
stories about the many registry entries that need to be modified and the
pains encountered when updating service packs and the like. Seemed that
Analysis Services was tied in many ways to the msmdqlog.mdb for this type of
auditing.

I was also considering the possibility of creating a cube in the data
warehouse based on the QueryLog table from the msmdqlog.mdb

What are some of the prevailing ways to report on usage statistics from
Analysis Services?

Thanks for any help.

Larry

The query log is NOT what you are looking for. It was designed exclusively
to be used as a data source for usage-based optimization. It is not a
general-purpose facility. Use it at your own risk. There is no guarantee
that every query is logged and if you look at the details you will see that
what is logged is really aggregate usage, i.e. the artifacts of a query; not
queries themselves.

Can you give us a sense of what kind of auditing? If it is just users coming
onto the system, then look at the AuditLogin registry documented here:
http://msdn.microsoft.com/library/de...egsettings.asp

--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

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

Larry,

Follow the articles

http://www.sqlservercentral.com/colu...isservices.asp
and
http://www.sqlservercentral.com/colu...dimensions.asp

Ramunas


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