[dba-SQLServer] SQL Performance

Jim,

Is it actual performance (ie retrieving records from SQL and displaying them via ASP or VB front end) or the display of the objects using Enterprise Manager?

Can you connect using an Access data project and if so do you get the same slow performance?

The reason I want to differentiate is that I've seen this behavior before. I can't quite put my finger on the cause but usually if you press F5 for refresh you will get the results much faster. It's as if the display was waiting for something to trigger it. If you go to My Computer and display the list of drives does it also take a while to display them? Pressing F5 for refresh will display them in an instant. Let me know if I've hit the nail on the head.

---
Eric Barro
Senior Systems Analyst
Advanced Field Services
(208) 772-7060
http://www.afsweb.com 

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of
Francisco H Tapia
Sent: Wednesday, February 25, 2004 8:53 AM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] SQL Performance


How much ram did you allocate to SQL Server?  If you open EM, and right click on your registered server, you will have a tab for the memory configuration, is it set to fixed, or dynamic, and if dynamic what is the maximum range?




Jim Lawrence (AccessD) wrote:

>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
>
>  
>

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.593 / Virus Database: 376 - Release Date: 2/20/2004