changing assigned sql memory - any impact?

  • I was in an impression that if i change the assigned sql memory it shouldn't impact any online operation. However i was surprised to see this message 'SQL Server has encountered 1 occurrence(s) of cachestore flush for the 'SQL Plans' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.

    ' right after i changed the memory. Did it flush all the plans after i changed the memory? This is on SQL 2005 64 bit standard edition.

  • Yes, modifiying min or max server memory will flush cache memory.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply