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.
Tag Archives | iSCSI
Search
- 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
Twitter Feed
Follow @jasoncrider on Twitter