Home Forums SQL Server 2014 Administration - SQL Server 2014 proc taking long time to run on occasion. Same when run as script. Sometimes takes forever RE: proc taking long time to run on occasion. Same when run as script. Sometimes takes forever

  • Buffer pool extensions are for the data cache, specifically clean pages, not for memory grants for query execution (which is what resource semaphore waits are for)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass