/3GB Switch

Question

/3GB Switch

Viewing 6 posts - 16 through 20 (of 20 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

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.

and

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
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

Jeffrey Williams SSC Guru Points: 90304 More actions · Answer 2

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
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

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, MVP, M.Sc (Comp Sci)
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

MichaelJasson SSCrazy Points: 2732 More actions · Answer 4

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.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

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, MVP, M.Sc (Comp Sci)
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

MichaelJasson SSCrazy Points: 2732 More actions · Answer 6

Thanks Gila,

My question is answered in this discussion. Great info and thanks again to Gila and others.

-MJ
Please do not print mails and docx unless it is absolutely necessary. Spread environmental awareness.