Buffer Pool vs MemToLeave Area

Whats in the buffer pool and whats in the memtoleave area ? Is this all in
RAM or could it also be virtual memory/pagefile ? Using SQL 2000Whether it is in virtual memory or not depends on how much ram you have and
how you set your system up. As for what is in there I would suggest you
take a look in BooksOnLine under "memory, pool" and it's associated links in
addition to "Inside SQL 2000" which I know you have now<g>.
Andrew J. Kelly
SQL Server MVP
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:%23rFuqtE9DHA.3012@.TK2MSFTNGP09.phx.gbl...
> Whats in the buffer pool and whats in the memtoleave area ? Is this all in
> RAM or could it also be virtual memory/pagefile ? Using SQL 2000
>|||I didn't really talk about the memtoleave value in the book, but I discussed
it here
http://www.sqlmag.com/Articles/Inde...ArticleID=16522
The above article is several years old now, so it is freely accessible.
I also wrote two articles on memory in SQL Server Magazine last March and
April, but those are only available to subscribers, as they are less than a
year old.
http://www.sqlmag.com/Articles/Inde...ArticleID=37890
http://www.sqlmag.com/Articles/Inde...ArticleID=37908
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:#GqikKJ9DHA.1548@.tk2msftngp13.phx.gbl...
> Whether it is in virtual memory or not depends on how much ram you have
and
> how you set your system up. As for what is in there I would suggest you
> take a look in BooksOnLine under "memory, pool" and it's associated links
in
> addition to "Inside SQL 2000" which I know you have now<g>.
> --
> Andrew J. Kelly
> SQL Server MVP
>
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:%23rFuqtE9DHA.3012@.TK2MSFTNGP09.phx.gbl...
in
>|||Probably not but you do discuss the memory pool<g>.
Andrew J. Kelly
SQL Server MVP
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:uE1kiAL9DHA.2832@.tk2msftngp13.phx.gbl...
> I didn't really talk about the memtoleave value in the book, but I
discussed
> it here
> http://www.sqlmag.com/Articles/Inde...ArticleID=16522
> The above article is several years old now, so it is freely accessible.
> I also wrote two articles on memory in SQL Server Magazine last March and
> April, but those are only available to subscribers, as they are less than
a
> year old.
> http://www.sqlmag.com/Articles/Inde...ArticleID=37890
> http://www.sqlmag.com/Articles/Inde...ArticleID=37908
> --
> HTH
> --
> Kalen Delaney
> SQL Server MVP
> www.SolidQualityLearning.com
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:#GqikKJ9DHA.1548@.tk2msftngp13.phx.gbl...
> and
links
> in
all
> in
>|||Have a look at
http://msdn.microsoft.com/data/defa...ev_01262004.asp
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:%23rFuqtE9DHA.3012@.TK2MSFTNGP09.phx.gbl...
> Whats in the buffer pool and whats in the memtoleave area ? Is this all in
> RAM or could it also be virtual memory/pagefile ? Using SQL 2000
>|||That's a good one Jasper. How did I miss that?
Andrew J. Kelly
SQL Server MVP
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:eanijzL9DHA.2064@.TK2MSFTNGP11.phx.gbl...
> Have a look at
>
http://msdn.microsoft.com/data/defa...004.
asp
> --
> HTH
> Jasper Smith (SQL Server MVP)
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
>
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:%23rFuqtE9DHA.3012@.TK2MSFTNGP09.phx.gbl...
in
>

Buffer Pool vs MemToLeave Area

