32bit vs 64bit SQL 2005

Just curious if anyone has any numbers for this.
We have a customer that has their server running windows server 64bit.
But, SQL 2005 loaded on it is only 32bit. What would be the benefits
(speed mainly) of upgrading to 64bit SQL - in numbers - like a 25%
increase, or something like that. Or, is there some certain issue when
running the 32bit SQL on 64bit OS that I need to be aware of.
TIA
Darin
*** Sent via Developersdex http://www.codecomments.com ***
The immediate benefit would be an improvement in the accessibility of memory
past 2GB (you wouldn't need to have AWE enabled - and AWE has restrictions
and is slow to deal with compared to normal memory).
I personally wouldn't expect a massive performance difference between 32-bit
vs. 64-bit on a 64-bit box, although 25% might not be unrealistic (have seen
this kind of performance difference with 32-bit Integration Services running
on a 64-bit box).
"Darin" <darin_nospam@.nospamever> wrote in message
news:u0FNa53WIHA.484@.TK2MSFTNGP06.phx.gbl...
> Just curious if anyone has any numbers for this.
> We have a customer that has their server running windows server 64bit.
> But, SQL 2005 loaded on it is only 32bit. What would be the benefits
> (speed mainly) of upgrading to 64bit SQL - in numbers - like a 25%
> increase, or something like that. Or, is there some certain issue when
> running the 32bit SQL on 64bit OS that I need to be aware of.
> TIA
> Darin
> *** Sent via Developersdex http://www.codecomments.com ***
|||I don't know that there can be an explicit across the board answer for this
situation. It probably depends on the load on the server. The more heavily
loaded the server runs the better the 64bit sql server install should
perform.
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"Darin" <darin_nospam@.nospamever> wrote in message
news:u0FNa53WIHA.484@.TK2MSFTNGP06.phx.gbl...
> Just curious if anyone has any numbers for this.
> We have a customer that has their server running windows server 64bit.
> But, SQL 2005 loaded on it is only 32bit. What would be the benefits
> (speed mainly) of upgrading to 64bit SQL - in numbers - like a 25%
> increase, or something like that. Or, is there some certain issue when
> running the 32bit SQL on 64bit OS that I need to be aware of.
> TIA
> Darin
> *** Sent via Developersdex http://www.codecomments.com ***
|||I don't think you can really quantify the performance without actually
running tests in your environment. See
http://blogs.msdn.com/sqlprogrammability/default.aspx.
Hope this helps.
Dan Guzman
SQL Server MVP
"Darin" <darin_nospam@.nospamever> wrote in message
news:u0FNa53WIHA.484@.TK2MSFTNGP06.phx.gbl...
> Just curious if anyone has any numbers for this.
> We have a customer that has their server running windows server 64bit.
> But, SQL 2005 loaded on it is only 32bit. What would be the benefits
> (speed mainly) of upgrading to 64bit SQL - in numbers - like a 25%
> increase, or something like that. Or, is there some certain issue when
> running the 32bit SQL on 64bit OS that I need to be aware of.
> TIA
> Darin
> *** Sent via Developersdex http://www.codecomments.com ***
|||This server is the distributor for 2 replicated subscribers.
One question - does 32bit SQL 2005 ONLY use 2GB RAM? If so, that to me
is enough reason to upgrade.
All 3 servers have 64bit Windows but are only running 32bit SQL2005.
Also, the distributor has 3GB RAM, one subscriber has 4GB and the other
has 2.93GB RAM. I have told their IT person to put at least 4GB on the
distributor since that is in the main office w/ the most users, and is
handling the replication.
Darin
*** Sent via Developersdex http://www.codecomments.com ***
|||> One question - does 32bit SQL 2005 ONLY use 2GB RAM? If so, that to me
> is enough reason to upgrade.
Memory in Standard Edition (and above) is limited only by the OS. However,
in 32-bit versions, memory beyond 3GB can be used only for data buffer cache
and is addressable only via AWE. One the the reasons to migrate to 64-bit
is that memory beyond 3GB can be used for other memory needs, like procedure
cache.
Hope this helps.
Dan Guzman
SQL Server MVP
"Darin" <darin_nospam@.nospamever> wrote in message
news:eGsq6P4WIHA.5132@.TK2MSFTNGP02.phx.gbl...
> This server is the distributor for 2 replicated subscribers.
> One question - does 32bit SQL 2005 ONLY use 2GB RAM? If so, that to me
> is enough reason to upgrade.
> All 3 servers have 64bit Windows but are only running 32bit SQL2005.
> Also, the distributor has 3GB RAM, one subscriber has 4GB and the other
> has 2.93GB RAM. I have told their IT person to put at least 4GB on the
> distributor since that is in the main office w/ the most users, and is
> handling the replication.
> Darin
> *** Sent via Developersdex http://www.codecomments.com ***

32bit vs 64bit SQL 2005

Just curious if anyone has any numbers for this.
We have a customer that has their server running windows server 64bit.
But, SQL 2005 loaded on it is only 32bit. What would be the benefits
(speed mainly) of upgrading to 64bit SQL - in numbers - like a 25%
increase, or something like that. Or, is there some certain issue when
running the 32bit SQL on 64bit OS that I need to be aware of.
TIA
Darin
*** Sent via Developersdex http://www.developersdex.com ***The immediate benefit would be an improvement in the accessibility of memory
past 2GB (you wouldn't need to have AWE enabled - and AWE has restrictions
and is slow to deal with compared to normal memory).
I personally wouldn't expect a massive performance difference between 32-bit
vs. 64-bit on a 64-bit box, although 25% might not be unrealistic (have seen
this kind of performance difference with 32-bit Integration Services running
on a 64-bit box).
"Darin" <darin_nospam@.nospamever> wrote in message
news:u0FNa53WIHA.484@.TK2MSFTNGP06.phx.gbl...
> Just curious if anyone has any numbers for this.
> We have a customer that has their server running windows server 64bit.
> But, SQL 2005 loaded on it is only 32bit. What would be the benefits
> (speed mainly) of upgrading to 64bit SQL - in numbers - like a 25%
> increase, or something like that. Or, is there some certain issue when
> running the 32bit SQL on 64bit OS that I need to be aware of.
> TIA
> Darin
> *** Sent via Developersdex http://www.developersdex.com ***|||I don't know that there can be an explicit across the board answer for this
situation. It probably depends on the load on the server. The more heavily
loaded the server runs the better the 64bit sql server install should
perform.
--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"Darin" <darin_nospam@.nospamever> wrote in message
news:u0FNa53WIHA.484@.TK2MSFTNGP06.phx.gbl...
> Just curious if anyone has any numbers for this.
> We have a customer that has their server running windows server 64bit.
> But, SQL 2005 loaded on it is only 32bit. What would be the benefits
> (speed mainly) of upgrading to 64bit SQL - in numbers - like a 25%
> increase, or something like that. Or, is there some certain issue when
> running the 32bit SQL on 64bit OS that I need to be aware of.
> TIA
> Darin
> *** Sent via Developersdex http://www.developersdex.com ***|||I don't think you can really quantify the performance without actually
running tests in your environment. See
http://blogs.msdn.com/sqlprogrammability/default.aspx.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Darin" <darin_nospam@.nospamever> wrote in message
news:u0FNa53WIHA.484@.TK2MSFTNGP06.phx.gbl...
> Just curious if anyone has any numbers for this.
> We have a customer that has their server running windows server 64bit.
> But, SQL 2005 loaded on it is only 32bit. What would be the benefits
> (speed mainly) of upgrading to 64bit SQL - in numbers - like a 25%
> increase, or something like that. Or, is there some certain issue when
> running the 32bit SQL on 64bit OS that I need to be aware of.
> TIA
> Darin
> *** Sent via Developersdex http://www.developersdex.com ***sql

2005Express trying to enable Full text indexing.

We have an installation of SQL2005 Express that was loaded via the "SQL2005Express with advanced services" download .exe.

Full text indexing wasn't enabled during installation.

It says to go to add/remove programs. Going that route when it goes to install FTI it says that it can't find the installation files in what looks to be the origonal "TEMP" folder created and removed during installation.

If I run the program installer from the download again it states that SQL is already installed and to use "add/remove programs".

We are stuck at this point. Is there an ISO available that could be burned to disk?

Thanks in advance.

We've seen this error a few times during Express reinstalls and I haven't heard of a nice solution. One option is to backup your databases, uninstall your Express instance and reinstall it with FTI enabled.

Thanks,
Sam Lester (MSFT)

|||

What you should be able to do is run the original program installer from a command line with the "\X" switch. This will display a dialog that will allow you to extract the files inside the package to wherever you want. You should be able to put them anywhere you like on you local hard drive. Then when you use Add/Remove programs to maintain your Express instance, and it asks for the files, make sure you browse to the "Setup" directory underneath where you extracted the bits. That should work without you having to uninstall your existing instance.

|||This will also be documented in the requirementssqlexp2005.htm file located at the root of the folder where you extracted out the bits. It is under the section titled "Modifying SQL Server Express Installed Components".|||After unpackaging using /x I get the following error, when trying to add FTI via the "add remove programs".

"The file G:\myfilepath is not a valid installation package for the product Microsoft SQL Server 2005 (SQLEXPRESS). Try to find the installation package 'sqlrun_sql.msi' in a folder in which you can install Microsoft SQL Server 2005 (SQLEXPRESS)."

The file is there in the folder.

Any other ideas short of uninstalling/reinstalling?|||

You need to make sure to browse to the "Setup" folder underneath where you extracted. If the setup folder is not there, than the extraction may not be correct. G:\myfilepath should contain a setup.exe file, and then a setup folder. In the setup folder there should be a bunch of MSIs, one of which is sqlrun_sql.msi.

Also, make sure the Sqlexpr.exe you are running to extract is the same as what was used initially to install. If the editions don't match than you could see that error as well. For example, don't mix and match SQL Express with SQL Express with Advanced Services.

|||I did point to the file in the setup folder (it was there).

This is the same .exe that was downloaded one month ago.|||I just tried this out myself and it does appear to work, so hopefully this should be easy to resolve. Could you post two logs so I can see what might be failing for you? Both the latest *_WI.log and *_SQL.log files would be needed (located in %programfiles%\microsoft sql server\90\setup bootstrap\log), thank you!|||

Sorry, I'm new here and didn't realize you can't post attachments. Here is what I need from the *_WI.log. Search for this string:

Doing action: ResolveSource

And then copy and paste the contents of the log up until this string:

ResolveSource. Return value

Let's just start with that, and then see if I need the *_SQL.log.

2005 no client tools installed

I have a customer that their IT "expert" loaded SQL Server 2005, but
only the database - no other tools, so the SQL Server Management Studio
isn't loaded. Then, the SP for SQL 2005 has been installed on the
machine. Now, I can't load the Management studio because the version are
different - it returns a message about getting a correct version of
sqlcnli.msi.
My main reason to get this is I need to change the SQL security to allow
both windows and SQL security, and I need to set the password for SA. I
know I can change the password via osql -E, but is there a way to change
the main security mode of SQL to allow both windows and SQL from the
osql prompt? If so, what command will do it.
Secondly, what options do I have to get the management studio loaded
since the SP has already been loaded?
Thanks in advance.
Darin
*** Sent via Developersdex http://www.codecomments.com ***>I have a customer that their IT "expert" loaded SQL Server 2005, but
> only the database - no other tools, so the SQL Server Management Studio
> isn't loaded. Then, the SP for SQL 2005 has been installed on the
> machine. Now, I can't load the Management studio because the version are
> different - it returns a message about getting a correct version of
> sqlcnli.msi.
You can download and install sqlncli.msi separately, install it, then run
the SQL Seer 2005 setup again and you should be able to install the client
tools.

> My main reason to get this is I need to change the SQL security to allow
> both windows and SQL security, and I need to set the password for SA.
Can't you do the former from the Configuration Manager and/or Surface Area
Configuration tool? Those should be there.
A|||Where can I download the sqlcnli.msi from?
Also, I looked on the configuration and the surface manager and couldn't
find on either where the security mode for SQL is set.
Darin
*** Sent via Developersdex http://www.codecomments.com ***|||Also, I tried to run sqlncli.msi off the CD and received:
Installation of MS Sql Server Native CLient failed baecause a higher
version already exists on the machine. To proceed, uninstall the higher
version and then run MS SQL Server Native Client Setup again.
Darin
*** Sent via Developersdex http://www.codecomments.com ***|||> the SQL Seer 2005
Is that the new "Predictive Assessment Tool" I've been hoping for?
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in mess
age
news:%236uQj5THHHA.4112@.TK2MSFTNGP04.phx.gbl...
> You can download and install sqlncli.msi separately, install it, then run
> the SQL Seer 2005 setup again and you should be able to install the client
> tools.
>
> Can't you do the former from the Configuration Manager and/or Surface Area
> Configuration tool? Those should be there.
> A
>|||Dang, I don't typically miss two letters. :-\
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:On2Z1fUHHHA.4068@.TK2MSFTNGP03.phx.gbl...
> Is that the new "Predictive Assessment Tool" I've been hoping for?

2005 no client tools installed

I have a customer that their IT "expert" loaded SQL Server 2005, but
only the database - no other tools, so the SQL Server Management Studio
isn't loaded. Then, the SP for SQL 2005 has been installed on the
machine. Now, I can't load the Management studio because the version are
different - it returns a message about getting a correct version of
sqlcnli.msi.
My main reason to get this is I need to change the SQL security to allow
both windows and SQL security, and I need to set the password for SA. I
know I can change the password via osql -E, but is there a way to change
the main security mode of SQL to allow both windows and SQL from the
osql prompt? If so, what command will do it.
Secondly, what options do I have to get the management studio loaded
since the SP has already been loaded?
Thanks in advance.
Darin
*** Sent via Developersdex http://www.codecomments.com ***
>I have a customer that their IT "expert" loaded SQL Server 2005, but
> only the database - no other tools, so the SQL Server Management Studio
> isn't loaded. Then, the SP for SQL 2005 has been installed on the
> machine. Now, I can't load the Management studio because the version are
> different - it returns a message about getting a correct version of
> sqlcnli.msi.
You can download and install sqlncli.msi separately, install it, then run
the SQL Seer 2005 setup again and you should be able to install the client
tools.

> My main reason to get this is I need to change the SQL security to allow
> both windows and SQL security, and I need to set the password for SA.
Can't you do the former from the Configuration Manager and/or Surface Area
Configuration tool? Those should be there.
A
|||Where can I download the sqlcnli.msi from?
Also, I looked on the configuration and the surface manager and couldn't
find on either where the security mode for SQL is set.
Darin
*** Sent via Developersdex http://www.codecomments.com ***
|||Also, I tried to run sqlncli.msi off the CD and received:
Installation of MS Sql Server Native CLient failed baecause a higher
version already exists on the machine. To proceed, uninstall the higher
version and then run MS SQL Server Native Client Setup again.
Darin
*** Sent via Developersdex http://www.codecomments.com ***
|||> the SQL Seer 2005
Is that the new "Predictive Assessment Tool" I've been hoping for?
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:%236uQj5THHHA.4112@.TK2MSFTNGP04.phx.gbl...
> You can download and install sqlncli.msi separately, install it, then run
> the SQL Seer 2005 setup again and you should be able to install the client
> tools.
>
> Can't you do the former from the Configuration Manager and/or Surface Area
> Configuration tool? Those should be there.
> A
>
|||Dang, I don't typically miss two letters. :-\
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:On2Z1fUHHHA.4068@.TK2MSFTNGP03.phx.gbl...
> Is that the new "Predictive Assessment Tool" I've been hoping for?

2005 no client tools installed

I have a customer that their IT "expert" loaded SQL Server 2005, but
only the database - no other tools, so the SQL Server Management Studio
isn't loaded. Then, the SP for SQL 2005 has been installed on the
machine. Now, I can't load the Management studio because the version are
different - it returns a message about getting a correct version of
sqlcnli.msi.
My main reason to get this is I need to change the SQL security to allow
both windows and SQL security, and I need to set the password for SA. I
know I can change the password via osql -E, but is there a way to change
the main security mode of SQL to allow both windows and SQL from the
osql prompt? If so, what command will do it.
Secondly, what options do I have to get the management studio loaded
since the SP has already been loaded?
Thanks in advance.
Darin
*** Sent via Developersdex http://www.developersdex.com ***>I have a customer that their IT "expert" loaded SQL Server 2005, but
> only the database - no other tools, so the SQL Server Management Studio
> isn't loaded. Then, the SP for SQL 2005 has been installed on the
> machine. Now, I can't load the Management studio because the version are
> different - it returns a message about getting a correct version of
> sqlcnli.msi.
You can download and install sqlncli.msi separately, install it, then run
the SQL Seer 2005 setup again and you should be able to install the client
tools.
> My main reason to get this is I need to change the SQL security to allow
> both windows and SQL security, and I need to set the password for SA.
Can't you do the former from the Configuration Manager and/or Surface Area
Configuration tool? Those should be there.
A|||> the SQL Seer 2005
Is that the new "Predictive Assessment Tool" I've been hoping for?
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:%236uQj5THHHA.4112@.TK2MSFTNGP04.phx.gbl...
> >I have a customer that their IT "expert" loaded SQL Server 2005, but
>> only the database - no other tools, so the SQL Server Management Studio
>> isn't loaded. Then, the SP for SQL 2005 has been installed on the
>> machine. Now, I can't load the Management studio because the version are
>> different - it returns a message about getting a correct version of
>> sqlcnli.msi.
> You can download and install sqlncli.msi separately, install it, then run
> the SQL Seer 2005 setup again and you should be able to install the client
> tools.
>> My main reason to get this is I need to change the SQL security to allow
>> both windows and SQL security, and I need to set the password for SA.
> Can't you do the former from the Configuration Manager and/or Surface Area
> Configuration tool? Those should be there.
> A
>|||Dang, I don't typically miss two letters. :-\
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:On2Z1fUHHHA.4068@.TK2MSFTNGP03.phx.gbl...
>> the SQL Seer 2005
> Is that the new "Predictive Assessment Tool" I've been hoping for?