dbTalk Databases Forums  

Re: AS usage analysis

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Re: AS usage analysis in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Tom Chester
 
Posts: n/a

Default Re: AS usage analysis - 09-23-2003 , 12:06 PM






David, the usage is not stored in the repository -- it's in a separate .mdb
named msmdqlog.mdb located in bin directory. It contains just one table
(last time I looked). You will need to do some deciphering. It logs which
levels of which dims were queries, not the actual query.

tom @ the domain below
www.tomchester.net


"david wilson" <david.wilson (AT) rmc (DOT) co.uk> wrote

Quote:
Are there any nice utilities out there for reporting on
usage stats. The one provided in the AS mmc is a little
limited to say the least.
I have logging set to every query for a short while &
would like to really analyze usage.
Our repository is migrated to SQL - can i get at the table
where these stats are stored?



Reply With Quote
  #2  
Old   
Mosha Pasumansky [MS]
 
Posts: n/a

Default Re: AS usage analysis - 09-23-2003 , 12:40 PM






More details about Query Log can be found in the article originally
published at http://www.txsqlusers.com/howto/OLAP...00/Default.htm by and
now mirrored at

http://www.mosha.com/msolap/articles/querylog.htm

--
==================================================
Mosha Pasumansky - www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.