MS SQL Server OLAP - Querylog in SQL Server

Author

Querylog in SQL Server

ktrock

2006-03-24, 8:26 pm

Can anyone run a usage based analysis against a querylog that's in SQL
Server? Mine won't come up. Not that it would be of much use. Long queries
that I've been runinng in the MDX Sample app are showing up witha duration of
0 anyway; and I'm logging every query.

I tried going to Access by editing the QueryLogConnectionSt
ring registry
entry and building the msmdqlog.mdb myself with little luck. Any ideas?

Thanks,
Ken Trock
Verizon Wireless

Ramunas Balukonis

2006-03-28, 7:29 am

Hi,
if you are talking about 2000, please refer to article.

http://www.sqlservercentral.com/col...> sservices.asp

Ramunas Balukonis

"ktrock" <ktrock@discussions.microsoft.com> wrote in message
news:AA7BD55F-22DB-4056-AA75- 7C0735738331@microso
ft.com...
> Can anyone run a usage based analysis against a querylog that's in SQL
> Server? Mine won't come up. Not that it would be of much use. Long queries
> that I've been runinng in the MDX Sample app are showing up witha duration
of
> 0 anyway; and I'm logging every query.
>
> I tried going to Access by editing the QueryLogConnectionSt
ring registry
> entry and building the msmdqlog.mdb myself with little luck. Any ideas?
>
> Thanks,
> Ken Trock
> Verizon Wireless

Sponsored Links