July 11, 2013 at 9:02 am
I observed that in my Production Server (SQL Server 2005)
PF Usage: 496 GB
Total RAM: 511 GB
Available RAM: 8 GB
Database Size: 1 TB
SQL Server process (SQLSVRVR.EXE) MEMORY USAGE in Task Manager: 493 GB
ist it normal ? or we need to take any action. Can you please any one suggest me ?
July 12, 2013 at 1:51 am
Yep it is absolutely normal, any data that need to be read or written has to work on memory and it will cache as much as possible in memory to avoid physical I/O and to ensure it doesn't consume all of the memory you can limit the max memory so some RAM is spared for minimal OS processes to avoid any bottlenecks.
July 12, 2013 at 11:49 am
+1.
Set a max memory, but SQL will take all it can get if you let it.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply