Wednesday, March 21, 2012

MSDE 2000 an 64 Bit CPU?

Does it make sense to use a 64 bit CPU with MSDE 2000? Or better: does MSDE
user it? I can′t find any hints.
hi,
Sven Behrend wrote:
> Does it make sense to use a 64 bit CPU with MSDE 2000? Or better:
> does MSDE user it? I cant find any hints.
actually it does not make sense... MSDE can use up to 2GB of ram, 2 CPUs and
a database size limit of 2GB (per database data file)... so having a 64bit
CPU in order to address more memory is non sense..
anyway, I never tried, but it should run in WOW on 64bit OS...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Ok, i′m talking about 100 Notebooks running MSDE as a SQL-platform for a CRM
system, so i would check it out befor changing, but the question is:
is MSDE using 64 bit or not?
"Andrea Montanari" wrote:

> hi,
> Sven Behrend wrote:
> actually it does not make sense... MSDE can use up to 2GB of ram, 2 CPUs and
> a database size limit of 2GB (per database data file)... so having a 64bit
> CPU in order to address more memory is non sense..
> anyway, I never tried, but it should run in WOW on 64bit OS...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
|||hi,
Sven Behrend wrote:
> Ok, im talking about 100 Notebooks running MSDE as a SQL-platform
> for a CRM system, so i would check it out befor changing, but the
> question is:
> is MSDE using 64 bit or not?
if the question is "can MSDE run on 64bit CPU" I do think yes, in Window On
Window...
if, on the contrary, the question is "using" it, MSDE is a 32 bit
application..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks, that′s it.
I have to make it faster, and that was an idea.
Sven Behrend
"Andrea Montanari" wrote:

> hi,
> Sven Behrend wrote:
> if the question is "can MSDE run on 64bit CPU" I do think yes, in Window On
> Window...
> if, on the contrary, the question is "using" it, MSDE is a 32 bit
> application..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>

No comments:

Post a Comment