RE: How to verify the query time in SSMS?

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: Changing Query behavior based on local vs. remote context?
    ... And I've tried them on different remote ... machines as well with SSMS and SSMSe, in addition to using queries from the ... query window and "Open Table/View" from the Object Explorer. ...
    (microsoft.public.sqlserver.security)
  • Re: How to verify the query time in SSMS?
    ... I hope someone has good customized query analyzer where I can see the ... Analysis Services and MDX Consultancy: http://www.crossjoin.co.uk ... "Ohjoo Kwon" wrote: ... For example, if I turn on statistics time, I can see the elapsed time of ...
    (microsoft.public.sqlserver.olap)
  • Re: On error in Stored Procedur?
    ... Das SSMS hat schon ein paar gute Features, ... Ich persönlich arbeite inzwischen dort kaum noch mit Tabelle öffnen, ... lasse mir das Script für das Select generieren und benutze vom Script ggf. ... den query designer. ...
    (microsoft.public.de.sqlserver)
  • Properties of DB in SQL 2008 SSMS - Arithmetic overflow
    ... When in SSMS, I right-click and goto properties I get: ... Arithmetic overflow error converting expression to data type int. ... The query that is causing the error is: ...
    (microsoft.public.sqlserver.tools)
  • SSMS 2008 Solution Does Not Remember Passwords
    ... Has anyone been able to get SSMS 2008 remember passwords for individual ... When I open a query in the Solution Explorer, ... dialog pops up with the correct connection but without the password and the ...
    (microsoft.public.sqlserver.tools)