SQL TCP/IP Configuration
posted by Jason Carreiro in Best Practices on Aug 17, 2011
SQL is installed on your server but not all is as it seems. You begin to notice performance related issues and a delay in the transmission of data. This can be the result of having the configuration manager of SQL configured to use invalid IP addresses.
Example: SQL is installed on server 192.168.0.182, however, in the configuration manager the IP addresses listed for the TCP stack show no indication of the server IP but rather a random IP address.
The protocols for each instance of SQL need to represent the server IP address. Failing to do so can hinder performance for SQL and the server. Noticing network I\O errors with your SQL server can be an indication of the problem.
Share this article
|
|
|||
| Share |
|
|
Comments
More Recent News
Writing technical doc
Writing technical documentation should not be a complicated procedure. Remember, you’re not writing a novel. You want to communicate information and procedures in a clear and concise fashion. Sometimes basic short... (May 15, 2012)
Go Postal on Spam
You get it at the office. You get it at home. Postal spam a.k.a. junk mail. Since the late 1800’s flyers, ad-mail, unsolicited magazines and pamphlets have been cluttering up people’s mailboxes and, now, people’s... (May 09, 2012)
Single installer to deploy
With the advent of 64-bit hardware, Microsoft has released a 64-bit version of Windows to leverage the capabilities of these hardware platforms. The new Version has the advantages of addressing more than 4 GB of... (May 03, 2012)
