ANN: 25% discount on Upscene products during our spring sale!

Upscene Productions announces a Spring Sale with 25% discount on all
database developer tools!
Currently available from Upscene Productions:
Database Workbench
A multi-database engine development IDE, currently supporting Microsoft SQL
Server, Oracle, InterBase, Firebird, MySQL and NexusDB.
IB LogManager Suite
An auditing/logging suite for InterBase & Firebird.
MSSQL LogManager Suite
An auditing/logging suite for Microsoft SQL Server.
ADS LogManager Suite
An auditing/logging suite for Advantage Database.
NDB LogManager Suite
An auditing/logging suite for NexusDB.
Advanced Data Generator
A comprehensive test data generator tool with support for ADO/ODBC
connectivity or specialized versions for InterBase, Firebird or MySQL.
InterXpress for Firebird
A dbExpress driver for Firebird supporting Delphi 6 - 2006 and Kylix 3.
When purchasing, enter coupon code SPRINGSALE2006 to get your discount.
More information about Upscene Productions products at
http://www.upscene.comModerator please delete this spam.
"Martijn Tonies" wrote:
> Upscene Productions announces a Spring Sale with 25% discount on all
> database developer tools!
> Currently available from Upscene Productions:
> Database Workbench
> A multi-database engine development IDE, currently supporting Microsoft SQL
> Server, Oracle, InterBase, Firebird, MySQL and NexusDB.
> IB LogManager Suite
> An auditing/logging suite for InterBase & Firebird.
> MSSQL LogManager Suite
> An auditing/logging suite for Microsoft SQL Server.
> ADS LogManager Suite
> An auditing/logging suite for Advantage Database.
> NDB LogManager Suite
> An auditing/logging suite for NexusDB.
> Advanced Data Generator
> A comprehensive test data generator tool with support for ADO/ODBC
> connectivity or specialized versions for InterBase, Firebird or MySQL.
> InterXpress for Firebird
> A dbExpress driver for Firebird supporting Delphi 6 - 2006 and Kylix 3.
> When purchasing, enter coupon code SPRINGSALE2006 to get your discount.
> More information about Upscene Productions products at
> http://www.upscene.com
>
>
>
>

Analyzing MDX query evaluation

Are there any tools or tricks for looking at how an MDX query is evaluated in SSAS 2005? Something that indicates how aggregations are being used, for example - sort of like a SHOWPLAN for MDX.
As you might know, AS 2005 MDX query execution events are now captured in SQL Server Profiler. What's not as clear from the docs (that I've come across, anyway) is the aggregation usage info available via SQL Profiler. This was well explained at the recent SQL PASS Conference, in Session 108: "Understanding Analysis Services 2005 Aggregations from Every Angle", by Dave Wickert and Len Wyatt:

>>
SQL Profiler

Will tell you when:
an aggregation is used for a query
the partition data is used for a query

It won’t tell you why it decides to use or not use a particular aggregation

§>>

|||Deepak,
Thanks, that sounds very promising. Do you know where I can find more information about using Profiler for this purpose? That SQL PASS session doesn't appear to be downloadable (that I can find, at least), and the documentation isn't much help here (as you point out).
Thanks,
Kevin
|||Hi Kevin,

If you're a PASS member, then the presentation slides should be downloadable, or you can order the physical media with MP3 sound. Now maybe Dave and Len are making their presentation (or equivalent info) available elsewhere - don't know!

http://www.softconference.com/250927
>>

CO1: Compilation CD-ROM set with full desktop capture - MP3 audio including live demos and PowerPoints (for attendees of the 2005 PASS Summit) CDROM (Attendees only) $ 195.00 CO2: Compilation CD-ROM set with full desktop capture - MP3 audio including live demos and PowerPoints (for members of PASS who did not attend the 2005 Summit) CDRom (Members only) $ 395.00 CO3: Compilation CD-ROM set with full desktop capture - MP3 audio including live demos and PowerPoints (for non-attendees, non-members of PASS) CDRom $ 595.00

>>

Analyzer Tools

Hi,
Is there any tools can help me doing the analysis using SQL Profiler (trc)
files?
Thanks,
Kenny
See if my scripts can help:
http://vyaskn.tripod.com/analyzing_profiler_output.htm
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Kenny" <keejh@.hotmail.com> wrote in message
news:uu5r9EZFFHA.3728@.TK2MSFTNGP14.phx.gbl...
Hi,
Is there any tools can help me doing the analysis using SQL Profiler (trc)
files?
Thanks,
Kenny
|||See read80trace.exe
http://support.microsoft.com/default...b;en-us;887057
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright SQLDev.Net 1991-2005 All rights reserved.
"Kenny" <keejh@.hotmail.com> wrote in message
news:uu5r9EZFFHA.3728@.TK2MSFTNGP14.phx.gbl...
> Hi,
> Is there any tools can help me doing the analysis using SQL Profiler (trc)
> files?
> Thanks,
> Kenny
>
|||Kenny wrote:
> Hi,
> Is there any tools can help me doing the analysis using SQL Profiler
> (trc) files?
> Thanks,
> Kenny
You can check out our Coefficient product (14-day free trial available).
David Gugick
Imceda Software
www.imceda.com