[dba-SQLServer] SQL Performance

Hi Eric:

I am currently just using the EM to display the records. I was hoping to
have the app running at a reasonable speed before I started adding
databases. (I have a couple already built).

The drives, on the server, are fairly big and probably should have been
partitioned...(160GB each) but the performance, even displaying the
directory tree is not slow.

Unfortunately, F5, did not do anything.

Thanks
Jim

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of Eric
Barro
Sent: Wednesday, February 25, 2004 9:11 AM
To: dba-sqlserver at databaseadvisors.com
Subject: RE: [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

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com