May 21, 2014 at 4:04 pm
How de we know that sql server 2008 needs additional memory? However, I will be looking at PLE, Buffer cache and procedure catch. In other words, I need metrics to identify the memory is needed on the server.
Thanks
May 21, 2014 at 4:07 pm
You can usually identify that you need more memory if you can see that you are experiencing memory pressure.
This is an article that helps to identify memory pressure
And this one
http://www.sqlskills.com/blogs/jonathan/how-much-memory-does-my-sql-server-actually-need/
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply