32 bit clients apps on 64 bit SQL Server

I need some confirmation. Is there any document from Microsoft that states n
o
changes need to be made to 32Bit Windows based Client/Server apps to access
data on a 64Bit SQL Server?
We code with VB6 an use MDAC to access our SQL Server DB, if a client wants
to move his SQL Server to a 64Bit machine and purchase a 64Bit SQL version,
we need to confirm that our will still work on his platform.
I am sure it will seeing as the DB engine is a seperate entity from our
application, but I just need an official document or link to a MS webpage
that states this.
Thanks.Hi
http://www.microsoft.com/sql/64bit/...o/overview.mspx
and especially
http://www.microsoft.com/sql/64bit/.../datasheet.mspx
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Poncho@.home" wrote:

> I need some confirmation. Is there any document from Microsoft that states
no
> changes need to be made to 32Bit Windows based Client/Server apps to acces
s
> data on a 64Bit SQL Server?
> We code with VB6 an use MDAC to access our SQL Server DB, if a client want
s
> to move his SQL Server to a 64Bit machine and purchase a 64Bit SQL version
,
> we need to confirm that our will still work on his platform.
> I am sure it will seeing as the DB engine is a seperate entity from our
> application, but I just need an official document or link to a MS webpage
> that states this.
> Thanks.|||Thanks, that is exactly what I needed.
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> http://www.microsoft.com/sql/64bit/...o/overview.mspx
> and especially
> http://www.microsoft.com/sql/64bit/.../datasheet.mspx
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Poncho@.home" wrote:
>

2005 Max CPU's

I need some clarification on the maximum number of CPUs that will be used by
SQL Server Standard Edition. The documentation states that 4 CPUs is the
maximum for Standard. If those 4 CPUs are dual core, will SQL Server
utilize all 8 logical CPUs? I read some posts that indicated that only 4
of the 8 logical CPUs will be used by SQL Server Standard Edition. Is this
true?
Thanks!
ChrisChris,
CPUs are physical chips, whether single, dual, or quad core. In a
conversation from a few months ago Jens K. Suessmeyer pointed to the
explanation about SQL Server Express over the same issue:
http://support.microsoft.com/kb/914278/en-us
RLF
"Chris Gallelli" <Chris.Gallelli@.hotmail.com> wrote in message
news:uQ25vsfXIHA.4808@.TK2MSFTNGP05.phx.gbl...
>I need some clarification on the maximum number of CPUs that will be used
>by SQL Server Standard Edition. The documentation states that 4 CPUs is
>the maximum for Standard. If those 4 CPUs are dual core, will SQL Server
>utilize all 8 logical CPUs? I read some posts that indicated that only 4
>of the 8 logical CPUs will be used by SQL Server Standard Edition. Is this
>true?
> Thanks!
> Chris
>|||Russell,
Thanks for the quick response. Your answer gives me some more insight into
the Express edition but I am looking specifically at SQL Server 2005
Standard Edition. If a machine running SQL Server 2005 Standard Edition has
4 Dual Core Processors, will SQL Server use all 8 logical CPUs?
The following link contains a discussion that is asking the same question:
http://www.codeprof.com/dev-archive/120/19-95-1201327.shtm
"Russell Fields" <russellfields@.nomail.com> wrote in message
news:%23UK7czfXIHA.484@.TK2MSFTNGP06.phx.gbl...
> Chris,
> CPUs are physical chips, whether single, dual, or quad core. In a
> conversation from a few months ago Jens K. Suessmeyer pointed to the
> explanation about SQL Server Express over the same issue:
> http://support.microsoft.com/kb/914278/en-us
> RLF
> "Chris Gallelli" <Chris.Gallelli@.hotmail.com> wrote in message
> news:uQ25vsfXIHA.4808@.TK2MSFTNGP05.phx.gbl...
>>I need some clarification on the maximum number of CPUs that will be used
>>by SQL Server Standard Edition. The documentation states that 4 CPUs is
>>the maximum for Standard. If those 4 CPUs are dual core, will SQL Server
>>utilize all 8 logical CPUs? I read some posts that indicated that only 4
>>of the 8 logical CPUs will be used by SQL Server Standard Edition. Is
>>this true?
>> Thanks!
>> Chris
>|||Hi Chris
Yes, SQL 2005 Std Edn definitely uses all 8 CPUs. The restriction is only
for physical CPUs, not logical so it's possible to have 4 Quad Core CPUs
with 16 logical all working under SQL 2005 Std Edn
Regards,
Greg Linwood
SQL Server MVP
http://blogs.sqlserver.org.au/blogs/greg_linwood
Benchmark your query performance
http://www.SQLBenchmarkPro.com
"Chris Gallelli" <Chris.Gallelli@.hotmail.com> wrote in message
news:%23jBFhMgXIHA.4476@.TK2MSFTNGP06.phx.gbl...
> Russell,
> Thanks for the quick response. Your answer gives me some more insight
> into the Express edition but I am looking specifically at SQL Server 2005
> Standard Edition. If a machine running SQL Server 2005 Standard Edition
> has 4 Dual Core Processors, will SQL Server use all 8 logical CPUs?
> The following link contains a discussion that is asking the same question:
> http://www.codeprof.com/dev-archive/120/19-95-1201327.shtm
>
> "Russell Fields" <russellfields@.nomail.com> wrote in message
> news:%23UK7czfXIHA.484@.TK2MSFTNGP06.phx.gbl...
>> Chris,
>> CPUs are physical chips, whether single, dual, or quad core. In a
>> conversation from a few months ago Jens K. Suessmeyer pointed to the
>> explanation about SQL Server Express over the same issue:
>> http://support.microsoft.com/kb/914278/en-us
>> RLF
>> "Chris Gallelli" <Chris.Gallelli@.hotmail.com> wrote in message
>> news:uQ25vsfXIHA.4808@.TK2MSFTNGP05.phx.gbl...
>>I need some clarification on the maximum number of CPUs that will be used
>>by SQL Server Standard Edition. The documentation states that 4 CPUs is
>>the maximum for Standard. If those 4 CPUs are dual core, will SQL Server
>>utilize all 8 logical CPUs? I read some posts that indicated that only
>>4 of the 8 logical CPUs will be used by SQL Server Standard Edition. Is
>>this true?
>> Thanks!
>> Chris
>>
>|||Sorry. (But I thought the analogy carried through just fine.) - RLF
"Chris Gallelli" <Chris.Gallelli@.hotmail.com> wrote in message
news:%23jBFhMgXIHA.4476@.TK2MSFTNGP06.phx.gbl...
> Russell,
> Thanks for the quick response. Your answer gives me some more insight
> into the Express edition but I am looking specifically at SQL Server 2005
> Standard Edition. If a machine running SQL Server 2005 Standard Edition
> has 4 Dual Core Processors, will SQL Server use all 8 logical CPUs?
> The following link contains a discussion that is asking the same question:
> http://www.codeprof.com/dev-archive/120/19-95-1201327.shtm
>
> "Russell Fields" <russellfields@.nomail.com> wrote in message
> news:%23UK7czfXIHA.484@.TK2MSFTNGP06.phx.gbl...
>> Chris,
>> CPUs are physical chips, whether single, dual, or quad core. In a
>> conversation from a few months ago Jens K. Suessmeyer pointed to the
>> explanation about SQL Server Express over the same issue:
>> http://support.microsoft.com/kb/914278/en-us
>> RLF
>> "Chris Gallelli" <Chris.Gallelli@.hotmail.com> wrote in message
>> news:uQ25vsfXIHA.4808@.TK2MSFTNGP05.phx.gbl...
>>I need some clarification on the maximum number of CPUs that will be used
>>by SQL Server Standard Edition. The documentation states that 4 CPUs is
>>the maximum for Standard. If those 4 CPUs are dual core, will SQL Server
>>utilize all 8 logical CPUs? I read some posts that indicated that only
>>4 of the 8 logical CPUs will be used by SQL Server Standard Edition. Is
>>this true?
>> Thanks!
>> Chris
>>
>