My Database is SQL Server 2005. It is having 32Gb ram. In which Sql server taking 28 gb. After investigating why it is taking 28gb ram I came to know BufferPool taking lot of space for dirty page and clean page. Due to access of ram utilization in performance point of view I am facing problem.:doze:
Please can I get any solution on it which solve my problem.:-)
What's the problem you're having? I see that SQL is consuming 28 GB of your 32 GB, but is that really a problem? What's normal for this server?
High memory use is a feature, not a bug. SQL is caching data so it doesn't have to be read from disk the next time the data is needed. It's also caching query plans so they don't have to be rebuilt the next time the query runs. This caching will be flushed out of memory as memory is needed elsewhere. Reading from memory is cheaper than reading from disk, so it wants to cache all it can.
You can adjust the maximum memory you let SQL Server have, but you should know if it's really a problem first.