Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: Professional SQL Server 2008 Internals and Troubleshooting
This is the forum to discuss the Wrox book Professional SQL Server 2008 Internals and Troubleshooting by Christian Bolton, Justin Langford, Brent Ozar, James Rowland-Jones, Steven Wort; ISBN: 978-0-470-48428-9
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional SQL Server 2008 Internals and Troubleshooting section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
 
 
Thread Tools Display Modes
  #1 (permalink)  
Old August 29th, 2010, 12:22 PM
Registered User
 
Join Date: Aug 2010
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Post Query memory

Hi.

Thank you for very informative book.

On page 54 of query memory section:

"Query memory is used to temporarily store results during hash and sort operations ..."

My understanding is for sort type operation whenever is not enough memory available then tempDB will be used.

But, you have not mentioned tempDb here. When you say result of operation; do you mean that engine might sort the data on tempDB but, must have a memory to store all the results of operation?

Can you ,please clarify?
  #2 (permalink)  
Old August 29th, 2010, 12:28 PM
Brent Ozar's Avatar
Wrox Author
 
Join Date: Feb 2010
Location: Chicago, IL, US
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Yes, because that particular chapter is about memory, not TempDB. If you'd like to get information on how sessions are using space in TempDB for those operations, check out chapter 7. Page 292 starts discussing how to identify which sessions are using TempDB for sorts, spools, hash joins, and so on.
__________________
---
Author: Professional SQL Server 2008 Internals and Troubleshooting
Blog: BrentOzar.com
 


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Memory akkad C# 2005 3 January 10th, 2007 03:46 AM
Memory akkad C# 0 January 9th, 2007 09:01 AM
Out of Memory ocabrera70 Classic ASP Components 0 February 15th, 2006 08:08 PM
Out of memory : simplyAns All Other Wrox Books 0 November 9th, 2004 07:56 AM
Memory linguva Access 2 December 19th, 2003 06:22 PM



All times are GMT -4. The time now is 08:16 PM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.