One of the production servers I maintain crashed and I saw this error in the log viewer.This server was recently upgraded to SQL Server 2008 R2.
To fix this I had to cap the max memory usage for this database server at 29 GB. The max was set to less than the Windows Server 2008 memory which is 32 GB.Since then I have not had issues with the database server.
Also applied the service pack 2 which is available here
http://support.microsoft.com/kb/2527041
To fix this I had to cap the max memory usage for this database server at 29 GB. The max was set to less than the Windows Server 2008 memory which is 32 GB.Since then I have not had issues with the database server.
Also applied the service pack 2 which is available here
http://support.microsoft.com/kb/2527041
No comments:
Post a Comment