What is the Maximum Batch size in SQL Server?

Posted on : 16-04-2012 | By : Devi Prasad | In : SQL Server Basics

Share:

0


What is the Maxmum Batch size in SQL Server?
SQL Server supports a batch size equal to 65536 * Network Packet Size.

If X is the Network Packet Size then the Maxmum Batch size supported by SQL Server would be 65536 * X.

Maxmum Batch size in SQL Server:

Max Capacity For SQL Server 2012 SQL Server 2008 R2 SQL Server 2008 SQL Server 2005
Maxmum Batch size in SQL Server 65536 * Network Packet Size 65536 * Network Packet Size 65536 * Network Packet Size 65536 * Network Packet Size

http://msdn.microsoft.com/en-us/library/ms143432.aspx
http://msdn.microsoft.com/en-us/library/ms143432(v=sql.105).aspx
http://msdn.microsoft.com/en-us/library/ms143432(v=sql.100).aspx
http://msdn.microsoft.com/en-us/library/ms143432(v=sql.90).aspx

(Visited 135 times, 1 visits today)



References : Devi Prasad (sqlserverlearner.com)

Need Help On SQL Server?

Cannot Find Solution to your problem (or) If you are looking for some help on SQL Server. Dont worry Click Here to Post your question and solve your issue.


Do you like my blog?

If you liked reading this blog, please help spread the word by sharing this blog with your friends.




Write a comment



Tags: , , , , , , , , , ,