Azure SQL Database

2018-06-08 10:19:20

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

SQL Azure also supports S3 performance tier which has same DTU as P1 and half the cost of P1. If you experience the performance issues because of load, you can give a shot and of course you can scale down if needed

一旦我更新到最新的SSMS和客户端工具，一切都很顺利。

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

链接地址: http://www.djcxy.com/p/25520.html

上一篇: 键在react.js中绑定

下一篇: Azure SQL数据库