Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««123»»

/3GB Switch Expand / Collapse
Author
Message
Posted Thursday, July 2, 2009 5:37 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, August 24, 2012 8:11 AM
Points: 1,097, Visits: 2,157
MichaelJasson (7/2/2009)
Thanks for your response SSCrazy and Gail.

The reason I want to do that is that my application is running very slow. I want to allocate more memory to sql server because page reads/sec and page writes/sec are really havoc.

/3GB would help me allocating one GB more to sql server and would help increasing the cache/Buffer by 1 GB.

I think Cache and Buffer are same thing. Correct me if I am wrong.

-MJ



You should give us more information regarding your environment as how much your memory is? what are the min and max memory settings on your SQL server. is it 32-bit or 64 bit? and also the reason that you want to switch on the /3GB? then we would be abel to give you a clearer idea.
Post #746158
Posted Thursday, July 2, 2009 5:47 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 3:06 PM
Points: 39,885, Visits: 36,231
MichaelJasson (7/2/2009)
Yes this is on Vista. My TL took a decision to have this on Vista and not Microsoft sql server 2008 which we proposed. I was not able to convince him with facts. Do you have any doc which informs me that this should not be on Vista.


Vista is a client operating system. It's for workstation machines, not servers. It's neither designed nor optimised for server apps. That you're running Vista instead of a server OS is very likely a major cause of memory problems. Vista is a memory hog and it uses a lot of resources to look good for the user.

Microsoft SQL Server 2008 (SP1) - 10.0.2714.0 (X64) May 14 2009 16:08:52


There's no point in you adding the /3GB switch. It will have no effect since both the OS and SQL are 64 bit. /3GB is only used on 32 bit operating systems to allow apps to access 3GB of memory instead of 2GB.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #746162
Posted Thursday, July 2, 2009 5:55 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, June 3, 2011 4:58 PM
Points: 88, Visits: 191
Thanks Gila for great info.

And this is not the only server we are using. There is one more server which is as follows:
Microsoft SQL Server 2000 - 8.00.2055 (Intel X86) Dec 16 2008 19:46:53 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

And DBCC Memorystats give following information:

Stolen 1412
Free 16
Procedures 6884
Inram 0
Dirty 9236747
Kept 0
I/O 0
Latched 64
Other 182


-MJ
Please do not print mails and docx unless it is absolutely necessary. Spread environmental awareness.
Post #746169
Posted Thursday, July 2, 2009 6:23 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 3:06 PM
Points: 39,885, Visits: 36,231
Is there a question there?

If you want advice on memory settings, you're going to specify the hardware in that server. Just seeing DBCC memory status alone says very little.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #746188
Posted Thursday, July 2, 2009 8:49 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 7:26 AM
Points: 4,358, Visits: 9,536
MichaelJasson (7/2/2009)
Microsoft SQL Server 2000 - 8.00.2055 (Intel X86) Dec 16 2008 19:46:53 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)


You are not running Windows Vista on your server. You are, in fact, running Windows Server 2003 Enterprise Edition SP2. This is also running on x64 hardware so you don't have to worry about setting /3GB, /PAE or AWE.

From what I have been able to see - it looks like your server has 32GB of memory. If you have not set a max of no more than 28GB of memory, your system is going to have problems. Is this a dedicated database server, or is it running other applications? If it is running other applications it is even more important that you set max memory.


Jeffrey Williams
Problems are opportunites brilliantly disguised as insurmountable obstacles.

How to post questions to get better answers faster
Managing Transaction Logs
Post #746337
Posted Thursday, July 2, 2009 8:56 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 3:06 PM
Points: 39,885, Visits: 36,231
Jeffrey Williams (7/2/2009)
MichaelJasson (7/2/2009)
Microsoft SQL Server 2000 - 8.00.2055 (Intel X86) Dec 16 2008 19:46:53 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)


You are not running Windows Vista on your server. You are, in fact, running Windows Server 2003 Enterprise Edition SP2. This is also running on x64 hardware so you don't have to worry about setting /3GB, /PAE or AWE.


He's got two different servers. The first one (running SQL 2008 x64) apparently is the Vista box, however Enterprise edition isn't supposed to run on Vista.

Microsoft SQL Server 2008 (SP1) - 10.0.2714.0 (X64) May 14 2009 16:08:52 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.0 (Build 6002: Service Pack 2) (VM)

and

Microsoft SQL Server 2000 - 8.00.2055 (Intel X86) Dec 16 2008 19:46:53 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #746348
Posted Thursday, July 2, 2009 9:27 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 7:26 AM
Points: 4,358, Visits: 9,536
GilaMonster (7/2/2009)
He's got two different servers. The first one (running SQL 2008 x64) apparently is the Vista box, however Enterprise edition isn't supposed to run on Vista.

Microsoft SQL Server 2008 (SP1) - 10.0.2714.0 (X64) May 14 2009 16:08:52 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.0 (Build 6002: Service Pack 2) (VM)

and

Microsoft SQL Server 2000 - 8.00.2055 (Intel X86) Dec 16 2008 19:46:53 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)


Neither of those are Vista - the first one is Windows Server 2008 Enterprise Edition SP2 (x64). The second one is Windows Server 2003 Enterprise Edition SP2 - x86.


Jeffrey Williams
Problems are opportunites brilliantly disguised as insurmountable obstacles.

How to post questions to get better answers faster
Managing Transaction Logs
Post #746380
Posted Thursday, July 2, 2009 9:36 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 3:06 PM
Points: 39,885, Visits: 36,231
Enterprise edition refers to SQL, not to the OS, but I too think that's Server 2008. SQL Enterprise edition only runs on Server 2003 and Server 2008. The editions of SQL that will run on Vista are Standard, Developer, Workgroup, Web and Express


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #746391
Posted Friday, July 3, 2009 4:37 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, June 3, 2011 4:58 PM
Points: 88, Visits: 191
Just to demystify the doubts.. enterprise edition can also run on Vista... Although this is memory hog... (Gila thanks for this info)

-MJ
Please do not print mails and docx unless it is absolutely necessary. Spread environmental awareness.
Post #746911
Posted Friday, July 3, 2009 8:31 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 3:06 PM
Points: 39,885, Visits: 36,231
Just got some clarification on this.

SQL Enterprise can be installed on Vista. It is not, however, a supported configuration. This means that should you call customer support with a problem regarding this server, they will not help you. Probably they'll tell you to reinstall SQL on a supported operating system and call back if the problem persists.

Now, what was your question on the SQL 2000 on Server 2003 server?



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #747009
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse