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

msdb.dbo.sp_sqlagent_get_perf_counters using tons of cpu

msdb.dbo.sp_sqlagent_get_perf_counters is using almost all of the cpu usage
on our server. We have hardly anything running in sqlagent. Can you give me
some ideas on how to fix this?
Thanks so much,
Jenna
Open Enterprise Manager and expand the Management>SQL Server Agent folder
and click on Alerts.You should see 9 alerts whose names all start with Demo.
Select them all and Delete. If you don't use alerts there is no point in
sp_sqlagent_get_perf_counters running. If there are no Alerts defined it
won't run.
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Jenna S." <JennaS@.discussions.microsoft.com> wrote in message
news:8C0811F4-49A9-428C-BFDE-DA060470CAAD@.microsoft.com...
> msdb.dbo.sp_sqlagent_get_perf_counters is using almost all of the cpu
> usage
> on our server. We have hardly anything running in sqlagent. Can you give
> me
> some ideas on how to fix this?
> Thanks so much,
> Jenna

msdb.dbo.sp_sqlagent_get_perf_counters using tons of cpu

msdb.dbo.sp_sqlagent_get_perf_counters is using almost all of the cpu usage
on our server. We have hardly anything running in sqlagent. Can you give me
some ideas on how to fix this?
Thanks so much,
JennaOpen Enterprise Manager and expand the Management>SQL Server Agent folder
and click on Alerts.You should see 9 alerts whose names all start with Demo.
Select them all and Delete. If you don't use alerts there is no point in
sp_sqlagent_get_perf_counters running. If there are no Alerts defined it
won't run.
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Jenna S." <JennaS@.discussions.microsoft.com> wrote in message
news:8C0811F4-49A9-428C-BFDE-DA060470CAAD@.microsoft.com...
> msdb.dbo.sp_sqlagent_get_perf_counters is using almost all of the cpu
> usage
> on our server. We have hardly anything running in sqlagent. Can you give
> me
> some ideas on how to fix this?
> Thanks so much,
> Jenna

msdb.dbo.sp_sqlagent_get_perf_counters using tons of cpu

msdb.dbo.sp_sqlagent_get_perf_counters is using almost all of the cpu usage
on our server. We have hardly anything running in sqlagent. Can you give m
e
some ideas on how to fix this?
Thanks so much,
JennaOpen Enterprise Manager and expand the Management>SQL Server Agent folder
and click on Alerts.You should see 9 alerts whose names all start with Demo.
Select them all and Delete. If you don't use alerts there is no point in
sp_sqlagent_get_perf_counters running. If there are no Alerts defined it
won't run.
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Jenna S." <JennaS@.discussions.microsoft.com> wrote in message
news:8C0811F4-49A9-428C-BFDE-DA060470CAAD@.microsoft.com...
> msdb.dbo.sp_sqlagent_get_perf_counters is using almost all of the cpu
> usage
> on our server. We have hardly anything running in sqlagent. Can you give
> me
> some ideas on how to fix this?
> Thanks so much,
> Jenna