Sql Server 2012 Error: Fail_Page_Allocation 1
I Have Been Having Some Series Issues with My Webserver Machine Running Ms Sql Server 2012 64-Bit Standard. I Keep Getting This Error: 02/23/2013 21:49:17...
I have been having some series issues with my webserver machine running MS SQL Server 2012 64-Bit Standard. I keep getting this error:
02/23/2013 21:49:17,spid54,Unknown,There is insufficient system memory in resource pool 'internal' to run this query.
02/23/2013 21:49:17,spid54,Unknown,Error: 701 Severity: 17 State: 130.
which when I read the MS SQL log file, this issue always starts with this entry:
02/23/2013 21:49:16,spid57,Unknown,Failed allocate pages: FAIL_PAGE_ALLOCATION 1
System Specs: Windows Server 2008 R2 x64, 5GB RAM, 2 x Intel Xeon Dual-Core
Approximately every 5 days, SQL Server crashes due to this memory error. I have tried upgrading to Cumulative Update 5 which supposedly includes a hotfix for this memory error. I've tried setting the max memory to 2600mb (because this machine is also my webserver). I can't figure out what is causing this error or why MS SQL won't reset itself if the error occurs -- it will literally keep trying to run queries until the server's memory is maxed out. Any ideas would be wonderful.
1 Answer
When ran into error 701, check your SQL log(Object explorer > Management > Sql server log), you should find these kind of thing:
2014-01-14 14:19:42.25 spid97
CACHESTORE_SQLCP (Total)
VM Reserved = 0 KB
......
SinglePage Allocator = xxx KB
Multipage Allocator = 0 KB ......
Above the log pasted by you. 701 log is caused when page is applied for. If xxx is enough huge, CACHESTORE_SQLCP, this Memory Clerk tied up too much. You should check your client. SQL Server cannot resolve this kind of error. You should improve the behavior of your application.
Have a try SqlDiag, path: C:\Program Files\Microsoft SQL Server\110\Tools\Binn\Sqldiag.exe
David Miller brings 15 years of experience in global economics, personal finance strategy, and market dynamics. He specializes in turning complex economic trends into actionable insights for everyday readers.
