Post reply

Writes in select statement

  • August 16, 2016 at 11:26 pm

    #310611

    Hi,

    Sometimes when I ran the profiler, I can see some select statement with Writes as well. Is that normal?

    Thanks,

  • August 16, 2016 at 11:56 pm

    #1895836

    yujinagata72 (8/16/2016)

    Hi,

    Sometimes when I ran the profiler, I can see some select statement with Writes as well. Is that normal?

    Thanks,

    Perfectly normal.

    😎

  • August 17, 2016 at 7:34 am

    #1895917

    Yep, and could come from a number of causes. One of the easiest to explain is that you have a Spool operation which is writing out to tempdb. Another is that you have a hash match that is too big for memory (or exceeded the estimated amount of memory needed) and is now spilling to disk. Take a look at the execution plan to understand what might be going on.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply