Posted by Dan Guzman on 09/01/07 12:41

> Don't know a lot about TPC-E benchmarks. Are they measured over a
> network?

Database benchmarks are typically done with a dedicated database server and
remote client(s). You can download the results disclosure reports from
http://www.tpc.org/tpce/tpce_perf_results.asp to get details of the actual
configurations used. Looking at the specs of the network gear, it doesn't
look to me like the benchmark sponsors were too concerned about network
performance.

I agree with the others in this thread that the application and database
design are by far the biggest contributing factors to overall performance.
A little common sense, like filtering data on the server rather than the
client, goes a long way towards improving scalability and performance.


--
Hope this helps.

Dan Guzman
SQL Server MVP

<raymond_b_jimenez@yahoo.com> wrote in message
news:1188644332.019526.110140@y42g2000hsy.googlegroups.com...
> On 31 Ago, 18:54, "William \(Bill\) Vaughn"
> <billvaRemoveT...@betav.com> wrote:
>> Given that SQL Server has the highest TPC-E benchmarks in the industry,
>> don't you think that the SQL Server team has made the TDS stream as
>> efficient as possible? IMHO, it's not the line protocol or the lowest
>> layers
>> of the interface that should be the focus of performance tuning, but the
>> applications, database designs and query methodologies that should
>> dominate
>> your attempts to improve throughput and scalibility. Reducing the traffic
>> on
>> the TDS channel will go a long way to improving performance if you have
>> to
>> move that much volume over the wire to make a difference.
> Don't know a lot about TPC-E benchmarks. Are they measured over a
> network?
>
> rj
>

[Back to original message]