Re: TDS and character encoding

01/09/2007, 11h58

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

01/09/2007, 11h58	#1
raymond_b_jimenez@yahoo.com Messages: n/a Hébergeur:	Re: TDS and character encoding 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

Outils de la discussion
Afficher une version imprimable Envoyer un lien vers cette page par email