3G ram for SQL server: utilization

Showing posts with label utilization. Show all posts

Monday, March 19, 2012

8Gb RAM for SQL Server 2000 on Win 2003

What the setting should be (/3Gb, PAE, AWE) for the best utilization of
8GB RAM for SQL Server 2000 running on Win 2003?
ThanksHi,
After this you will have to do this:-
Probably you could configure 6 GB for SQL Server: Login as SA using query
analyzer and do:-
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
sp_configure 'max server memory', 6144
RECONFIGURE
GO
Thanks
Hari
SQL Server MVP
"vlad" <vesmusor@.yahoo.com> wrote in message
news:1158846464.619887.179240@.h48g2000cwc.googlegroups.com...
> What the setting should be (/3Gb, PAE, AWE) for the best utilization of
> 8GB RAM for SQL Server 2000 running on Win 2003?
> Thanks
>|||Thanks for your reply, Hari. Does it mean I need to use both /3GB and
/PAE switches for this configuration?
Hari Prasad wrote:
> Hi,
> After this you will have to do this:-
> Probably you could configure 6 GB for SQL Server: Login as SA using query
> analyzer and do:-
> sp_configure 'show advanced options', 1
> RECONFIGURE
> GO
> sp_configure 'awe enabled', 1
> RECONFIGURE
> GO
> sp_configure 'max server memory', 6144
> RECONFIGURE
> GO
> Thanks
> Hari
> SQL Server MVP
> "vlad" <vesmusor@.yahoo.com> wrote in message
> news:1158846464.619887.179240@.h48g2000cwc.googlegroups.com...
> > What the setting should be (/3Gb, PAE, AWE) for the best utilization of
> > 8GB RAM for SQL Server 2000 running on Win 2003?
> >
> > Thanks
> >|||You need to use PAE (and SQL Server use AWE) to have 32 but app on 32 bit OS access > 2GB memory.
Whether you use 3GB or not is up to you. For a system with 8BG memory, it is probably a good idea to
use 3GB. Google for "Slava Oks" and read the Blogs, this will give you more information so you
understand the ins and outs of setting 3GB, PAE and also AWE.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"vlad" <vesmusor@.yahoo.com> wrote in message
news:1158848235.068934.133350@.i42g2000cwa.googlegroups.com...
> Thanks for your reply, Hari. Does it mean I need to use both /3GB and
> /PAE switches for this configuration?
> Hari Prasad wrote:
>> Hi,
>> After this you will have to do this:-
>> Probably you could configure 6 GB for SQL Server: Login as SA using query
>> analyzer and do:-
>> sp_configure 'show advanced options', 1
>> RECONFIGURE
>> GO
>> sp_configure 'awe enabled', 1
>> RECONFIGURE
>> GO
>> sp_configure 'max server memory', 6144
>> RECONFIGURE
>> GO
>> Thanks
>> Hari
>> SQL Server MVP
>> "vlad" <vesmusor@.yahoo.com> wrote in message
>> news:1158846464.619887.179240@.h48g2000cwc.googlegroups.com...
>> > What the setting should be (/3Gb, PAE, AWE) for the best utilization of
>> > 8GB RAM for SQL Server 2000 running on Win 2003?
>> >
>> > Thanks
>> >
>|||Doesn't this all assume he's running Enterprise Edition of SQL Server?
I thought non enterprise version didn't address this much RAM?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eHS1C9a3GHA.3344@.TK2MSFTNGP05.phx.gbl...
> You need to use PAE (and SQL Server use AWE) to have 32 but app on 32 bit
> OS access > 2GB memory.
> Whether you use 3GB or not is up to you. For a system with 8BG memory, it
> is probably a good idea to use 3GB. Google for "Slava Oks" and read the
> Blogs, this will give you more information so you understand the ins and
> outs of setting 3GB, PAE and also AWE.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "vlad" <vesmusor@.yahoo.com> wrote in message
> news:1158848235.068934.133350@.i42g2000cwa.googlegroups.com...
>> Thanks for your reply, Hari. Does it mean I need to use both /3GB and
>> /PAE switches for this configuration?
>> Hari Prasad wrote:
>> Hi,
>> After this you will have to do this:-
>> Probably you could configure 6 GB for SQL Server: Login as SA using
>> query
>> analyzer and do:-
>> sp_configure 'show advanced options', 1
>> RECONFIGURE
>> GO
>> sp_configure 'awe enabled', 1
>> RECONFIGURE
>> GO
>> sp_configure 'max server memory', 6144
>> RECONFIGURE
>> GO
>> Thanks
>> Hari
>> SQL Server MVP
>> "vlad" <vesmusor@.yahoo.com> wrote in message
>> news:1158846464.619887.179240@.h48g2000cwc.googlegroups.com...
>> > What the setting should be (/3Gb, PAE, AWE) for the best utilization
>> > of
>> > 8GB RAM for SQL Server 2000 running on Win 2003?
>> >
>> > Thanks
>> >
>|||Correct. I assumed EE as no edition was mentioned in the original post...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Nick" <no.thanks@.nowhere.com> wrote in message news:enNh7uk3GHA.1796@.TK2MSFTNGP06.phx.gbl...
> Doesn't this all assume he's running Enterprise Edition of SQL Server?
> I thought non enterprise version didn't address this much RAM?
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:eHS1C9a3GHA.3344@.TK2MSFTNGP05.phx.gbl...
>> You need to use PAE (and SQL Server use AWE) to have 32 but app on 32 bit
>> OS access > 2GB memory.
>> Whether you use 3GB or not is up to you. For a system with 8BG memory, it
>> is probably a good idea to use 3GB. Google for "Slava Oks" and read the
>> Blogs, this will give you more information so you understand the ins and
>> outs of setting 3GB, PAE and also AWE.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "vlad" <vesmusor@.yahoo.com> wrote in message
>> news:1158848235.068934.133350@.i42g2000cwa.googlegroups.com...
>> Thanks for your reply, Hari. Does it mean I need to use both /3GB and
>> /PAE switches for this configuration?
>> Hari Prasad wrote:
>> Hi,
>> After this you will have to do this:-
>> Probably you could configure 6 GB for SQL Server: Login as SA using
>> query
>> analyzer and do:-
>> sp_configure 'show advanced options', 1
>> RECONFIGURE
>> GO
>> sp_configure 'awe enabled', 1
>> RECONFIGURE
>> GO
>> sp_configure 'max server memory', 6144
>> RECONFIGURE
>> GO
>> Thanks
>> Hari
>> SQL Server MVP
>> "vlad" <vesmusor@.yahoo.com> wrote in message
>> news:1158846464.619887.179240@.h48g2000cwc.googlegroups.com...
>> > What the setting should be (/3Gb, PAE, AWE) for the best utilization
>> > of
>> > 8GB RAM for SQL Server 2000 running on Win 2003?
>> >
>> > Thanks
>> >
>>
>

8Gb RAM for SQL Server 2000 on Win 2003

Saturday, February 11, 2012

4 CPU Utilization Imbalance

Got a strange thing happening, any comments are appreciated:

1) 4 CPU server
2) CPU's 0 & 2 are usually below 15% or so utilization (Perfmon, Task Manager)
3) CPU's 1 & 3 are usually nearly maxed out above 90%
4) Two SQL threads of over 80 threads in Perfmon show almost constant 90% Processor Time
5) Processor affinity in Server Properties is checked to use all four processors
6) Hyper-threading is not enabled
7) SQL Server priority is checked on HIGH
8) Dedicated SQL Server

Anybody know how to track down what those specific threads are executing? Any ideas, anybody? Thanks for the help!

SteveRefer to this link (http://www.sql-server-performance.com/dbcc_commands.asp) for useful DBCC commands and capture the events.|||Satya, thanks for the reply, and the link to the highly useful web site. I was able to trace the thread activity using Perfmon and sysprocesses; successfully killed a couple non-responsive threads and things returned to normal. I appreciate the help!

Steve|||True, keep in touch with the link provided for the tips and tricks on the performance.

Monday, March 19, 2012

8Gb RAM for SQL Server 2000 on Win 2003

8Gb RAM for SQL Server 2000 on Win 2003

8Gb RAM for SQL Server 2000 on Win 2003

Saturday, February 11, 2012

4 CPU Utilization Imbalance

3G ram for SQL server

Blog Archive

About Me