Jim Lawrence (AccessD)
accessd at shaw.ca
Sun Feb 22 19:10:52 CST 2004
Hi Arthur: Thanks for your suggestion but the advanced model is what I purchased and I am loathe to change now. The other thing is that every other application that runs off this server is performing perfectly. Even MS SQL 2000 is, minus the performance, or lack of it. The RAM is not even being impacted so my thought that it might be a code segment is bleeding all over, is unfounded. You might be on to something, with SQL and W2000AdvSer...but where can I look. There is probably a simple setting somewhere in the registry. As all my new apps come from MS Action pack, I have passed my problem on MS and hope they have something. Thanks again Jim -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of Arthur Fuller Sent: Sunday, February 22, 2004 7:34 PM To: dba-sqlserver at databaseadvisors.com Subject: RE: [dba-SQLServer] SQL Performance I have never tested this so be advised that it's nothing more than a WAG, but you didn't mention the number of processors. The ONLY reason to run Advanced is multiple processors. I have a tired old dog server with twin P4-500s and it runs like quick! I have never tried to install Advanced on a single CPU unit because the docs clearly state that it's futile. Is it possible for you to back off Advanced and try the single-CPU version instead? Another thing to check is how much RAM each process is consuming, or prepared to consume. HTH, Arthur -----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 3: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