Need Help About SQL DEV 2000 SRV PERFORMANCE

Hi
we are using develeoper server 2000 with 2 gb RAM, G3 version 4 way XEON 2.4 cpu server. We are implementing ERP and data base for now small.But even this situation end users have slow working problems. Anybody have an idea about the whst kind of things I have to check? (for example; from performance monitor, how can I satart to use RAM capacity in tempdb, etc....
PS : pls inform me from my MikeK_70@.hotmail.com adress......
Than
GiacomoTry these:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/itwforsql.asp
http://www.sql-server-performance.com/performance_monitor_counters.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_queryrecompilation.asp
http://www.winnetmag.com/SQLServer/Article/ArticleID/26922/26922.html
http://www.sql-server-performance.com/q&a2.asp
GL
--
Ray Higdon MCSE, MCDBA, CCNA
--
"GiacomoC" <MikeK_70@.hotmail.com> wrote in message
news:09E6F9F3-DF74-41A4-A403-181AA04CA937@.microsoft.com...
> Hi,
> we are using develeoper server 2000 with 2 gb RAM, G3 version 4 way XEON
2.4 cpu server. We are implementing ERP and data base for now small.But even
this situation end users have slow working problems. Anybody have an idea
about the whst kind of things I have to check? (for example; from
performance monitor, how can I satart to use RAM capacity in tempdb,
etc....)
> PS : pls inform me from my MikeK_70@.hotmail.com adress.......
> Thanx
> Giacomo

Need Help About SQL DEV 2000 SRV PERFORMANCE

Hi,
we are using develeoper server 2000 with 2 gb RAM, G3 version 4 way XEON 2.4
cpu server. We are implementing ERP and data base for now small.But even th
is situation end users have slow working problems. Anybody have an idea abou
t the whst kind of things
I have to check? (for example; from performance monitor, how can I satart to
use RAM capacity in tempdb, etc....)
PS : pls inform me from my MikeK_70@.hotmail.com adress.......
Thanx
GiacomoTry these:
http://msdn.microsoft.com/library/d...r />
orsql.asp
http://www.sql-server-performance.c...or_counters.asp
http://msdn.microsoft.com/library/d...compilation.asp
http://www.winnetmag.com/SQLServer/...6922/26922.html
http://www.sql-server-performance.com/q&a2.asp
GL
Ray Higdon MCSE, MCDBA, CCNA
--
"GiacomoC" <MikeK_70@.hotmail.com> wrote in message
news:09E6F9F3-DF74-41A4-A403-181AA04CA937@.microsoft.com...
> Hi,
> we are using develeoper server 2000 with 2 gb RAM, G3 version 4 way XEON
2.4 cpu server. We are implementing ERP and data base for now small.But even
this situation end users have slow working problems. Anybody have an idea
about the whst kind of things I have to check? (for example; from
performance monitor, how can I satart to use RAM capacity in tempdb,
etc....)
> PS : pls inform me from my MikeK_70@.hotmail.com adress.......
> Thanx
> Giacomo