To determine how much memory your SQL Server database uses for buffer cache and procedure cache, factor in the SQL version you're using, whether it's x86, x64 or Itanium and the amount of memory allocated to the SQL Server instance. SQL Server expert Denny Cherry lays out how the system configures memory and how to allocate the amount of buffer and procedure cache that's available.
Source Click Here.
Post a Comment