[dba-SQLServer] SQL Performance

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




More information about the dba-SQLServer mailing list