In the past few months, we’ve gradually been implementing a new SAN solution from Dell that uses iSCSI. We are kind of learning as we go and there are always bumps in the road. I’d noticed we had some I/O issues on our main production SQL Server but nothing seemed to add up and I couldn’t find where the problem could be outside of tuning indexes or putting data files on a different drive. We are on SQL Server 2000 but we are moving towards 2005 and I’m sure that might have helped me troubleshoot the problem. I came across something the other day about Jumbo packets. As I read more and figured out where to check things I figured out I might have been onto something. Brent Ozar passed me this link that helps check on the packet size. I looked at the iSCSI connection(NIC card –> Configure –> Advanced) and noticed that the Jumbo Mtu was set to 1500. I asked more questions of our admin and everything else along the pipe had been raised to 9000, but somehow the card got missed. Once I set this to 9000 I saw that I had far fewer I/O problems. They are still there due to poor indexes and disk contention but they are better than they were. Just thought I’d pass this along in case anyone else had a similar issue with iSCSI.
- Ebooks, Twitter, and Contacts February 14, 2009
- QuickHitter 01 : SSMS 2012 Templates in a new place December 24, 2012
- Change Connection on Same Query December 5, 2011
- QuickHitter 04 : SQLCat.com whitepapers all in one place October 16, 2013
- QuickHitter 03 : Put some Windows updates in my basket May 9, 2013
- QuickHitter 02 : Indexing Powershell Scripts January 30, 2013
- Tapping into The Power of a Community for Collective Intelligence - Dell Software Community: […] out this blog by Jason Crider. And this ...
- elf: Thanks for the info! One thing I will note is und...
- Tapping into The Power of a Community for Collective Intelligence - Foglight for Databases - Performance Monitoring - Dell Community: […] out this blog by Jason Crider. And this ...
Active Directory Blogging Calendar Cluster Education facebook General Google GTD Installation iPhone iSCSI Life Links Networking PowerShell Productivity qsftProjectLucy QuickHitter R900 RSS SAN Social Media Sports NonTech SQL SQL Server SQL Server 2000 SQL Server 2005 SQL Server 2008 SQL Server 2012 SSIS SSMS Storage Tech Training Troubleshooter Windows Windows 7 Windows Server WordPress
Follow @jasoncrider on Twitter