What is the Maximum Batch size in SQL Server?

table.hovertable {
font-family: verdana,arial,sans-serif;
font-size:11px;
color:#333333;
border-width: 1px;
border-color: #999999;
border-collapse: collapse;
}
table.hovertable th {
background-color:#c3dde0;
border-width: 1px;
padding: 8px;
border-style: solid;
border-color: #a9c6c9;
}
table.hovertable tr {
background-color:#d4e3e5;
}
table.hovertable td {
border-width: 1px;
padding: 8px;
border-style: solid;
border-color: #a9c6c9;
}

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

Leave a Reply

Your email address will not be published. Required fields are marked *