Basically what I mean is that for parallel queries the total_elapsed_time will not be the time taken by the query to complete its execution (or its response time). Its actually...

Just found out that both sys.dm_exec_sessions and sys.dm_exec_requests return incorrect total_elapsed_time for parallel queries (requests with parallel execution plans). Is this a defect or a misunderstanding on my part?

So it...

Grant

The problem is that waitfor is shown as a part of the query when i get the query text from the sql_handle. And as I mentioned there are separate sql_handles...

Thanks again for your help.

I was not actually focused on indexed views, I just want to provide the database engine tuning wizard functionality through my application. i.e. the application should...

Thanks for your replies.

I am curious to know how Database engine tuning advisor recommends indexed views. What does it look for in the query? I must say I haven't played...

Further elaboration.

I use telnet to gather some machine/OS statistics because I cant use xp_cmdshell. And I need to gather statistics programmatically (not manually) from both the nodes (active and passive)...

Ok. I need to elaborate a little.

I have a clustered environment in which an SQL server is setup on two nodes. I want to connect to the active node through...

I assume that we will not be able to get the RAC metrics from SQL Server because in SQL Server failover clusters, two nodes do not communicate with each other...