January 10, 2013 at 10:59 am
Hello ALL,
http://www.mssqltips.com/sqlservertip/2393/determine-sql-server-memory-use-by-database-and-object/
From the following article at the final result, we see the object with indexes has high buffer pages. So, now what is
the next step we need to do when we see an object using lot of buffer pages and lot of memory.
January 10, 2013 at 11:56 am
Well... the next step would be to figure out whether high buffer page usage by that object is a problem or not. If it's a large table that's frequently read, you would want it to be in memory, as the alternative is slow access from disk.
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
January 10, 2013 at 12:14 pm
Thanks Gila. The object which has high buffer is required. It is from a very large DB (4TB). But by this I am seeing 96% of memory usage on my server. I have already registered 14GB of memory. It is on prod. and no idea how can i resolve this issue.
January 10, 2013 at 12:17 pm
High memory usage from SQL is a good thing. SQL uses memory to cache data and to cache plans. Both of those allow for better performance than if it didn't have those caches.
If SQL is using too much memory, lower max server memory slightly.
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
January 10, 2013 at 3:47 pm
Sounds Good.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply