[dba-SQLServer] SQL Performance

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




More information about the dba-SQLServer mailing list