June 12, 2009 at 3:37 am
Hello Everyone,
I have a strange message in my SQL Logs this morning when I checked the daily DB backup log in SQL.
2009-06-11 23:43:23.26 spid51BPool::Map: no remappable address found.
2009-06-11 23:43:23.26 spid51BPool::Map: no remappable address found.
2009-06-11 23:43:23.26 spid51BPool::Map: no remappable address found.
2009-06-11 23:43:23.28 spid51BPool::Map: no remappable address found.
2009-06-11 23:43:23.28 spid513 pages have a bstat of 00400f
2009-06-11 23:43:23.28 spid513 pages have a bstat of 000209
2009-06-11 23:43:23.28 spid514 pages have a bstat of 001001
2009-06-11 23:43:23.28 spid5113 pages have a bstat of 080009
2009-06-11 23:43:23.28 spid5118 pages have a bstat of 08000f
2009-06-11 23:43:23.28 spid51129 pages have a bstat of 08000b
2009-06-11 23:43:23.28 spid51452 pages have a bstat of 00000b
2009-06-11 23:43:23.28 spid5130366 pages have a bstat of 000009
2009-06-11 23:43:23.28 spid5142479 pages have a bstat of 10000f
2009-06-11 23:43:23.28 spid51117780 pages have a bstat of 000000
2009-06-11 23:43:23.28 spid51There are 191248 pages in the AWE window
2009-06-11 23:43:23.28 spid51AWE mapping status:
2009-06-11 23:43:23.37 spid51Query Memory Manager: Grants=1 Waiting=1 Maximum=113457 Available=0
2009-06-11 23:43:23.37 spid51Global Memory Objects: Resource=1393 Locks=4000 ...
2009-06-11 23:43:23.37 spid51Dynamic Memory Manager: Stolen=4838 OS Reserved=920 ...
2009-06-11 23:43:23.37 spid51Procedure Cache: TotalProcs=3 TotalPages=15 InUsePages=14
2009-06-11 23:43:23.37 spid51Buffer Counts: Commited=1537920 Target=1537920 Hashed=1419584...
2009-06-11 23:43:23.37 spid51Buffer Distribution: Stolen=117757 Free=547 Procedures=15...
2009-06-11 23:43:23.39 spid51Query Memory Manager: Grants=1 Waiting=1 Maximum=113457 Available=0
2009-06-11 23:43:23.39 spid51Global Memory Objects: Resource=1393 Locks=4000 ...
2009-06-11 23:43:23.39 spid51Dynamic Memory Manager: Stolen=4838 OS Reserved=920 ...
2009-06-11 23:43:23.39 spid51Procedure Cache: TotalProcs=3 TotalPages=15 InUsePages=14
2009-06-11 23:43:23.39 spid51Buffer Counts: Commited=1537920 Target=1537920 Hashed=1419595...
2009-06-11 23:43:23.39 spid51Buffer Distribution: Stolen=117781 Free=540 Procedures=15...
2009-06-11 23:43:23.39 spid51Query Memory Manager: Grants=1 Waiting=1 Maximum=113457 Available=0
2009-06-11 23:43:23.39 spid51Global Memory Objects: Resource=1393 Locks=4000 ...
2009-06-11 23:43:23.39 spid51Dynamic Memory Manager: Stolen=4838 OS Reserved=920 ...
2009-06-11 23:43:23.39 spid51Procedure Cache: TotalProcs=3 TotalPages=15 InUsePages=14
2009-06-11 23:43:23.39 spid51Buffer Counts: Commited=1537920 Target=1537920 Hashed=1419584...
2009-06-11 23:43:23.39 spid51Buffer Distribution: Stolen=117756 Free=549 Procedures=15...
2009-06-11 23:43:23.39 spid51Query Memory Manager: Grants=1 Waiting=1 Maximum=113457 Available=0
2009-06-11 23:43:23.39 spid51Global Memory Objects: Resource=1393 Locks=4000 ...
2009-06-11 23:43:23.39 spid51Dynamic Memory Manager: Stolen=4838 OS Reserved=920 ...
2009-06-11 23:43:23.39 spid51Procedure Cache: TotalProcs=3 TotalPages=15 InUsePages=14
2009-06-11 23:43:23.39 spid51Buffer Counts: Commited=1537920 Target=1537920 Hashed=1419584...
2009-06-11 23:43:23.39 spid51Buffer Distribution: Stolen=117757 Free=548 Procedures=15...
Is that telling me, sql server is low memory? Becasue I have upgraded to 16GB on my server and I already set to Dynamic Max Memory to 14GB and Min to 0. I already reserved 2GB for Operating System.
I got SQL 2000 SP4 installed with Win 2003 server.
I checked the Boot.ini, that is what is said -
[boot loader]
timeout=30
default=multi(0)disk(0)rdisk(0)partition(2)\WINDOWS
[operating systems]
multi(0)disk(0)rdisk(0)partition(2)\WINDOWS="Windows Server 2003, Enterprise" /fastdetect /PAE /NoExecute=OptIn
Any one can help me?
Thanks.
Leo
June 12, 2009 at 10:29 am
Is awe enabled on the sql server? Also see the performance counts on the sql server memeory manager for total server memory and target server memory.
June 12, 2009 at 2:54 pm
After applying SQL Server 2000 SP4, did you apply the AWE HotFix ?
http://support.microsoft.com/kb/899761
SQL = Scarcely Qualifies as a Language
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply