Horrible (8x) Client-Server Performance


System Setup
-------------
OS's - RedHat Enterprise Linux AS 3.0
DB Server - 8 logical xeon 2.8ghz cpu, 16gb ram
App Server- 8 logical xeon 2.8ghz cpu, 8gb ram
Fibre Channel SAN housing the database

Our main program - MFG/PRO

Situation: Running a report, on the database server, connected in
shared memory, takes 'X' amount of time. Running that same report on
the Application server connecting to the DB server via client-server
over a gigabit connection, takes anywhere from 5X to 8X the time.

We have eliminated network to be the constraint by connecting both
servers with a crossover cable.

What exactly is progress doing behind the scenes that is taking so long
in the client-server method? We might have a report take 30mins, yet
only show about 7mins of CPU usage.

Our sources say that we should be experienceing a 3X performance
slowdown via client-server, not 5X-8X.

I would be glad to post db/client parameters if anyone has any
ideas...

Thanks


--
excelon969
------------------------------------------------------------------------
excelon969's Profile: http://www.dbtalk.net/m402
View this thread: http://www.dbtalk.net/t308652

.

Relevant Pages

  • Re: SQL 2005 Performance
    ... we had a complaint at my current gig about 70% CPU utilization at ... SQL Server MVP ... this one database. ... I've got 141 databases on this server. ...
    (microsoft.public.sqlserver.server)
  • Re: Split a database
    ... it has little to do with connecting. ... the current database, and launch a upgrade program that copies the FE..and ... Those FE's link to a back end on the server. ... zero chance that users will not be able to download your new FE. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Processor Based License Model
    ... > CPU SMP system under Windows is that you don't necessarily get the same ... > Maybe for databases what we really need is a license that permits X number ... > upgrade w/o increasing your licensing costs for the database. ... > certainly allow you to have a large SMP server and put a database ...
    (comp.os.vms)
  • Working with a remote server
    ... Access 2000 database to and from my ISP's server? ... My problem comes with moving the project to my ISP's server. ... references to my local machine's C:/Inetpub/wwwroot folder are not ... connecting via the Frontpage server extensions. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: CPU usage on SQL server
    ... > I have a quad processor clustered database server that is experiencing ... There are multiple user databases ... > on ther server, and the issues manifest themselves in different ways. ... that is running on a single CPU that is causing the CPU spike. ...
    (microsoft.public.sqlserver.server)