-
Notifications
You must be signed in to change notification settings - Fork 2.8k
/
monitoring-tuning-index.yml
160 lines (149 loc) · 6.72 KB
/
monitoring-tuning-index.yml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
### YamlMime:Landing
title: Azure SQL Database and Azure SQL Managed Instance monitoring and performance tuning
summary: Azure SQL Database and Azure SQL Managed Instance provide tools to help you collect metrics and diagnostic information to monitor your database and improve its performance. # < 160 chars
metadata:
title: Azure SQL Database and Azure SQL Managed Instance monitoring and tuning documentation
titleSuffix: Azure SQL Database & Azure SQL Managed Instance
description: Learn about Azure SQL Database monitoring and performance tuning tools that help you collect metrics and diagnostics and improve database performance.
ms.service: sql-database
ms.subservice: monitoring
ms.custom: sqldbrb=2
ms.topic: landing-page
ms.collection: performance
author: WilliamDAssafMSFT
ms.author: wiassaf
ms.reviewer: mathoma
ms.date: 03/06/2024
monikerRange: "=azuresql||=azuresql-db||=azuresql-mi"
# linkListType: architecture | concept | deploy | download | get-started | how-to-guide | learn | overview | quickstart | reference | tutorial | video | whats-new
landingContent:
# Cards and links should be based on top customer tasks or top subjects
# Start card title with a verb
# Card (optional)
- title: Get started with monitoring and performance tuning
linkLists:
- linkListType: overview
links:
- text: Monitoring and performance tuning
url: monitor-tune-overview.md
- linkListType: learn
links:
- text: Configure databases for performance
url: /training/modules/configure-databases-performance/
- text: Optimize query performance
url: /training/paths/optimize-query-performance-sql-server/
- text: Monitor and optimize operational resources
url: /training/paths/monitor-optimize-operational-resources-sql-server/
- text: Protect, monitor, and tune
url: /training/modules/protect-monitor-tuning-migrated-database/
# Card (optional)
- title: Database watcher for Azure SQL
linkLists:
- linkListType: concept
links:
- text: Monitor Azure SQL workloads with database watcher
url: ../database-watcher-overview.md
- text: Manage and monitor database watchers
url: ../database-watcher-manage.md
- text: Database watcher FAQ
url: ../database-watcher-faq.yml
- linkListType: how-to-guide
links:
- text: Create a database watcher to monitor Azure SQL
url: ../database-watcher-quickstart.md
# Card (optional)
- title: Azure Monitor and Azure SQL Database
linkLists:
- linkListType: how-to-guide
links:
- text: Monitor Azure SQL Database with metrics and alerts
url: monitoring-metrics-alerts.md?view=azuresql-db&preserve-view=true
- linkListType: concept
links:
- text: Monitor Azure SQL Database with Azure Monitor
url: monitoring-sql-database-azure-monitor.md?view=azuresql-db&preserve-view=true
# Card (optional)
- title: Azure SQL Database intelligent performance recommendations
linkLists:
- linkListType: concept
links:
- text: SQL Database Advisor tuning recommendations
url: database-advisor-implement-performance-recommendations.md
- text: Automatic tuning
url: automatic-tuning-enable.md
- text: Query Performance Insight
url: query-performance-insight-use.md
# Card
- title: Azure SQL Database and Azure SQL Managed Instance resource limits
linkLists:
- linkListType: concept
links:
- text: Single database vCore resource limits
url: resource-limits-vcore-single-databases.md
- text: Single database DTU resource limits
url: resource-limits-dtu-single-databases.md
- text: Elastic pool vCore resource limits
url: resource-limits-vcore-elastic-pools.md
- text: Elastic pool DTU resource limits
url: resource-limits-dtu-elastic-pools.md
- text: SQL Managed Instance resource limits
url: ../managed-instance/resource-limits.md
- text: Instance pools resource limits
url: ../managed-instance/instance-pools-overview.md#resource-limits
# Card (optional)
- title: Intelligent performance analysis for Azure SQL Database and Azure SQL Managed Instance
linkLists:
- linkListType: overview
links:
- text: Intelligent Insights using AI
url: intelligent-insights-overview.md
- linkListType: concept
links:
- text: Metrics and alerts
url: monitoring-metrics-alerts.md
- text: Metrics and diagnostics logging
url: metrics-diagnostic-telemetry-logging-streaming-export-configure.md
- text: Understand the performance diagnostics log
url: intelligent-insights-use-diagnostics-log.md
- text: Azure SQL Analytics
url: /azure/azure-monitor/insights/azure-sql
- text: Detectable performance patterns
url: intelligent-insights-troubleshoot-performance.md
- text: Intelligent query processing
url: /sql/relational-databases/performance/intelligent-query-processing
# Card
- title: Manual performance tuning for Azure SQL Database and Azure SQL Managed Instance
linkLists:
- linkListType: overview
links:
- text: Identify query performance issues
url: identify-query-performance-issues.md
- linkListType: concept
links:
- text: Monitoring using DMVs
url: monitoring-with-dmvs.md
- text: Application and database tuning
url: performance-guidance.md
- text: Using Query Store
url: /sql/relational-databases/performance/monitoring-performance-by-using-the-query-store
- text: Using extended events
url: xevent-db-diff-from-svr.md
- text: Hyperscale performance diagnostics
url: hyperscale-performance-diagnostics.md
# Card
- title: Azure SQL Database and Azure SQL Managed Instance resource scaling
linkLists:
- linkListType: overview
links:
- text: Dynamically scaling resources
url: scale-resources.md
- linkListType: concept
links:
- text: Scaling single database resources
url: single-database-scale.md
- text: Scaling elastic pool resources
url: elastic-pool-scale.md
- text: Scaling managed instance resources
url: ../managed-instance/sql-managed-instance-paas-overview.md#management-operations
- text: Read scale-out
url: read-scale-out.md