Retrieving large binary objects
Server: SQL Server 2005 SP2 on Windows 2003 R2, Quad Core, 4GB Ram, Gigabit Ethernet
Client: Windows XP SP2, Dual Core, 1GB RAM, Gigabit Ethernet
I am retrieving images from my database across the network and am concerned about thruput. It seems to me when I request a 300k image that it will be sent in 1500 byte increments because of the ethernet MTU limitation. Does anyone know of an alternate method?
Software/Hardware used:
Software/Hardware used:
ASKED:
November 29, 2007 7:13 PM
UPDATED:
December 2, 2007 11:35 AM
RELATED QUESTIONS
- SQL Server 2005 Express SP3 Memory Usage
- How do I configure SQL 2005 to use 22GB RAM on a Server with 24 GB RAM running Windows 2003 EE ?
- SQL Server 2005 Memory
- Do you know costs and hardware requirements to virtualize development and testing phase?
- Not able to record more than 60 seconds with Windows Sound Recorder
Answer Wiki:
That limit is placed at the network level. There is no way to override it. The only way to change that would be to increase the MTU settings of the servers and the network devices between the servers. An MTU of 1500 is standard across all network devices and usully shouldn't be changed.
Odds are your SQL Servers disk configuration will be the bottleneck, not the network.
This <a href="http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1262122,00.html">tip</a> over at SearchSQLServer.com covers a lot of disk configuration options.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
