Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Memory Grant
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Posting Yak Master

248 Posts

Posted - 04/06/2013 :  07:09:59  Show Profile  Reply with Quote
I have some doubts regarding memory handling in sql server pls any one clarify

I 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 plan

If 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 wrong
If 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 this

Thanks in advance


5072 Posts

Posted - 04/06/2013 :  21:50:53  Show Profile  Visit russell's Homepage  Reply with Quote
You can see the I/O and CPU cost, and the Plan Cache size in the execution plan.
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000