03.微软win8瓷片风ppt图表 -PPT模板2022年7月8日.pptVIP

Server Principals Server is just a logical and administrative container for databases Two fixed administrative roles dbmanager loginmanager Server Admin (aka “server-level principal”) is like ‘sa’ Database-level permissions and roles essentially same as SQL Server Normal Logins cannot change own password by default No server permissions or user-defined server roles 高校联盟 官方微信 unitive Goals Explain the importance of query tuning within the Azure SQL Database environment. Show how the hybrid tool set can be used to identify poor performance. Demonstrate the additional functionality available within the Database Management Portal interface. 高校联盟 官方微信 unitive Then Why Use SQL Database? Speed of delivery Extremely low management cost Cheap prices Expandable capacity 高校联盟 官方微信 unitive What’s Old is New Transactions as short as possible Only move the data you need to move Only move the data when you need to move it Tune the queries 高校联盟 官方微信 unitive Tools for Query Tuning Query Tuning Tools SQL Server Management Studio SQL Database Management Portal Dynamic Management Objects 高校联盟 官方微信 unitive Connectivity required SQL Server Management Studio Object Explorer Query window And not much else Statistics Time Execution Plans Statistics IO 高校联盟 官方微信 unitive Monitor Query window Execution Plan Statistics Time SQL Database Management Portal Statistics IO 高校联盟 官方微信 unitive Portal: Monitor Connection Activity Including throttled connections Cache dependent Query Performance Aggregation Details 高校联盟 官方微信 unitive Self Service Service Delivery and Automation System Center: Unified management for the Cloud OS Deploy Configure Service Model Operate Monitor Virtual Machine Manager Operations Manager App Controller Service Manager Service Manager Orchestrator Configuration Manager Application Management Service Delivery and Automation Infrastructure Management Data Protection Manager App owner DC admin SERVICE PROVIDER ON PREMISES MICROSOFT 高校联盟 官方微信 unitive