SQL Server Performance

Different query costs returned by SET STATISTICS IO ON and sys.dm_exec_query_stats

Discussion in 'SQL Server 2005 General DBA Questions' started by fabi, Jan 7, 2010.

  1. moh_hassan20 New Member

    [quote user="fabi"]I took the number from graphic execution plan from 'this yellow table' when you put the cursor on.[/quote]
    click "include actual execution plan" not display estimated execution plan in ssms , to get real execution numbers, and post the results
  2. fabi New Member

    [quote user="moh_hassan20"]
    click "include actual execution plan" not display estimated execution plan in ssms , to get real execution numbers, and post the results
    [/quote]
    I did it. . This is my screen view. http://img148.imageshack.us/img148/1857/ssms.jpg . I took numbers from yellow table

Share This Page