Jim Lawrence (AccessD)
accessd at shaw.ca
Tue Feb 24 19:44:16 CST 2004
Hi Robert: Thanks for the comments...An example of how slow we are talking about is 6.5 minutes just to display the list of tables from Master DB. Oracle may be slow but not that slow... Jim -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of Djabarov, Robert Sent: Tuesday, February 24, 2004 8:02 AM To: dba-sqlserver at databaseadvisors.com Subject: RE: [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 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com