Home Forums SQL Server 2005 T-SQL (SS2K5) Tiny virtual machine outperforms a big physical box? RE: Tiny virtual machine outperforms a big physical box?

  • March 19, 2010 at 9:17 pm

    #1137116

    Roust_m (3/15/2010)

    Sorry, I got one thing wrong here, the execution time is about the same for 5 records on both servers if I use:

    SET STATISTICS TIME ON

    SET STATISTICS IO ON

    If I remove these lines, then the execution time on the test server is greater and corresponds with the avg_worker_time

    The reason I asked about the trace is because calling a function causes extra events to be raised - which correspond to setting these options on.

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi