Description

Specifies the amount of data that can be read from the server running Microsoft SQL Server at one time.

Note:
This property is available only from the command line.

Syntax

stsadm -o setproperty

-propertyname large-file-chunk-size

-propertyvalue <Value in bytes>

[-url <http://server_name> ]

The syntax for the getproperty operation is:

stsadm -o getproperty

propertyname large-file-chunk-size

[-url <http://server_name> ]

Note:
You can substitute -pn for -propertyname and -pv for -propertyvalue.

Property values

The following table shows possible values.

Name	Value
propertyname	Gets or sets the name of the property.
propertyvalue	The upload size in bytes. Content consisting of a single file or groups of files cannot be greater than this setting. The default value is 5,242,880 bytes (5 MB). In certain circumstances, this value can be changed to any value up to 2 GB (2048 MB or 2,147,483,648 bytes).
url	Typically, a path to the URL of the Web application, in the form http://server_name.

Remarks

To determine the chunk size that is read, you divide the file size by the current chunk size setting. The chunk size is not related to the maximum upload file size. The chunk size simply specifies the amount of data that can be read from a file at one time. For example, if you have a file that is 73,400,320 bytes in size and your current chunk size is set to 5,242,880 bytes, the file would be read in 14 chunks (73,400,320/5,242,880).

Note:
If the chunk size is raised too high, the files might use up too much front-end memory and you may need to lower this setting. If the chunk size is set too low, too many requests might be sent to the SQL Server database and performance could be affected. Balancing between the default of 5 MB and 2 GB is recommended. After making a change to this property, you must restart IIS. You can restart IIS by typing iisreset at a command-line prompt.

Note:

If the chunk size is raised too high, the files might use up too much front-end memory and you may need to lower this setting. If the chunk size is set too low, too many requests might be sent to the SQL Server database and performance could be affected. Balancing between the default of 5 MB and 2 GB is recommended.

After making a change to this property, you must restart IIS. You can restart IIS by typing iisreset at a command-line prompt.

Examples

To set the large file chunk size to 1,073,741,824 bytes (1024 MB), use the following syntax:

stsadm -o setproperty -pn large-file-chunk-size -pv 1073741824

To view the current setting of the large file chunk size property, use the following syntax:

stsadm -o getproperty -pn large-file-chunk-size –url http://server_name

Tags

: Add a tag

Community Content

Add new content

Annotations

Bytes or Megabytes?

Zhang Mingquan Mike ... Thomas Lee | Edit | Show History

It's really confusing.

[tfl - 17.11.08]

Megabytes - the description is not quite accurate

Tags

: contentbug (x) Add a tag

Typo

Thomas Lee | Edit | Show History

In the description above, the propertyvalue value is stated as being in bytes. This is incorrect, it should be megabytes. The rest of this artilce describes this parameter correctly.

Tags

: contentbug (x) contentbugfix (x) Add a tag

Units and examples are wrong

Suresh Kandoth | Edit | Show History

The unit for the propertyvalue has to be specified in bytes.

Examples:
To set the chunk size to 8040 bytes, you have to execute the command: stsadm -o setproperty -pn large-file-chunk-size -pv 8040
To set the chunk size to the default 5 MB, you have to execute the command: stsadm -o setproperty -pn large-file-chunk-size -pv 5242880

We have verified this on external installs and internal servers by looking at the UPDATETEXT commands sent over to the SQL Server. Also this value is applicable for upload.
May I please request the content team to re-write this article and make sure accurate information is reflected in this document to avoid any confusion at all.

Tags

: contentbug (x) Add a tag