Azure SQL Database - Slow

Question

I'm currently working with SQL Azure and I realize that it is very slow when I used it with Sql Server Management Studio or Visual Studio 2013 Data Tools for design the database. Is there anyone having the same issue? I tried scaling the database to this configuration but it still working slow :

Server Tier : Standard. Performance level : S2.

Regards,

Rodrigo

Answer 1

I just solved this and wanted to see if other's have a better solution.

You don't get this 'slow' behaviour in SQL Management Studio if you use the 'servers' SA account.

Other accounts were getting it.

Solution

USE master
GO
CREATE USER usernameYouLogInWith
    FOR LOGIN usernameYouLogInWith
    WITH DEFAULT_SCHEMA = [dbo]

Solved.

Immediately right clicking in Management Studio as that user account is now 'instant'.

PS, I know you can't use 'use' in SQL Azure, but at least you know to run that on the master database. Using V12 DB