<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 1 of 3
1
2
3
»
»»
/3GB Switch
Rate Topic
Display Mode
Topic Options
Author
Message
MichaelJasson
MichaelJasson
Posted Tuesday, June 30, 2009 9:10 AM
SSC Journeyman
Group: General Forum Members
Last Login: Friday, June 03, 2011 4:58 PM
Points: 88,
Visits: 191
There is one requirement that I have to edit boot.ini file and make /3GB switch on in Vista
. I am not able to do that. I am a sql server DBA and I used to do this when I used to use win2000 and XP.
-MJ
-MJ
Please do not print mails and docx unless it is absolutely necessary. Spread environmental awareness.
Post #744511
GilaMonster
GilaMonster
Posted Tuesday, June 30, 2009 9:13 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 2:33 PM
Points: 37,741,
Visits: 30,019
MichaelJasson (6/30/2009)
There is one requirement that I have to edit boot.ini file and make /3GB switch on in Vista
.
Why do you want to do that?
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 #744513
Jeffrey Williams 3188
Jeffrey Williams 3188
Posted Tuesday, June 30, 2009 1:35 PM
SSCarpal Tunnel
Group: General Forum Members
Last Login: Friday, May 17, 2013 11:21 AM
Points: 4,317,
Visits: 9,216
I wouldn't think you would want to do that on Vista. If you are running on x86 hardware, then the maximum memory you are going to be able to address is 3GB. Setting that switch won't leave any memory to the OS.
If you are running x64 - that switch won't do anything anyways.
So, I'm with Gail on this one - why do you want to do this?
Jeffrey Williams
Problems are opportunites brilliantly disguised as insurmountable obstacles.
How to post questions to get better answers faster
Managing Transaction Logs
Post #744822
hi_abhay78
hi_abhay78
Posted Thursday, July 02, 2009 2:14 AM
SSC Veteran
Group: General Forum Members
Last Login: Thursday, July 26, 2012 10:06 AM
Points: 267,
Visits: 385
try BCDEdit.exe or Bootmgr.exe
Abhay Chaudhary
Sr.DBA (MCITP/MCTS :SQL Server 2005/2008 ,OCP 9i)
Post #746049
MichaelJasson
MichaelJasson
Posted Thursday, July 02, 2009 2:43 AM
SSC Journeyman
Group: General Forum Members
Last Login: Friday, June 03, 2011 4:58 PM
Points: 88,
Visits: 191
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
-MJ
Please do not print mails and docx unless it is absolutely necessary. Spread environmental awareness.
Post #746064
hi_abhay78
hi_abhay78
Posted Thursday, July 02, 2009 3:28 AM
SSC Veteran
Group: General Forum Members
Last Login: Thursday, July 26, 2012 10:06 AM
Points: 267,
Visits: 385
Cache is inside the buffer Pool ..its a subset .
Abhay Chaudhary
Sr.DBA (MCITP/MCTS :SQL Server 2005/2008 ,OCP 9i)
Post #746084
GilaMonster
GilaMonster
Posted Thursday, July 02, 2009 3:40 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 2:33 PM
Points: 37,741,
Visits: 30,019
MichaelJasson (7/2/2009)
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.
But we're talking a client OS. Doing this on a server that's dedicated to SQL is one thing, doing it on a client OS (especially one as memory-hungry as Vista) is something completely different.
Where is the SQL server that your app is using? One the Vista machine? If so, I recommend you move it to a proper server environment.
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 #746091
MichaelJasson
MichaelJasson
Posted Thursday, July 02, 2009 4:00 AM
SSC Journeyman
Group: General Forum Members
Last Login: Friday, June 03, 2011 4:58 PM
Points: 88,
Visits: 191
Thanks. Following link defines well about buffer pool and cache. Should I use the files you gave me to enable /3GB switch. Can you give me any link which tells me that I can use them as I am going to do this on a production server.
-MJ
Please do not print mails and docx unless it is absolutely necessary. Spread environmental awareness.
Post #746105
GilaMonster
GilaMonster
Posted Thursday, July 02, 2009 4:55 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 2:33 PM
Points: 37,741,
Visits: 30,019
MichaelJasson (7/2/2009)
Can you give me any link which tells me that I can use them as I am going to do this on a production server.
A production server running Vista? You sure?
Before you add anything, can you maybe give some more info as to exact OS version, SQL server, amount of memory in the server and 32 bit or 64 bit?
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 #746139
MichaelJasson
MichaelJasson
Posted Thursday, July 02, 2009 5:35 AM
SSC Journeyman
Group: General Forum Members
Last Login: Friday, June 03, 2011 4:58 PM
Points: 88,
Visits: 191
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.
My sql server version is as follows:
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)
I used DBCC MEMORYSTATUS and found many results. Out of which following gives enough information:
Available Physical Memory 342089728
Available Virtual Memory 844
Available Paging File 234
Working Set 133296128
Percent of Committed Memory in WS 100
Page Faults 5060377223231
System physical memory high 1
System physical memory low 0
Process physical memory low 0
Process virtual memory low 0
-MJ
Please do not print mails and docx unless it is absolutely necessary. Spread environmental awareness.
Post #746156
« Prev Topic
|
Next Topic »
21 posts, Page 1 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.
