Jim Lawrence (AccessD)
accessd at shaw.ca
Thu Feb 26 01:10:35 CST 2004
Hi Robert: This is where the whole thing get interesting (weird), there is no apparent large utilization of the systems resources when the MSSQL's EM is working; about 1 to 3%, and less than 40MB of memory for all the related services and processes...virtually nothing. The SQL Server service pack is 3a. The server is defragged on a regular bases with an Enterprise version of DisKeeper. The MSSQL is a brand new install so it has not had a chance to create internally fragmentation. I am sure it is something simple, like a registry setting but where would I look? Jim -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of Djabarov, Robert Sent: Wednesday, February 25, 2004 6:36 AM To: dba-sqlserver at databaseadvisors.com Subject: RE: [dba-SQLServer] SQL Performance Jim, The remark I made was really derogatory, because I think you already have quite a bit on this box. In addition, you need to make sure you apply SP3 to your SQL install. If the problem persists, follow the rule of thumb, -there are 3 things that can cause such slow performance, - CPU, memory, or IO subsystem. The easiest way to see if the first 2 are an issue is to open task manager and select Processes tab. Click on CPU column header a couple of times and see what process other than System Idle Process may be taking all the CPU. Do the same with Memory column. I did observe performance degradation on my laptop (2.6GHz, 1GB memory, 120GB HD) with default and named instances of Personal edition, and managed to fix it by defragmenting the program files and data and log devices of master databases on both instances. 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: Tuesday, February 24, 2004 7:44 PM To: dba-sqlserver at databaseadvisors.com Subject: RE: [dba-SQLServer] SQL Performance 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 _______________________________________________ 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