473,320 Members | 2,112 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

DBCC Memory Status and Query Plan

When I executed DBCC Memory Status following are the out put
Buffer Distribution

Stolen 187191
Free 1026
Procedures 6698
Inram 0
Dirty 154661
Kept 0
I/O 0
Latched 772
Other 436084

Buffer Counts

Committed 786432
Target 786432
Hashed 591517
Internal Reservation 510
External Reservation 2291
Min Free 1024
Visible 200408
Procedure Cache

Total Procs 563
TotalPages 6698
InUsePages 6576
Dynamic Memory Manager

Stolen 192631
OS Reserved 920
OS Committed 898
OS In Use 894
General 5017
Query Paln 183216
Optimizer 0
Utilites 658
Connection 4110
Global Memory Objects

Resource 3428
Locks 477
SQLCache 850
Replication 2
LockBytes 2
ServerGlobal 22
Xact 260

Query Memory Manager
6
Grants 6
Waiting 0
Maximum 5922
Available 2389

Now I am getting the following error
2006-10-23 14:34:20.91 spid904 BPool::Map: no remappable address
found.
2006-10-23 14:34:20.94 spid465 BPool::Map: no remappable address
found.
2006-10-23 14:34:20.94 spid62 AWE mapping status:
2006-10-23 14:34:20.94 spid62 There are 200408 pages in the AWE
window
2006-10-23 14:34:20.94 spid62 193325 pages have a bstat of 000000
2006-10-23 14:34:20.94 spid62 3043 pages have a bstat of 00000b
2006-10-23 14:34:20.94 spid62 2844 pages have a bstat of 000009
2006-10-23 14:34:20.94 spid62 633 pages have a bstat of 000020
2006-10-23 14:34:20.94 spid62 563 pages have a bstat of 001001
2006-10-23 14:34:20.94 spid62 BPool::Map: no remappable address
found.
2006-10-23 14:34:20.96 spid530 BPool::Map: no remappable address
found.
2006-10-23 14:34:20.97 spid240 BPool::Map: no remappable address
found.
2006-10-23 14:34:20.99 spid275 BPool::Map: no remappable address
found.
2006-10-23 14:34:21.02 spid465 BPool::Map: no remappable address
found.

System is configured with AWE and 6.5 GB to SQL Server. Total Mem: 8 GB
Questions

1. I see QueryPlan very high . What is the difference between QueryPlan
and Procedures Counter . My experiment indicates QueryPlan Value is
always greater than Procedures . Is it correct ? Can Some one explain
query plan correctly . It is confusing from the MS Article

2. I suspect QueryPlan counter is high ? Is the problem is in
BufferPool or MemtoLeave ?

3. Statements executed mostly are prepared statements

Oct 26 '06 #1
0 4197

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Morgan Leppink | last post by:
Hey all - We are running SQL 2000 with ALL available service packs, etc. applied. We just built a brand new database server, which has dual 2Ghz XEONs, 2GB memory, and the following disk...
2
by: SR | last post by:
Can someone please help me interpret this result set below and suggest on way I can speed up my table? What changes should I make? DBCC SHOWCONTIG scanning 'tblListing' table... Table:...
1
by: Kalvin | last post by:
I keep seeing this return from running a DBCC OpenTran: Transaction information for database 'Live_App'. Oldest active transaction: SPID (server process ID) : 92 UID (user ID) : 1 Name ...
4
by: xixi | last post by:
i have a very serious memory problem, we have db2 udb v8.1 load on a HP titanium machine with 4 G memory, it is 64bit machine, currently on DB2 instance , i have three databases, but only one is...
8
by: Lincoln Yeoh | last post by:
Hi, I recently upgraded to postgresql 7.4 and I am having a problem with postmaster using lots of memory for a query (keeps growing even up to 400MB+ till I stop postgresql ). I don't recall...
2
by: Lincoln Yeoh | last post by:
Sorry for the repost. Just wondering if anyone has a workaround for 7.4? At 11:25 AM 1/27/2004 -0500, Tom Lane wrote: >Martijn van Oosterhout <kleptog@svana.org> writes: > > I'm afraid I'll have...
4
by: Rachel McConnell | last post by:
Hello, I have a Java web application using Hibernate to connect to a PostgreSQL backend. I am seeing the below stack trace during processing of a set of data consisting of around 1000 objects;...
5
by: Aaron Birkland | last post by:
I have a long but straightforward query (on some very large tables) that always ends in 'Memory exhausted in AllocSetAlloc(108)'. Even stranger are some messages that appear in the logfile, such...
0
by: Katsaros Kwn/nos | last post by:
Hi! I have some problems with the SPI memory management (at least I think this is the problem). What I'm trying to do is to get the Query related to a select statement, alter it and produce a...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.