August 31, 2010 at 10:09 am
So, we have a server that we use iSCSI for the DB files. I was concerned about the performance so we ran some tests. Running a backup from the iSCSI drive to the local drive ran at about 19MB/s. Pretty bad. We ran the same test on our SAN and got 200MB/s. So I asked the server guys and the network guys if they had any ideas. They ended up implementing "jumbo frames", taking the settings from the default 1500 MTU size to 9000. Unfortunately they also changed the subnet, and some VLAN settings, and the microcode on the switches, against my arguments.
Anyway, now when I run the test it goes at 2MB/s. So now it's 10x slower than it was before!
The reason I'm posting here, other than to whine of course, is to see if anyone has any recommendations on what might need to change in SQL Server itself, in case that's the problem. I only have a vague understanding of networking, so was wondering if we need to switch the configurations in SQL Server to be utilizing larger packets now that the jumbo frames are in place.
Thanks for your help,
Rick Todd
September 2, 2010 at 5:02 am
Hi,
Nothing required to be changed on SQL Server, as its a network layer issue.
Phillip Cox
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply