SQL Database性能（Performance）的可规划性（Predictability）及度量（Measurement）

  • Article

 

??????????????,????????/????????????????????????(PC)????(Server)????(Virtualization)????(Private Cloud)????(Public Cloud),???????/IT??????????

??,??????????????????,?????(Measurement)???(Monitoring)?????(Benchmarking)???(Tuning)/??(Optimization)?,???????????,????????????

??????SQL Server???????,???SQL Database,?PaaS??????????,??????????,??????????????

???SQL Server?SQL Database???,???:?SQL Server?Microsoft Azure SQL Database????????

???SQL Database,??????:Web?Business????????????,???????

????????:??(Basic)???(Standard)???(Premium),?????Standard???Premium??,?????????(S0/S1/S2?P1/P2/P3),??????????????????????,“??”?????????????????????;“??”????????????;“??”??????????????,??????????????

??SQL Database????????,????:https://www.windowsazure.cn/pricing/details/sql-database/

??????Web?Business??????,???????????????,????????,???,??????”??”??,???????????????,??????/???

clip_image002

??,???????????,??,?PowerShell?,??Set-AzureSqlDatabase?????;?REST API?,????Update Database / ServiceLevelObjectiveId???;??,??DBA,????ALTER DATABASE … MODIFY (EDITION = …)?T-SQL??????

?????????????,???????????????????,?SQL Database????/???(Predictable Performance)?

?SQL Database?????????DTU,??????,?Database Throughput Unit,??DTU?????(CPU)???(Memory)??(Read)??(Write)?????????????

??,???????????/??,??????????,??????????????????????:

  • ??:??(Basic)???(Standard)???(Premium)
  • ????(????????)????DTU??,?S0/S1/S2?P1/P2/P3?
  • ?????(???????????),??????(??500G)
  • ????,????/????

???SQL Database?????(Monitoring)???(Measurement),???????????????????

?????????????Azure????(Management Portal),?????????????,???:

clip_image003

?????????(DBA)??????IT?????,??????master.sys.resource_stats?userdb.sys.dm_db_resource_stats,???????????

??????,???:https://msdn.microsoft.com/en-us/library/dn269979.aspx

??,????Visual Studio???,???Azure SDK?,???Visual Studio?IDE????SQL Database?????,???:

clip_image004