CODEWITHSUNDEEP
c#.netsql-serverazureazure-blob-storage
Neil Weicher
Neil Weicher

Reputation: 2502

Performance questions uploading Block Blob to Azure

I developed a C# DotNet application that backs up a SQL Server database to an Azure Block Blob.

However it is extremely slow when compared to SQL BACKUP TO URL. When running a performance counter on network activity I see that BACKUP TO URL is sending at about 30 MBPS while my application is sending at around 5 MBPS when it sends a block to the Blob. Is there some setting in Azure that controls the transmission speed of a block sent with PutBlock? I do know that SQL backup creates a Page Blob, while I am using a Block Blob. Should that make any difference?

Upvotes: 0

Views: 218

Answers (1)

Ivan Glasenberg
Ivan Glasenberg

Reputation: 29940

For block blobs, in SDK, there is a ParallelOperationThreadCount property(Gets or sets the number of blocks that may be simultaneously uploaded.) of the BlobRequestOptions object(see here for details). By using this property, it can be faster to upload blobs.

A sample of using this property:

var requestOption = new BlobRequestOptions()
{
    ParallelOperationThreadCount = 5 //Gets or sets the number of blocks that may be simultaneously uploaded.
};

Upvotes: 1

Related Questions