资源池 'default' 没有足够的系统内存来运行此查询。
mssql2008 R2+win2008 64位 [/code]
Last Notification 2
51:18. spid53 错误: 701，严重性: 17，状态: 123。
51:18. spid53 There is insufficient system memory in resource pool 'default' to run this query.
51:18. spid53 错误: 701，严重性: 17，状态: 123。
51:18. spid53 There is insufficient system memory in resource pool 'default' to run this query.
51:18. spid53 错误: 701，严重性: 17，状态: 123。
51:18. spid53 There is insufficient system memory in resource pool 'default' to run this query.
51:18. spid53 错误: 701，严重性: 17，状态: 123。
51:18. spid53 There is insufficient system memory in resource pool 'default' to run this query.
51:18. spid53 错误: 701，严重性: 17，状态: 123。
51:18. spid53 There is insufficient system memory in resource pool 'default' to run this query.
51:18. spid53 错误: 701，严重性: 17，状态: 123。
51:18. spid53 There is insufficient system memory in resource pool 'default' to run this query.
51:18. spid53 错误: 701，严重性: 17，状态: 123。
51:18. spid53 There is insufficient system memory in resource pool 'default' to run this query.
51:18. spid53 错误: 701，严重性: 17，状态: 123。
51:18. spid53 There is insufficient system memory in resource pool 'default' to run this query.
51:18. spid53 错误: 701，严重性: 17，状态: 123。
51:18. spid53 There is insufficient system memory in resource pool 'default' to run this query.
51:18. spid53 错误: 701，严重性: 17，状态: 123。
51:18. spid53 There is insufficient system memory in resource pool 'default' to run this query.
51:18. spid53 错误: 701，严重性: 17，状态: 123。
51:18. spid53 There is insufficient system memory in resource pool 'default' to run this query.
51:18. spid53 错误: 701，严重性: 17，状态: 123。
51:18. spid53 There is insufficient system memory in resource pool 'default' to run this query.
51:18. spid53 错误: 701，严重性: 17，状态: 123。
51:18. spid53 There is insufficient system memory in resource pool 'default' to run this query.
51:18. spid53 错误: 701，严重性: 17，状态: 123。
51:18. spid53 There is insufficient system memory in resource pool 'default' to run this query.
51:18. spid53 错误: 701，严重性: 17，状态: 123。
51:18. spid53 There is insufficient system memory in resource pool 'default' to run this query.
51:18. spid53 错误: 701，严重性: 17，状态: 123。
51:18. spid53 There is insufficient system memory in resource pool 'default' to run this query.
51:18. spid53 错误: 701，严重性: 17，状态: 123。
51:18. spid53 There is insufficient system memory in resource pool 'default' to run this query.
51:18. spid53 错误: 701，严重性: 17，状态: 123。
51:18. spid53 There is insufficient system memory in resource pool 'default' to run this query.
51:18. spid53 错误: 701，严重性: 17，状态: 123。
51:18. spid53 There is insufficient system memory in resource pool 'default' to run this query.
51:18. spid53 错误: 701，严重性: 17，状态: 123。
51:18. spid53 There is insufficient system memory in resource pool 'default' to run this query.
51:18. spid53 错误: 701，严重性: 17，状态: 123。
51:18. spid53 There is insufficient system memory in resource pool 'default' to run this query.
51:18. spid53 错误: 701，严重性: 17，状态: 123。
51:18. spid53 There is insufficient system memory in resource pool 'default' to run this query.
51:18. spid53 错误: 701，严重性: 17，状态: 123。
51:18. spid53 There is insufficient system memory in resource pool 'default' to run this query.
51:18. spid53 错误: 701，严重性: 17，状态: 123。
51:18. spid53 There is insufficient system memory in resource pool 'default' to run this query.
51:18. spid53 Error occurred while attempting to drop worktable with partition ID 140737980268544.
51:18. spid53 Error occurred while attempting to drop worktable with partition ID 140737979482112.
51:19. 登录 错误: 17803，严重性: 20，状态: 13。
51:19. 登录 There was a memory allocation failure during connection establishment. Reduce nonessential memory load
51:19. 登录 错误: 17803，严重性: 20，状态: 13。
51:19. 登录 There was a memory allocation failure during connection establishment. Reduce nonessential memory load
51:20. 登录 错误: 17803，严重性: 20，状态: 13。
51:20. 登录 There was a memory allocation failure during connection establishment. Reduce nonessential memory load
51:20. 登录 错误: 17803，严重性: 20，状态: 13。
51:20. 登录 There was a memory allocation failure during connection establishment. Reduce nonessential memory load
51:21. 登录 错误: 17803，严重性: 20，状态: 13。
51:21. 登录 There was a memory allocation failure during connection establishment. Reduce nonessential memory load
51:21. 登录 错误: 17803，严重性: 20，状态: 13。
51:21. 登录 There was a memory allocation failure during connection establishment. Reduce nonessential memory load
51:23. spid53 Worktable with partition ID 0 was dropped successfully after repeated attempts.
51:23. spid53 Worktable with partition ID 0 was dropped successfully after repeated attempts.
54:12. spid51 SQL Server has encountered 1 occurrence(s) of cachestore flush for the 'Object Plans' cachestore (part of plan cache) due to 'DBCC FREEPROCCACHE' or 'DBCC FREESYSTEMCACHE' operations.
54:12. spid51 SQL Server has encountered 1 occurrence(s) of cachestore flush for the 'SQL Plans' cachestore (part of plan cache) due to 'DBCC FREEPROCCACHE' or 'DBCC FREESYSTEMCACHE' operations.
54:12. spid51 SQL Server has encountered 1 occurrence(s) of cachestore flush for the 'Bound Trees' cachestore (part of plan cache) due to 'DBCC FREEPROCCACHE' or 'DBCC FREESYSTEMCACHE' operations.
54:12. spid51 Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.
54:12. spid51 FILESTREAM: effective level = 0
54:12. spid51 Configuration option 'min server memory (MB)' changed from 256 to 256. Run the RECONFIGURE statement to install.
54:12. spid51 FILESTREAM: effective level = 0
54:17. spid51 Configuration option 'max server memory (MB)' changed from 256 to 256. Run the RECONFIGURE statement to install.
54:17. spid51 FILESTREAM: effective level = 0
54:22. spid51 Configuration option 'max server memory (MB)' changed from 256 to 2147483647. Run the RECONFIGURE statement to install.
54:22. spid51 FILESTREAM: effective level = 0
59:12. spid66 Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.
59:12. spid66 FILESTREAM: effective level = 0
59:12. spid66 Configuration option 'min server memory (MB)' changed from 256 to 256. Run the RECONFIGURE statement to install.
59:12. spid66 FILESTREAM: effective level = 0
59:17. spid66 Configuration option 'max server memory (MB)' changed from 2147483647 to 256. Run the RECONFIGURE statement to install.
59:17. spid66 FILESTREAM: effective level = 0
59:17. spid66 SQL Server has encountered 1 occurrence(s) of cachestore flush for the 'Object Plans' cachestore (part of plan cache) due to 'DBCC FREEPROCCACHE' or 'DBCC FREESYSTEMCACHE' operations.
59:17. spid66 SQL Server has encountered 2 occurrence(s) of cachestore flush for the 'Object Plans' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.
59:17. spid66 SQL Server has encountered 1 occurrence(s) of cachestore flush for the 'SQL Plans' cachestore (part of plan cache) due to 'DBCC FREEPROCCACHE' or 'DBCC FREESYSTEMCACHE' operations.
59:17. spid66 SQL Server has encountered 2 occurrence(s) of cachestore flush for the 'SQL Plans' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.
59:17. spid66 SQL Server has encountered 1 occurrence(s) of cachestore flush for the 'Bound Trees' cachestore (part of plan cache) due to 'DBCC FREEPROCCACHE' or 'DBCC FREESYSTEMCACHE' operations.
59:17. spid66 SQL Server has encountered 2 occurrence(s) of cachestore flush for the 'Bound Trees' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.
59:22. spid66 Configuration option 'max server memory (MB)' changed from 256 to 2147483647. Run the RECONFIGURE statement to install.
mssql2008 R2+win2008 64位 [/code]
Last Notification 2
51:18. spid53 错误: 701，严重性: 17，状态: 123。
51:18. spid53 There is insufficient system memory in resource pool 'default' to run this query.
51:18. spid53 错误: 701，严重性: 17，状态: 123。
51:18. spid53 There is insufficient system memory in resource pool 'default' to run this query.
51:18. spid53 错误: 701，严重性: 17，状态: 123。
51:18. spid53 There is insufficient system memory in resource pool 'default' to run this query.
51:18. spid53 错误: 701，严重性: 17，状态: 123。
51:18. spid53 There is insufficient system memory in resource pool 'default' to run this query.
51:18. spid53 错误: 701，严重性: 17，状态: 123。
51:18. spid53 There is insufficient system memory in resource pool 'default' to run this query.
51:18. spid53 错误: 701，严重性: 17，状态: 123。
51:18. spid53 There is insufficient system memory in resource pool 'default' to run this query.
51:18. spid53 错误: 701，严重性: 17，状态: 123。
51:18. spid53 There is insufficient system memory in resource pool 'default' to run this query.
51:18. spid53 错误: 701，严重性: 17，状态: 123。
51:18. spid53 There is insufficient system memory in resource pool 'default' to run this query.
51:18. spid53 错误: 701，严重性: 17，状态: 123。
51:18. spid53 There is insufficient system memory in resource pool 'default' to run this query.
51:18. spid53 错误: 701，严重性: 17，状态: 123。
51:18. spid53 There is insufficient system memory in resource pool 'default' to run this query.
51:18. spid53 错误: 701，严重性: 17，状态: 123。
51:18. spid53 There is insufficient system memory in resource pool 'default' to run this query.
51:18. spid53 错误: 701，严重性: 17，状态: 123。
51:18. spid53 There is insufficient system memory in resource pool 'default' to run this query.
51:18. spid53 错误: 701，严重性: 17，状态: 123。
51:18. spid53 There is insufficient system memory in resource pool 'default' to run this query.
51:18. spid53 错误: 701，严重性: 17，状态: 123。
51:18. spid53 There is insufficient system memory in resource pool 'default' to run this query.
51:18. spid53 错误: 701，严重性: 17，状态: 123。
51:18. spid53 There is insufficient system memory in resource pool 'default' to run this query.
51:18. spid53 错误: 701，严重性: 17，状态: 123。
51:18. spid53 There is insufficient system memory in resource pool 'default' to run this query.
51:18. spid53 错误: 701，严重性: 17，状态: 123。
51:18. spid53 There is insufficient system memory in resource pool 'default' to run this query.
51:18. spid53 错误: 701，严重性: 17，状态: 123。
51:18. spid53 There is insufficient system memory in resource pool 'default' to run this query.
51:18. spid53 错误: 701，严重性: 17，状态: 123。
51:18. spid53 There is insufficient system memory in resource pool 'default' to run this query.
51:18. spid53 错误: 701，严重性: 17，状态: 123。
51:18. spid53 There is insufficient system memory in resource pool 'default' to run this query.
51:18. spid53 错误: 701，严重性: 17，状态: 123。
51:18. spid53 There is insufficient system memory in resource pool 'default' to run this query.
51:18. spid53 错误: 701，严重性: 17，状态: 123。
51:18. spid53 There is insufficient system memory in resource pool 'default' to run this query.
51:18. spid53 错误: 701，严重性: 17，状态: 123。
51:18. spid53 There is insufficient system memory in resource pool 'default' to run this query.
51:18. spid53 错误: 701，严重性: 17，状态: 123。
51:18. spid53 There is insufficient system memory in resource pool 'default' to run this query.
51:18. spid53 Error occurred while attempting to drop worktable with partition ID 140737980268544.
51:18. spid53 Error occurred while attempting to drop worktable with partition ID 140737979482112.
51:19. 登录 错误: 17803，严重性: 20，状态: 13。
51:19. 登录 There was a memory allocation failure during connection establishment. Reduce nonessential memory load
51:19. 登录 错误: 17803，严重性: 20，状态: 13。
51:19. 登录 There was a memory allocation failure during connection establishment. Reduce nonessential memory load
51:20. 登录 错误: 17803，严重性: 20，状态: 13。
51:20. 登录 There was a memory allocation failure during connection establishment. Reduce nonessential memory load
51:20. 登录 错误: 17803，严重性: 20，状态: 13。
51:20. 登录 There was a memory allocation failure during connection establishment. Reduce nonessential memory load
51:21. 登录 错误: 17803，严重性: 20，状态: 13。
51:21. 登录 There was a memory allocation failure during connection establishment. Reduce nonessential memory load
51:21. 登录 错误: 17803，严重性: 20，状态: 13。
51:21. 登录 There was a memory allocation failure during connection establishment. Reduce nonessential memory load
51:23. spid53 Worktable with partition ID 0 was dropped successfully after repeated attempts.
51:23. spid53 Worktable with partition ID 0 was dropped successfully after repeated attempts.
54:12. spid51 SQL Server has encountered 1 occurrence(s) of cachestore flush for the 'Object Plans' cachestore (part of plan cache) due to 'DBCC FREEPROCCACHE' or 'DBCC FREESYSTEMCACHE' operations.
54:12. spid51 SQL Server has encountered 1 occurrence(s) of cachestore flush for the 'SQL Plans' cachestore (part of plan cache) due to 'DBCC FREEPROCCACHE' or 'DBCC FREESYSTEMCACHE' operations.
54:12. spid51 SQL Server has encountered 1 occurrence(s) of cachestore flush for the 'Bound Trees' cachestore (part of plan cache) due to 'DBCC FREEPROCCACHE' or 'DBCC FREESYSTEMCACHE' operations.
54:12. spid51 Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.
54:12. spid51 FILESTREAM: effective level = 0
54:12. spid51 Configuration option 'min server memory (MB)' changed from 256 to 256. Run the RECONFIGURE statement to install.
54:12. spid51 FILESTREAM: effective level = 0
54:17. spid51 Configuration option 'max server memory (MB)' changed from 256 to 256. Run the RECONFIGURE statement to install.
54:17. spid51 FILESTREAM: effective level = 0
54:22. spid51 Configuration option 'max server memory (MB)' changed from 256 to 2147483647. Run the RECONFIGURE statement to install.
54:22. spid51 FILESTREAM: effective level = 0
59:12. spid66 Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.
59:12. spid66 FILESTREAM: effective level = 0
59:12. spid66 Configuration option 'min server memory (MB)' changed from 256 to 256. Run the RECONFIGURE statement to install.
59:12. spid66 FILESTREAM: effective level = 0
59:17. spid66 Configuration option 'max server memory (MB)' changed from 2147483647 to 256. Run the RECONFIGURE statement to install.
59:17. spid66 FILESTREAM: effective level = 0
59:17. spid66 SQL Server has encountered 1 occurrence(s) of cachestore flush for the 'Object Plans' cachestore (part of plan cache) due to 'DBCC FREEPROCCACHE' or 'DBCC FREESYSTEMCACHE' operations.
59:17. spid66 SQL Server has encountered 2 occurrence(s) of cachestore flush for the 'Object Plans' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.
59:17. spid66 SQL Server has encountered 1 occurrence(s) of cachestore flush for the 'SQL Plans' cachestore (part of plan cache) due to 'DBCC FREEPROCCACHE' or 'DBCC FREESYSTEMCACHE' operations.
59:17. spid66 SQL Server has encountered 2 occurrence(s) of cachestore flush for the 'SQL Plans' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.
59:17. spid66 SQL Server has encountered 1 occurrence(s) of cachestore flush for the 'Bound Trees' cachestore (part of plan cache) due to 'DBCC FREEPROCCACHE' or 'DBCC FREESYSTEMCACHE' operations.
59:17. spid66 SQL Server has encountered 2 occurrence(s) of cachestore flush for the 'Bound Trees' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.
59:22. spid66 Configuration option 'max server memory (MB)' changed from 256 to 2147483647. Run the RECONFIGURE statement to install.
检查一下SP_Configure
2013-09-06 15:58:37.700,spid60,Starting up database 'bw9kbzpro_03'.
2013-09-06 16:00:39.360,spid55,SQL Server has encountered 1 occurrence(s) of cachestore flush for the 'Object Plans' cachestore (part of plan cache) due to 'DBCC FREEPROCCACHE' or 'DBCC FREESYSTEMCACHE' operations.
2013-09-06 16:00:39.440,spid55,SQL Server has encountered 1 occurrence(s) of cachestore flush for the 'SQL Plans' cachestore (part of plan cache) due to 'DBCC FREEPROCCACHE' or 'DBCC FREESYSTEMCACHE' operations.
2013-09-06 16:00:39.440,spid55,SQL Server has encountered 1 occurrence(s) of cachestore flush for the 'Bound Trees' cachestore (part of plan cache) due to 'DBCC FREEPROCCACHE' or 'DBCC FREESYSTEMCACHE' operations.
2013-09-06 16:00:39.830,spid55,Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.
2013-09-06 16:00:39.830,spid55,FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.
2013-09-06 16:00:39.840,spid55,Configuration option 'min server memory (MB)' changed from 256 to 256. Run the RECONFIGURE statement to install.
2013-09-06 16:00:39.840,spid55,FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.
2013-09-06 16:00:44.840,spid55,Configuration option 'max server memory (MB)' changed from 2147483647 to 256. Run the RECONFIGURE statement to install.
2013-09-06 16:00:44.840,spid55,FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.
2013-09-06 16:00:49.900,spid55,Configuration option 'max server memory (MB)' changed from 256 to 2147483647. Run the RECONFIGURE statement to install.
2013-09-06 16:00:49.900,spid55,FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.
2013-09-06 16:00:56.370,spid58,Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.
2013-09-06 16:00:56.370,spid58,FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.
2013-09-06 16:00:56.370,spid58,Configuration option 'min server memory (MB)' changed from 256 to 256. Run the RECONFIGURE statement to install.
2013-09-06 16:00:56.370,spid58,FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.
2013-09-06 16:01:01.400,spid58,Configuration option 'max server memory (MB)' changed from 2147483647 to 256. Run the RECONFIGURE statement to install.
2013-09-06 16:01:01.400,spid58,FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.
2013-09-06 16:01:06.470,spid58,Configuration option 'max server memory (MB)' changed from 256 to 2147483647. Run the RECONFIGURE statement to install.
2013-09-06 16:01:06.470,spid58,FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.
2013-09-06 16:05:51.880,spid52,Setting database option COMPATIBILITY_LEVEL to 100 for database BWERP_fb001.
2013-09-06 16:07:06.020,spid52,Setting database option COMPATIBILITY_LEVEL to 100 for database bwerp_pos.
2013-09-06 16:10:16.850,spid4s,SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [E:\dataBack\BWERP_fb001.ldf] in database [BWERP_fb001] (10). The OS file handle is 0x00000000000006A0. The offset of the latest long I/O is: 0x00000004810800
2013-09-06 16:12:16.520,spid54,SQL Server has encountered 2 occurrence(s) of cachestore flush for the 'Object Plans' cachestore (part of plan cache) due to 'DBCC FREEPROCCACHE' or 'DBCC FREESYSTEMCACHE' operations.
2013-09-06 16:12:16.520,spid54,SQL Server has encountered 4 occurrence(s) of cachestore flush for the 'Object Plans' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.
2013-09-06 16:12:16.530,spid54,SQL Server has encountered 2 occurrence(s) of cachestore flush for the 'SQL Plans' cachestore (part of plan cache) due to 'DBCC FREEPROCCACHE' or 'DBCC FREESYSTEMCACHE' operations.
2013-09-06 16:12:16.530,spid54,SQL Server has encountered 4 occurrence(s) of cachestore flush for the 'SQL Plans' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.
2013-09-06 16:12:16.530,spid54,SQL Server has encountered 2 occurrence(s) of cachestore flush for the 'Bound Trees' cachestore (part of plan cache) due to 'DBCC FREEPROCCACHE' or 'DBCC FREESYSTEMCACHE' operations.
2013-09-06 16:12:16.530,spid54,SQL Server has encountered 4 occurrence(s) of cachestore flush for the 'Bound Trees' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.
2013-09-06 16:12:18.420,spid54,Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.
2013-09-06 16:12:18.420,spid54,FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.
2013-09-06 16:12:18.470,spid54,Configuration option 'min server memory (MB)' changed from 256 to 256. Run the RECONFIGURE statement to install.
2013-09-06 16:12:18.470,spid54,FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.
2013-09-06 16:12:23.650,spid54,Configuration option 'max server memory (MB)' changed from 2147483647 to 256. Run the RECONFIGURE statement to install.
2013-09-06 16:12:23.650,spid54,FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.
2013-09-06 16:12:27.810,spid59,Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.
2013-09-06 16:12:27.810,spid59,FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.
2013-09-06 16:12:27.880,spid59,Configuration option 'min server memory (MB)' changed from 256 to 256. Run the RECONFIGURE statement to install.
2013-09-06 16:12:27.880,spid59,FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.
2013-09-06 16:12:28.860,spid54,Configuration option 'max server memory (MB)' changed from 256 to 2147483647. Run the RECONFIGURE statement to install.
2013-09-06 16:12:28.860,spid54,FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.
2013-09-06 16:12:33.040,spid59,Configuration option 'max server memory (MB)' changed from 2147483647 to 256. Run the RECONFIGURE statement to install.
2013-09-06 16:12:33.040,spid59,FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.
2013-09-06 16:12:38.320,spid59,Configuration option 'max server memory (MB)' changed from 256 to 2147483647. Run the RECONFIGURE statement to install.
2013-09-06 16:12:38.320,spid59,FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.
2013-09-06 16:17:16.540,spid68,SQL Server has encountered 2 occurrence(s) of cachestore flush for the 'Object Plans' cachestore (part of plan cache) due to 'DBCC FREEPROCCACHE' or 'DBCC FREESYSTEMCACHE' operations.
2013-09-06 16:17:16.540,spid68,SQL Server has encountered 4 occurrence(s) of cachestore flush for the 'Object Plans' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.
2013-09-06 16:17:16.560,spid68,SQL Server has encountered 2 occurrence(s) of cachestore flush for the 'SQL Plans' cachestore (part of plan cache) due to 'DBCC FREEPROCCACHE' or 'DBCC FREESYSTEMCACHE' operations.
2013-09-06 16:17:16.560,spid68,SQL Server has encountered 4 occurrence(s) of cachestore flush for the 'SQL Plans' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.
2013-09-06 16:17:16.570,spid68,SQL Server has encountered 2 occurrence(s) of cachestore flush for the 'Bound Trees' cachestore (part of plan cache) due to 'DBCC FREEPROCCACHE' or 'DBCC FREESYSTEMCACHE' operations.
2013-09-06 16:17:16.570,spid68,SQL Server has encountered 4 occurrence(s) of cachestore flush for the 'Bound Trees' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.
2013-09-06 16:17:17.610,spid68,Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.
2013-09-06 16:17:17.610,spid68,FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.
2013-09-06 16:17:17.630,spid68,Configuration option 'min server memory (MB)' changed from 256 to 256. Run the RECONFIGURE statement to install.
2013-09-06 16:17:17.640,spid68,FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.
2013-09-06 16:17:22.690,spid68,Configuration option 'max server memory (MB)' changed from 2147483647 to 256. Run the RECONFIGURE statement to install.
2013-09-06 16:17:22.690,spid68,FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.
2013-09-06 16:17:29.320,spid68,Configuration option 'max server memory (MB)' changed from 256 to 2147483647. Run the RECONFIGURE statement to install.
2013-09-06 16:17:29.860,spid68,FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.
2013-09-06 16:17:38.580,spid61,Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.
2013-09-06 16:17:38.580,spid61,FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.
2013-09-06 16:17:38.610,spid61,Configuration option 'min server memory (MB)' changed from 256 to 256. Run the RECONFIGURE statement to install.
2013-09-06 16:17:43.780,spid61,Configuration option 'max server memory (MB)' changed from 2147483647 to 256. Run the RECONFIGURE statement to install.
2013-09-06 16:17:43.790,spid61,FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.
2013-09-06 16:17:49.010,spid61,Configuration option 'max server memory (MB)' changed from 256 to 2147483647. Run the RECONFIGURE statement to install.
2013-09-06 16:17:49.060,spid61,FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.
2013-09-06 16:22:16.660,spid54,SQL Server has encountered 2 occurrence(s) of cachestore flush for the 'Object Plans' cachestore (part of plan cache) due to 'DBCC FREEPROCCACHE' or 'DBCC FREESYSTEMCACHE' operations.
2013-09-06 16:22:16.720,spid54,SQL Server has encountered 4 occurrence(s) of cachestore flush for the 'Object Plans' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.
2013-09-06 16:22:16.800,spid54,SQL Server has encountered 2 occurrence(s) of cachestore flush for the 'SQL Plans' cachestore (part of plan cache) due to 'DBCC FREEPROCCACHE' or 'DBCC FREESYSTEMCACHE' operations.
2013-09-06 16:22:16.810,spid54,SQL Server has encountered 4 occurrence(s) of cachestore flush for the 'SQL Plans' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.
2013-09-06 16:22:16.880,spid54,SQL Server has encountered 2 occurrence(s) of cachestore flush for the 'Bound Trees' cachestore (part of plan cache) due to 'DBCC FREEPROCCACHE' or 'DBCC FREESYSTEMCACHE' operations.
2013-09-06 16:22:16.940,spid54,SQL Server has encountered 4 occurrence(s) of cachestore flush for the 'Bound Trees' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.
2013-09-06 16:22:19.030,spid54,Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.
2013-09-06 16:22:19.030,spid54,FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.
2013-09-06 16:22:19.110,spid54,Configuration option 'min server memory (MB)' changed from 256 to 256. Run the RECONFIGURE statement to install.
2013-09-06 16:22:19.110,spid54,FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.
2013-09-06 16:22:24.230,spid54,Configuration option 'max server memory (MB)' changed from 2147483647 to 256. Run the RECONFIGURE statement to install.
2013-09-06 16:22:24.230,spid54,FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.
2013-09-06 16:22:32.060,spid59,
强烈不建议这么做,
1.数据库进程内存增长是正常现象,MSSQL会自行管理内存使用.
不必限制最大内存,设为自动管理即可.
2.每5分钟释放一次内存会导致缓存丢失,每次读取只能去磁盘读,严重影响性能.
强烈不建议这么做,
1.数据库进程内存增长是正常现象,MSSQL会自行管理内存使用.
不必限制最大内存,设为自动管理即可.
2.每5分钟释放一次内存会导致缓存丢失,每次读取只能去磁盘读,严重影响性能.
一般情况下，最大内存的大小还是要设置的，
尽管SQL SERVER对于外部、内部内存压力有自我条件功能，但是它不是表现的很完美，
有时候有外部内存压力的时候，它的反应不够快，或者不够彻底，那就会引起SQL SERVER被paged out，影响性能。