Post reply

Performance Tuning

  • July 13, 2010 at 2:02 am

    #235101

    i have 8 gb ram and i checked SQLserver.exe peocess is taking 6 gb memory, how wud i knw which process in sql server taking this much memory???

  • July 13, 2010 at 4:57 am

    #1191902

    No single process will be using the memory. SQL uses most of its memory for the buffer pool and plan cache. This is normal and nothing to worry about. SQL uses a lot of memory, the more it can use, the better.

    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

  • July 15, 2010 at 9:42 am

    #1193588

    Just a doubt... if I use DBCC DROPCLEANBUFFERS and DBCC FREEPROCCACHE to clean up buffer and plan cache….should It affects on memory uses

    Regards,
    Shivrudra W

  • July 15, 2010 at 10:06 am

    #1193602

    It won't reduce the amount of memory that the SQL process is using. It just marks internal buffers as clear, making SQL repopulate them as it needs.

    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

  • July 16, 2010 at 12:44 am

    #1193904

    Thanks

    Regards,
    Shivrudra W

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

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