Home Forums Testing Center Question of the Day (QOD) connections sleeping RE: connections sleeping

  • January 28, 2013 at 2:03 am

    #1581467

    Rahim-441309 (1/28/2013)

    U can use

    DBCC FREEPOCCACHE Command to clear them regularly or

    create a job that will do late in the night

    Errr... no. FreeProcCache does nothing to connections, it, as the command's name implies, frees the procedure cache, which is a bad thing on a production server.

    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