Processor + Memory

Hi,
Can anybody direct me to an article or an white paper, which explains SQL Server 2000 Processor and Memory architecture and how they work together
Lets take a scenario
SQL Server 2000 Enterprise edition, 8GB of physical memory and 4 processors (same server) are available.
So some of the questions that I have in my mind are
(a) How can we distribute 8GB of memory across these 4 processor. How do we configure it
(b) Can we control, the size of memory distributed across these processor. That is, can I configure 5 GB of memory to one processor and the rest equally distributed to other processors? If yes, how do we go about it
(c) How does SQL Server parallel processing works
(d) I understand that AWE is used to increase the memory capacity for sql server app, if the memory of the server is more than 4 GB, but how exactly is this done?
Would really appreciate, if someone can provide me the link to the right article or if someone can take sometime to explain me this
Thanks very muc
GYKGYK wrote:
> Hi,
> Can anybody direct me to an article or an white paper, which explains SQL Server 2000 Processor and Memory architecture and how they work together?
No link, but the book Inside SQL-Server 2000 by Kalen Delaney explains
in great detail the internals of SQL-Server.
> Lets take a scenario;
> SQL Server 2000 Enterprise edition, 8GB of physical memory and 4 processors (same server) are available.
> So some of the questions that I have in my mind are;
> (a) How can we distribute 8GB of memory across these 4 processor. How do we configure it?
IFAIK you can't. This is done automatically and dynamically by
SQL-Server. These sound like features you might find in an Operating
System, not in a RDBMS. There is only one setting you can make: you can
determine the amount of memory that is available to SQL-Server (in
total).
> (b) Can we control, the size of memory distributed across these processor. That is, can I configure 5 GB of memory to one processor and the rest equally distributed to other processors? If yes, how do we go about it?
Not with SQL-Server. This would be an OS requirement. The memory
SQL-Server uses is exclusively reserved for SQL-Server, and not shared
with other applications. Since SQL-Server manages its memory, it doesn't
make sense to assign individual blocks of memory to individual CPU's.
> (c) How does SQL Server parallel processing works?
In a nutshell: by having multiple threads working on a query, where each
thread is handled by a different CPU. It will be used if SQL-Server
estimates it will decrease the total elapsed time of the query.
> (d) I understand that AWE is used to increase the memory capacity for sql server app, if the memory of the server is more than 4 GB, but how exactly is this done?
> Would really appreciate, if someone can provide me the link to the right article or if someone can take sometime to explain me this.
> Thanks very much
> GYK
Hope this helps,
Gert-Jan|||In addition to Kalen's excellent "Inside SQL Server 2000" there's also a
fair bit on memory architecture in BOL plus there's also Ken Hendersons new
book "The Guru's Guide to SQL Server Architecture and Internals" that really
gets into the nitty gritty of UMS and memory architecture including AWE
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"GYK" <anonymous@.discussions.microsoft.com> wrote in message
news:439E3FF7-340A-4A35-8BFE-93C26F570BAB@.microsoft.com...
> Hi,
> Can anybody direct me to an article or an white paper, which explains SQL
Server 2000 Processor and Memory architecture and how they work together?
> Lets take a scenario;
> SQL Server 2000 Enterprise edition, 8GB of physical memory and 4
processors (same server) are available.
> So some of the questions that I have in my mind are;
> (a) How can we distribute 8GB of memory across these 4 processor. How do
we configure it?
> (b) Can we control, the size of memory distributed across these processor.
That is, can I configure 5 GB of memory to one processor and the rest
equally distributed to other processors? If yes, how do we go about it?
> (c) How does SQL Server parallel processing works?
> (d) I understand that AWE is used to increase the memory capacity for sql
server app, if the memory of the server is more than 4 GB, but how exactly
is this done?
> Would really appreciate, if someone can provide me the link to the right
article or if someone can take sometime to explain me this.
> Thanks very much
> GYK|||Absolutely! Ken's book goes into the next level down from mine, discussing
the details of the OS architecture that allow SQL Server to do what it does.
I'm only in the middle of the third chapter, and I've learned a lot!
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:ONkNv8kxDHA.3744@.TK2MSFTNGP11.phx.gbl...
> In addition to Kalen's excellent "Inside SQL Server 2000" there's also a
> fair bit on memory architecture in BOL plus there's also Ken Hendersons
new
> book "The Guru's Guide to SQL Server Architecture and Internals" that
really
> gets into the nitty gritty of UMS and memory architecture including AWE
> --
> HTH
> Jasper Smith (SQL Server MVP)
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
>
> "GYK" <anonymous@.discussions.microsoft.com> wrote in message
> news:439E3FF7-340A-4A35-8BFE-93C26F570BAB@.microsoft.com...
> > Hi,
> >
> > Can anybody direct me to an article or an white paper, which explains
SQL
> Server 2000 Processor and Memory architecture and how they work together?
> >
> > Lets take a scenario;
> > SQL Server 2000 Enterprise edition, 8GB of physical memory and 4
> processors (same server) are available.
> >
> > So some of the questions that I have in my mind are;
> > (a) How can we distribute 8GB of memory across these 4 processor. How do
> we configure it?
> > (b) Can we control, the size of memory distributed across these
processor.
> That is, can I configure 5 GB of memory to one processor and the rest
> equally distributed to other processors? If yes, how do we go about it?
> > (c) How does SQL Server parallel processing works?
> > (d) I understand that AWE is used to increase the memory capacity for
sql
> server app, if the memory of the server is more than 4 GB, but how exactly
> is this done?
> >
> > Would really appreciate, if someone can provide me the link to the right
> article or if someone can take sometime to explain me this.
> >
> > Thanks very much
> > GYK
>