Retrieving large binary objects

5 pts.
Tags:
Microsoft Windows Server 2003
SQL Server 2005
SQL Server performance
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?

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following