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

Need hardware suggestions for SQL 2000 server

I am running McAfee ePO and SQL Server 2000 on a dual Xeon 900Mhz box
currently. It is slow. I am going to be ordering 2 new servers, 1 for
ePO and 1 for SQL Server 2000. Anybody have any suggestions for the
SQL Server's hardware specs. Thanks,
Chris"czidak" <czidak75@.gmail.com> wrote in message
news:1115925307.753935.292720@.z14g2000cwz.googlegr oups.com...
> I am running McAfee ePO and SQL Server 2000 on a dual Xeon 900Mhz box
> currently. It is slow. I am going to be ordering 2 new servers, 1 for
> ePO and 1 for SQL Server 2000. Anybody have any suggestions for the
> SQL Server's hardware specs. Thanks,

Not w/o knowing a lot more.

Where's your bottleneck? I/O? CPU? Not enough memory?

Have you checked the code? Using cursors? etc.

> Chris|||Currently whenever I Navigate through ePO to make changes or apply
changes it hangs. Checking Task Manager the following processes are
hogging processor and memory.

mmc.exe (epo app) Processor - 50% Memory -28 MB
sqlservr.exe Processor - 1% - 50% (only high for a second at the end
of a transaction Memory-1.5GB currently (starts off at 60 MB when
server is 1st booted up.)

The server has 2 GB of RAM and the virtual memory settings are set at
2046 - 4096

Thanks,
Chris|||Also, the ePO application does not run any better right after a reboot,
so I don't think the issue is the amount of memory that sqlservr.exe
can use.

Hope this helps,
Chris