[dba-SQLServer] SQL Performance

Hi All:

I have just installed a new version of SQL2000 developer on one of my
servers. The sever is not big but has reasonable performance and as I use it
just for testing... It is 1700Mhz, 1GB RAM, Windows2000 advanced Server
software. It is running a number of applications but all seem happy
together; ASP, JSP, Perl PHP, JSP with IIS and MySQL.

The recently installed MSSQL 2000 runs like a dog; so sloooooow. Nothing
else is affected and it seems to run and run to do the simplest of tasks.

Would anyone have some insight into what could possibly be going wrong.

Any comments would be greatly appreciated.
MTIA
Jim