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 user 1336

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.

1
vote
2answers
We have increased the RAM capacity on the OS to 40G and I have changed the max memory parameter to 36G in SSMS. When I select "current value", it shows 36G. However, monitoring memory usage at OS … level doesn't show more memory being consumed. I know that, in theory, it's possible to change the max memory setting while SQL Server is still running, but does it really work? Do I need to restart the server? Or am I being impatient? Thanks …
asked Nov 3 '15 by Nicolas de Fontenay
1
vote
handy when your application doesn't use bind variables. The database will do that for you. If you are already using cursor_sharing=FORCE. Then you need to start considering adjusting your memory … allocationand depending on the memory parameters your system use, you can obtain an idea of where you should set that value with the following queries: When SGA_TARGET and SGA_MAX__SIZE /PGA_TARGET and …
answered Mar 31 '16 by Nicolas de Fontenay