SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

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

shaggy
Posting Yak Master

India
245 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

russell
Pyro-ma-ni-yak

USA
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  
 New 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.05 seconds. Powered By: Snitz Forums 2000