MTU size SQL

Hello, we have one webserver connected to the SQL server with teamed nic, cat cable directly from webserver to SQL. Would I get any better perfomance by increasing MTU size? Is there other settings that you would recommend chaning from default?
ComTechASAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ComTechASAuthor Commented:
PS. the connection between these servers only is used for SQL traffic.
0
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
Before tuning th enetwork side, I would recommend evaluating the precise top network throughput required by *all* servers combined, at a given point in time.  This information will give you a clearer perspective on the problem.

Usually exchanges between SQL servers are the highest consumers, especially in datawarehousing environment.

hth
0
ComTechASAuthor Commented:
Hello, there are only this two serververs connected to each other without any switch, the webserver has another interface thats connected to the dmz.
0
Powerful Yet Easy-to-Use Network Monitoring

Identify excessive bandwidth utilization or unexpected application traffic with SolarWinds Bandwidth Analyzer Pack.

Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
Then it looks that it would be difficult to blame the network for a performance issue.  Your best bet would be to look on the db side..

HTH
0
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
Why a C?  I believe that I have answered your question the best I could.  Drawn from the EE guidelines.  Just keep in mind I do this voluntarily.

-----------------------------------------------------------------------------------------------------------------------------
What's the right grade to give?

Grading at Experts Exchange is not like school. It's more like the "10-point Must" system in professional boxing; in other words, an answer is worth an A, unless it doesn't resolve your issue. If it requires you to do a little more research, or figure out one more piece of code, then it's worth a B. If you think it's not worth a B, the custom is to offer the Experts an opportunity to earn a better grade.

Giving a higher grade has no impact on your Available Points.
-----------------------------------------------------------------------------------------------------------------------------How can I change a grade?

If you feel you have graded a solution incorrectly, click the Request Attention button and the Moderators will change it for you. If another member disputes the grade you have given, you will be asked to explain your reasoning; please respond to those requests
.----------------------------------------------------------------------------------------------------------------------------

Regards...
0
ComTechASAuthor Commented:
Because the question from the start wasn't related to any performance issue, but how i could set it up in best practise, I did not get any answer to how the MTU size change connection speed for SQL data.

If you still mean that I graded wrong, is there any whay I could change it?
0
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
<< I did not get any answer to how the MTU size change connection speed for SQL data.>>
That's because there is no direct answer to that kind of question.  The two concepts are orthogonal.

<<If you still mean that I graded wrong, is there any whay I could change it?>>
If you want to change the grade, click the *Request Attention* button.  
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Networking

From novice to tech pro — start learning today.