<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
Administering
»
/3GB Switch
21 posts, Page 2 of 3
««
1
2
3
»»
/3GB Switch
Rate Topic
Display Mode
Topic Options
Author
Message
maechismo_8514
maechismo_8514
Posted Thursday, July 02, 2009 5:37 AM
Ten 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
GilaMonster
GilaMonster
Posted Thursday, July 02, 2009 5:47 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 4:49 PM
Points: 37,722,
Visits: 29,977
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
MichaelJasson
MichaelJasson
Posted Thursday, July 02, 2009 5:55 AM
SSC Journeyman
Group: General Forum Members
Last Login: Friday, June 03, 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
GilaMonster
GilaMonster
Posted Thursday, July 02, 2009 6:23 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 4:49 PM
Points: 37,722,
Visits: 29,977
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
Jeffrey Williams 3188
Jeffrey Williams 3188
Posted Thursday, July 02, 2009 8:49 AM
SSCarpal Tunnel
Group: General Forum Members
Last Login: Friday, May 17, 2013 11:21 AM
Points: 4,317,
Visits: 9,216
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
GilaMonster
GilaMonster
Posted Thursday, July 02, 2009 8:56 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 4:49 PM
Points: 37,722,
Visits: 29,977
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
Jeffrey Williams 3188
Jeffrey Williams 3188
Posted Thursday, July 02, 2009 9:27 AM
SSCarpal Tunnel
Group: General Forum Members
Last Login: Friday, May 17, 2013 11:21 AM
Points: 4,317,
Visits: 9,216
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
GilaMonster
GilaMonster
Posted Thursday, July 02, 2009 9:36 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 4:49 PM
Points: 37,722,
Visits: 29,977
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
MichaelJasson
MichaelJasson
Posted Friday, July 03, 2009 4:37 AM
SSC Journeyman
Group: General Forum Members
Last Login: Friday, June 03, 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
GilaMonster
GilaMonster
Posted Friday, July 03, 2009 8:31 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 4:49 PM
Points: 37,722,
Visits: 29,977
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 »
21 posts, Page 2 of 3
««
1
2
3
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
