Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shaggy
Posting Yak Master
248 Posts |
 Posted - 2013-04-06 : 07:09:59
|
| I have some doubts regarding memory handling in sql server pls any one clarifyI can find some of the queries is not memomry granted I've one table update SP, it will update range of rows, for that SP i could not find anything in memory grant wherever if i join two r 3 tables i can find memory grant in planIf the DML opertaion is for single table memomry is not granted where if there is more than one table hoin i can find memory granted.Correct me if am wrongIf we speak about memory granted it is based on lock and cache and some temp activity like (hash join etc)It should be memory granted for single DMl operation coz all my read and writes will happen in cache Please anyone clarify thisThanks in advance |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2013-04-06 : 21:50:53
|
| You can see the I/O and CPU cost, and the Plan Cache size in the execution plan. |
 |
|
|
|
|
|
Memory Grant