Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options answers only user 708

When used in the context of databases, memory refers to RAM directly addressable by the CPU as opposed to going through the I/O subsystem.

3
votes
AWE memory can only be used for data cache. Things like procedure cache, workers stacks, execution memory grants, SQLCRL and so on can only use the process 'real' memory space (ie. the 3Gb). So even … if you did set up everything correctly, it does not mean that 1) SQL Server will actually use all the 6Gb and 2) you won't run into out-of-memory issues despite plenty of AWE memory being available. 32bit is dead. Just move to a 64 bit environment and call it a day. …
answered Feb 9 '12 by Remus Rusanu
4
votes
use db1; select ... from db2..table join db3..table; Should the memory allocated for this plan be counted against db1, db2 or db3? Usually the three dbs in my example are the same and the issue is … prepared SQL statements, the ID of the database where the statements were compiled. The thinking around this issues should be 'memory allocated for plans', 'memory allocated for execution' and don't …
answered Jun 21 '12 by Remus Rusanu
3
votes
: SQL Server, Memory Manager Object, SQL Server, Buffer Manager Object. Read Fun with Locked Pages, AWE, Task Manager, and the Working Set… …
answered Mar 25 '14 by Remus Rusanu
5
votes
starter. Do not change random settings, like memory, in hope you fix the problem. Analyze, find the root cause and fix it. You're probably missing an index or more. For the record: DBCC FREESYSTEMCACHE('ALL') …
answered Nov 18 '15 by Remus Rusanu
2
votes
x86-64 Virtual Address Space Details: Although virtual addresses are 64 bits wide in 64-bit mode, current implementations (and all chips known to be in the planning stages) do not allow the entire …
answered Nov 3 '14 by Remus Rusanu
5
votes
How exactly would you 'release' the memory back? As a general rule SQL Server will steal all the memory from the OS and then use it for it's own purpose. See Dynamic Memory Management: The … default memory management behavior of the Microsoft SQL Server Database Engine is to acquire as much memory as it needs... The instance then continues to acquire memory as needed to support the workload …
answered Jan 25 '12 by Remus Rusanu
2
votes
SQL Server does not page, not in the sense the OS pages. Data does not need to be paged becase the memory is just a cache of the data files. Data can simply be removed from memory and read back … operators that need intermediate data that doesn't fit in memory. They spill to tempdb. The typical example is the sort operator. …
answered Aug 31 '14 by Remus Rusanu
7
votes
with bd as ( select count(*) as pages_in_memory, bd.allocation_unit_id from sys.dm_os_buffer_descriptors bd where bd.database_id = db_id() group by bd.allocation_unit_id) select p.obje …
answered Feb 29 '12 by Remus Rusanu
13
votes
The only way to prove is not a memory issue is by prooving is something else. And this requires you to identify the root cause of your performance problems. I recommend you follow a methodology like … Waits and Queues. The SQLCAT team has also published a Troubleshooting Flowchart poster that you can follow. As a general side comment: if someone is offering you to buy more memory on the server …
answered Jul 6 '12 by Remus Rusanu
2
votes
4294847 is similar 4294967295 with some digits shaved, and 4294967295 is a well known value (0xFFFFFFFF). This makes me suspect an integer underflow during a substraction in the tool you use to read …
answered Oct 28 '15 by Remus Rusanu
5
votes
, Buffer Manager Object and then see what the pattern is: total stay the same, but stolen has grown. This indicate some memory consumption from code and caches. and usually does not heal itslef. You … would investigate this by checking the memory clerks, see How to use the DBCC MEMORYSTATUS command to monitor memory usage. A possible explanation for a sudden spike in stolen that disapears quickly is …
answered Apr 25 '12 by Remus Rusanu
2
votes
You are getting soft faults and this is a non-issue. Soft faults are part of the normal page lifetime as the process working set gets continuously trimmed. If you also experience application problem …
answered Apr 24 '15 by Remus Rusanu
5
votes
Virtual Memory is an indirection mechanism that map virtual addresses to physical addresses and the translation occurs in hardware layer through PTEs. A process can refer and address only virtual … memory. Only privileged execution (kernel) can address physical memory. I recommend you read a book on the subject, the classic being Windows Internals by Russinovich/Solomon. Your explanation is asking …
answered May 31 '13 by Remus Rusanu
4
votes
Yes, for 64GB RAM you need at least 64GB swap file (96GB recommended). Not because of potential swapping, but because of the design of the Windows Memory Manager. I've wrote about this issue before … in System pagefile size on machines with large RAM: When a process asks for MEM_COMMIT memory via VirtualAlloc/VirtualAllocEx, the requested size needs to be reserved in the pagefile. This was …
answered Aug 6 '11 by Remus Rusanu