Post reply

somtimes 'SELeCT getdate()' takes 5 sec to complete

  • January 30, 2015 at 11:34 pm

    #314198

    Hi Everyone,

    We have a sql server 2008 R2, on which 'Select Getdate()' randomly takes long time( 5 second) to complete. Does anybody know what can be the possible issue?

    Regards,

  • January 31, 2015 at 12:24 am

    #1774535

    There can be a thousand reasons. CPU is occasionally pegged to the wall. I/O is occasion pegged to the wall. The "pipe" is occasionally full. Auto-negotiate or half-duplex or both have been setup on a switch or router somewhere in the pipe. The machine you're running it from has a problem with all the windows you have open. They forgot to turn off interactive virus scan. The "pipe" has a bad connection somewhere. The server or your desktop doesn't have enough memory or a chip may be going bad. Some idiot in your company decided to watch streaming video instead of working. A massive deadlock or long duration blocking is occurring. It's a Monday cleverly disguised as a Tuesday. Etc, etc, etc.

    The bottom line is that there could be a serious problem and someone needs to start looking into it. 😉

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • January 31, 2015 at 1:31 am

    #1774541

    Further on Jeff's answer, are you experiencing similar behaviour with other activities on this server? And other servers on the same network?

    😎

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

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