Post reply

Lots of RESOURCE_SEMAPHORE waits with almost no memory granted

  • September 30, 2016 at 7:20 am

    #1904147

    There are a few reasons for this. But sorry, I'm not going to waste my time helping you decipher it while you are on RTM of SQL 2014 and thus TWO AND A HALF YEARS behind on patching. You are missing a TREMENDOUS number of bug fixes, including at least one that is directly related to your wait type.

    http://sqlserverbuilds.blogspot.com/

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • September 30, 2016 at 7:55 am

    #1904159

    So, is this a bug in SQL Server itself?

    OK, we'll update and see if the problem persists.

  • September 30, 2016 at 10:15 am

    #1904209

    v.bartosh (9/30/2016)

    So, is this a bug in SQL Server itself?

    OK, we'll update and see if the problem persists.

    I am not saying what you are seeing is related to a bug. I am saying that you are completely out of date in your patching. So what you are seeing could very well be something that has been patched since your RTM build.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

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

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