Whats in the buffer pool and whats in the memtoleave area ? Is this all in
RAM or could it also be virtual memory/pagefile ? Using SQL 2000Whether it is in virtual memory or not depends on how much ram you have and
how you set your system up. As for what is in there I would suggest you
take a look in BooksOnLine under "memory, pool" and it's associated links in
addition to "Inside SQL 2000" which I know you have now<g>.
--
Andrew J. Kelly
SQL Server MVP
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:%23rFuqtE9DHA.3012@.TK2MSFTNGP09.phx.gbl...
> Whats in the buffer pool and whats in the memtoleave area ? Is this all in
> RAM or could it also be virtual memory/pagefile ? Using SQL 2000
>|||I didn't really talk about the memtoleave value in the book, but I discussed
it here
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=16522
The above article is several years old now, so it is freely accessible.
I also wrote two articles on memory in SQL Server Magazine last March and
April, but those are only available to subscribers, as they are less than a
year old.
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=37890
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=37908
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:#GqikKJ9DHA.1548@.tk2msftngp13.phx.gbl...
> Whether it is in virtual memory or not depends on how much ram you have
and
> how you set your system up. As for what is in there I would suggest you
> take a look in BooksOnLine under "memory, pool" and it's associated links
in
> addition to "Inside SQL 2000" which I know you have now<g>.
> --
> Andrew J. Kelly
> SQL Server MVP
>
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:%23rFuqtE9DHA.3012@.TK2MSFTNGP09.phx.gbl...
> > Whats in the buffer pool and whats in the memtoleave area ? Is this all
in
> > RAM or could it also be virtual memory/pagefile ? Using SQL 2000
> >
> >
>|||Probably not but you do discuss the memory pool<g>.
--
Andrew J. Kelly
SQL Server MVP
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:uE1kiAL9DHA.2832@.tk2msftngp13.phx.gbl...
> I didn't really talk about the memtoleave value in the book, but I
discussed
> it here
> http://www.sqlmag.com/Articles/Index.cfm?ArticleID=16522
> The above article is several years old now, so it is freely accessible.
> I also wrote two articles on memory in SQL Server Magazine last March and
> April, but those are only available to subscribers, as they are less than
a
> year old.
> http://www.sqlmag.com/Articles/Index.cfm?ArticleID=37890
> http://www.sqlmag.com/Articles/Index.cfm?ArticleID=37908
> --
> HTH
> --
> Kalen Delaney
> SQL Server MVP
> www.SolidQualityLearning.com
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:#GqikKJ9DHA.1548@.tk2msftngp13.phx.gbl...
> > Whether it is in virtual memory or not depends on how much ram you have
> and
> > how you set your system up. As for what is in there I would suggest you
> > take a look in BooksOnLine under "memory, pool" and it's associated
links
> in
> > addition to "Inside SQL 2000" which I know you have now<g>.
> >
> > --
> >
> > Andrew J. Kelly
> > SQL Server MVP
> >
> >
> > "Hassan" <fatima_ja@.hotmail.com> wrote in message
> > news:%23rFuqtE9DHA.3012@.TK2MSFTNGP09.phx.gbl...
> > > Whats in the buffer pool and whats in the memtoleave area ? Is this
all
> in
> > > RAM or could it also be virtual memory/pagefile ? Using SQL 2000
> > >
> > >
> >
> >
>|||Have a look at
http://msdn.microsoft.com/data/default.aspx?pull=/library/en-us/dnsqldev/html/sqldev_01262004.asp
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:%23rFuqtE9DHA.3012@.TK2MSFTNGP09.phx.gbl...
> Whats in the buffer pool and whats in the memtoleave area ? Is this all in
> RAM or could it also be virtual memory/pagefile ? Using SQL 2000
>|||That's a good one Jasper. How did I miss that?
--
Andrew J. Kelly
SQL Server MVP
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:eanijzL9DHA.2064@.TK2MSFTNGP11.phx.gbl...
> Have a look at
>
http://msdn.microsoft.com/data/default.aspx?pull=/library/en-us/dnsqldev/html/sqldev_01262004.asp
> --
> HTH
> Jasper Smith (SQL Server MVP)
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
>
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:%23rFuqtE9DHA.3012@.TK2MSFTNGP09.phx.gbl...
> > Whats in the buffer pool and whats in the memtoleave area ? Is this all
in
> > RAM or could it also be virtual memory/pagefile ? Using SQL 2000
> >
> >
>

buffer pool only has data pages ?

Or does the buffer pool include procedure cache as well ?
I know in sql 2000, they have this mem to leave concept that I have heard is
no longer referred to in 2005. So whats it called in 2005?
ThanksCome on now Hassan this is getting beyond petty. Do you really expect
everyone to spoon feed you everything about SQL Server just because you
don't want to read a book or do a simple Google search. The answer to this
is certainly something you should already know by now but can be found in at
least 20 places with little trouble. Heck even BooksOnLine can answer that
question easily. 95% of the questions you ask here can be found in "Inside
SQL Server 2005" alone. Do everyone including yourself a favor and buy the
book and take a little time to read it. Or at least the sections that are
relevant to what you need to know at the time. You won't regret it.
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Hassan" <hassan@.test.com> wrote in message
news:Om2ZjtcZIHA.4696@.TK2MSFTNGP05.phx.gbl...
> Or does the buffer pool include procedure cache as well ?
> I know in sql 2000, they have this mem to leave concept that I have heard
> is no longer referred to in 2005. So whats it called in 2005?
> Thanks|||Andrew J. Kelly wrote:
> Come on now Hassan this is getting beyond petty. Do you really expect
> everyone to spoon feed you everything about SQL Server just because
> you don't want to read a book or do a simple Google search. The answer
> to this is certainly something you should already know by now but can
> be found in at least 20 places with little trouble. Heck even
> BooksOnLine can answer that question easily. 95% of the questions you
> ask here can be found in "Inside SQL Server 2005" alone. Do everyone
> including yourself a favor and buy the book and take a little time to
> read it. Or at least the sections that are relevant to what you need
> to know at the time. You won't regret it.
>
And neither will we :)