Posted by Erland Sommarskog on 11/30/07 22:06

Don Li (tatata9999@gmail.com) writes:
> Erland, I'm with you, thank you. Now, let's refer to a previous but
> related thread,
> http://groups.google.com/group/comp.databases.ms-sqlserver/browse_thread/thread/07bf13e23d6bf643/2b7c382a0f8dbaa9#2b7c382a0f8dbaa9
>
> There you mentioned about cache, I searched BOL for more on the
> subject to almost no avail, googling gets something like "BPool
> (buffer pool) and MemToLeave", too theorical not practical. Any
> pointer for this?

To learn more about SQL Server Memory I recommend reading the sections
in Books Online headed by
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/9caf0d8d-5261-40e5-8730-5b88009272ea.htm

Or get Kalen Delaney's "Inside SQL Server 2005: The Storage Engine".


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: bcp utility
• Prev in forum: Re: load balancing cluster
• Thread view: Re: Data insertion too too slow...

[Reply to this message]