October 4, 2011 at 3:01 pm
I have a SQL Server 2000 SP4 (8.0.2039) x86 server on Windows 2003 x64 with 64GB RAM and SQL is configured with AWE and min RAM = 0 and Max ram = 61440.
I get errors: There is insufficient memory to run this query (error 701).
I also can't backup my transaction logs successfully.
Buffer Distribution Buffers
------------------------------ -----------
Stolen 12598
Free 56999
Procedures 170227
Inram 0
Dirty 87415
Kept 0
I/O 0
Latched 851
Other 3831018
(9 row(s) affected)
Buffer Counts Buffers
------------------------------ -----------
Commited 4159108
Target 4159108
Hashed 3919284
InternalReservation 1366
ExternalReservation 1035
Min Free 512
Visible 397840
(7 row(s) affected)
Procedure Cache Value
------------------------------ -----------
TotalProcs 58719
TotalPages 170227
InUsePages 91060
(3 row(s) affected)
Dynamic Memory Manager Buffers
------------------------------ -----------
Stolen 182728
OS Reserved 9904
OS Committed 9859
OS In Use 7865
General 30548
QueryPlan 148886
Optimizer 34
Utilities 647
Connection 9288
(9 row(s) affected)
Global Memory Objects Buffers
------------------------------ -----------
Resource 7442
Locks 403
XDES 181
SQLCache 1176
Replication 3
LockBytes 2
ServerGlobal 31
(7 row(s) affected)
Query Memory Objects Value
------------------------------ -----------
Grants 3
Waiting 0
Available (Buffers) 220425
Maximum (Buffers) 221557
(4 row(s) affected)
Optimization Queue Value
------------------------------ -----------
Optimizing 1
Waiting 0
Available 63
Maximum 64
October 4, 2011 at 10:02 pm
What is the error you get when trying to backup your logs?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
October 5, 2011 at 1:25 pm
A couple of handy Microsoft papers on the subject
http://support.microsoft.com/kb/912439/en-us
http://support.microsoft.com/kb/2001221
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply