Netherlands: Software

Introductie van Micorosoft SQL Server 2016

Issue link: http://hub-nl.insight.com/i/692679

Contents of this Issue

Navigation

Page 173 of 212

161 C H A P T E R 8 | Improved Azure SQL Database S3 100 5,100 transactions per minute Premier P1 125 105 transactions per second P2 250 228 transactions per second P4 500 Not available P6/P3 1,000 735 transactions per second P11 1,750 Not available Note The benchmark transaction rates are intended for general comparison only, based on a sample OLTP workload. You can learn more about the methodology for the benchmark development at "Azure SQL Database benchmark overview" at https://azure.microsoft.com/en- us/documentation/articles/sql-database-benchmark-overview/. After you select an initial performance level, you should continuously monitor SQL Database and tune your application as necessary so that you can adjust to the smallest possible performance level—and thereby minimize your monthly cost—or scale up as needed for seasonal peaks. For example, if you manage a web retail application, you might experience a large spike in transactions between November and January. Rather than invest in expensive physical hardware to accommodate the peak months, you can minimize your operational expense by scaling a SQL Database up or by scaling it out during these months, and then scale it back in other months to accommodate normal operations. You can monitor performance in the Azure Management Portal by selecting SQL Databases in the Resources list, and then selecting the database you want to monitor to view the resource utilization as a line chart and key metrics, as shown in Figure 8-1. When these metrics are below 40 percent utilization, you might consider moving to the next lower performance level. On the other hand, you might consider moving your database to the next higher performance level as these metrics approach 80 percent. Figure 8-1: Monitoring a SQL Database in Azure Management Portal.

Articles in this issue

Links on this page

Archives of this issue

view archives of Netherlands: Software - Introductie van Micorosoft SQL Server 2016