SQL Server 2005 Networking
in [Server Configuration]
|
Prev: SQL Server failed with error code 0xc0000000 to spawn a thread
Next: Anyone running SQL 2005/08 under vSphere?
From: RG on 19 Feb 2010 10:22 Is there a performance performance penalty if sql server 2005 machine has dhcp assigned address? Is there other issues with running sql server on dynamic ip server? How can I measure sql server network performance? Thanks in advance
From: Uri Dimant on 21 Feb 2010 03:43
RG High network latency coupled with an application that has many round trips to the database se performance counter Output queue with length >2 Also there is Perfmon object: Network Interface ...worth to look into... "RG" <RG(a)discussions.microsoft.com> wrote in message news:2D0E8FF0-E595-4095-B505-E4C12365F54B(a)microsoft.com... > Is there a performance performance penalty if sql server 2005 machine has > dhcp assigned address? > Is there other issues with running sql server on dynamic ip server? > > How can I measure sql server network performance? > > Thanks in advance |