Re: How to verify the query time in SSMS?

I mean I'd like to see the MDX query elapsed time in SSMS directly.

For example, if I turn on statistics time, I can see the elapsed time of SQL
query.

Any ideas?

"Chris Webb" <onlyforpostingtonewsgroups@xxxxxxxxxxxxxxx> wrote in message
news:6B0DBD41-3189-4627-8A60-E403FE2D6012@xxxxxxxxxxxxxxxx
Have you tried looking a the Query Begin and Query End events in Profiler?
Do
you think that SSMS isn't showing the correct results?

--
Chris Webb, MVP
Analysis Services and MDX Consultancy: http://www.crossjoin.co.uk
Blog: http://cwebbbi.spaces.live.com/


"Ohjoo Kwon" wrote:

Hi all,

Is there any way to verity the elapsed time when MDX query is executed in
SSMS?

Thanks in advance,

Ohjoo





.

Relevant Pages

  • Re: How to verify the query time in SSMS?
    ... Analysis Services and MDX Consultancy: http://www.crossjoin.co.uk ... For example, if I turn on statistics time, I can see the elapsed time of SQL ... you think that SSMS isn't showing the correct results? ... Is there any way to verity the elapsed time when MDX query is executed in ...
    (microsoft.public.sqlserver.olap)
  • How to verify the query time in SSMS?
    ... Is there any way to verity the elapsed time when MDX query is executed in ... SSMS? ... Ohjoo ...
    (microsoft.public.sqlserver.olap)
Loading