Calculate Indexes size in SQL Azure

Why need to calculate size for indexes? It's simply because in Azure management portal show only the size of raw data not for indexes which indexes size is also included to count them as total storage used. I faced this problem during spamming data on 1GB size of SQL Azure. In my management portal show around 600MB is used but when updating the indexes, it show message like 'The database has reached its size quota' and receive an error code 40544. This problem may occurred depends on your indexes size growth rate. So, in order to track the size of our indexes use the following command to check:

SELECT (SUM(reserved_page_count) * 8192) / 1024 / 1024 AS DbSizeInMB
FROM    sys.dm_db_partition_stats

To track the size for each indexes, use the command below instead:

DECLARE @SizeInBytes bigint
SELECT @SizeInBytes =
(SUM(reserved_page_count) * 8192)
    FROM sys.dm_db_partition_stats

SELECT idx.name, SUM(reserved_page_count) * 8192 'bytes'
FROM sys.dm_db_partition_stats AS ps
    INNER JOIN sys.indexes AS idx ON idx.object_id = ps.object_id AND idx.index_id = ps.index_id
WHERE type_desc = 'NONCLUSTERED'
GROUP BY idx.name
ORDER BY 2 DESC

References:

• calculate size of sql azure database
• The Real Cost of Indexes

Debugging a Published Cloud Service with IntelliTrace and Visual Studio

Take a look at this link: http://msdn.microsoft.com/en-us/library/windowsazure/ff683671.aspx. It contains the steps to enable and download IntelliTrace files back to diagnosis log files in Cloud Service on Windows Azure.

Hadoop on Windows Azure

This post is to show you overview about Hadoop on Azure.



References:

1. Channel9: Hadoop on Windows Azure
2. MSDN: Windows Azure - Hadoop on Windows Azure

Windows Azure Errors Guide

If you face provisioning timed out during restore virtual machine from image file: Azure (IaaS) Provisioning Timed Out.

If you face the provisioning operation is too long, look at "The operation cannot be performed because the virtual machine is faulted."

P.S. If I find anymore unexpected errors, I will update to this post.

Getting Start Windows Azure

Today, Cloud services are heavily used in many companies, which can reduce the expenses in term of hardware maintenance includes scalability problem. For the well known cloud service providers may be Amazon, Google, and Microsoft. In this post I've got Windows Azure information i.e. first step of setting up Windows Azure, and its architecture.

For the step by step setting up Windows Azure, you can go to this link: http://blogs.technet.com/b/blainbar/archive/2012/09/10/step-by-step-setting-up-windows-azure-for-the-first-time-and-creating-a-vm-role-of-windows-server-2012-on-microsoft-s-public-cloud.aspx.

Another one is a link exploring cloud architecture: http://msdn.microsoft.com/en-us/magazine/hh852589.aspx.

In short, Windows Azure provides 3 types of cloud services as follows: IaaS, PaaS, SaaS while Amazon provide cloud service in the level of IaaS, and provide PaaS in Google.