[dba-SQLServer] SQL Performance

You can also try to load Oracle and DB2 on it, then see who's slower :)

Robert Djabarov
SQL Server & UDB
Sr. SQL Server Administrator
Phone: (210)  913-3148
Pager: (210) 753-3148
9800 Fredericksburg Rd. San Antonio, TX  78288
www.usaa.com

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Jim
Lawrence (AccessD)
Sent: Saturday, February 21, 2004 5:16 PM
To: dba-sqlserver at databaseadvisors.com
Subject: [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

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com