| title | Establish a Performance Baseline | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| description | Take performance measurements at regular intervals over time, even when no problems occur, to establish a server performance baseline in SQL Server. | |||||||||
| author | MikeRayMSFT | |||||||||
| ms.author | mikeray | |||||||||
| ms.date | 11/05/2024 | |||||||||
| ms.service | sql | |||||||||
| ms.subservice | performance | |||||||||
| ms.topic | concept-article | |||||||||
| ms.custom |
|
|||||||||
| helpviewer_keywords |
|
|||||||||
| monikerRange | =azuresqldb-current || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current || =fabric-sqldb |
[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance FabricSQLDB] To determine whether your [!INCLUDEssNoVersion] system is performing optimally, take performance measurements at regular intervals over time, even when no problems occur, to establish a server performance baseline. Compare each new set of measurements with those taken earlier.
The following areas affect the performance of [!INCLUDEssNoVersion]:
-
System resources (hardware)
-
Network architecture
-
The operating system
-
Database applications
-
Client applications
At a minimum, use baseline measurements to determine:
-
Peak and off-peak hours of operation.
-
Production-query or batch-command response times.
-
Database backup and restore completion times.
After you establish a server performance baseline, compare the baseline statistics to current server performance. Numbers far above or far below your baseline are candidates for further investigation. They might indicate areas in need of tuning or reconfiguration. For example, if the amount of time to execute a set of queries increases, examine the queries to determine if they can be rewritten, or if column statistics or new indexes must be added.