Let's say we have a SQL Server 2000 box that houses our main database engine.
We added an iSCSI SAN and now that server has a one card connected to the regular network and one card connected to the iSCSI network.
The Data is requested through another server which is our application server and it's not on the iSCSI network.
We enabled Jumbo Packets to 9000 on the iSCSI connection on the data server (as well as the other items on the iSCSI network.
After reading an article by Jonathan Kehayias I'm wondering if what we did is right.
What's the best way to test this on my OLTP system? The OS is Windows Server 2003 R2 Enterprise x64 SP2 and SQL Server is Enterprise 2000 x86.