Showing posts with label sense. Show all posts
Showing posts with label sense. Show all posts

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
>
>