Database Engine Tuning Advisor
GPTKB entity
Statements (101)
| Predicate | Object |
|---|---|
| gptkbp:instance_of |
gptkb:Data
gptkb:tools |
| gptkbp:analyzes |
performance metrics
Execution Plans execution plans database workloads Workload Files Database Workloads Query Workloads SQL Server Workloads |
| gptkbp:automated |
gptkb:Shell
SQL scripts |
| gptkbp:can_create |
Tuning Reports
tuning reports Tuning Recommendations |
| gptkbp:can_provide |
Performance Insights
identify bottlenecks Configuration Changes optimize resource allocation Resource Allocation Changes partitioning strategies query rewrites Index Maintenance Strategies improve query plans index strategies Performance Recommendations Execution Recommendations Optimize Queries Partitioning Strategies Statistics Updates |
| gptkbp:developed_by |
gptkb:Microsoft
|
| gptkbp:enhances |
gptkb:resource_utilization
database performance Query Execution Times |
| https://www.w3.org/2000/01/rdf-schema#label |
Database Engine Tuning Advisor
|
| gptkbp:integrates_with |
gptkb:Azure_Data_Studio
gptkb:SQL_Server_Management_Studio gptkb:SQL_Server_Data_Tools gptkb:SQL_Server_Profiler |
| gptkbp:is_a |
Performance Tuning Tool
|
| gptkbp:is_accessible_by |
GUI
command line |
| gptkbp:is_available_in |
gptkb:SQL_Server_2005
gptkb:SQL_Server_2008 gptkb:SQL_Server_2014 gptkb:SQL_Server_2019 gptkb:SQL_Server_2012 gptkb:SQL_Server_2016 gptkb:SQL_Server_2017 SQL Server 2005 and later SQL Server 2012 and later |
| gptkbp:is_available_on |
gptkb:Linux
gptkb:mac_OS gptkb:Windows |
| gptkbp:is_compatible_with |
Windows Operating Systems
|
| gptkbp:is_considered |
best practice tool
|
| gptkbp:is_designed_for |
SQL Server Users
|
| gptkbp:is_documented_in |
Microsoft documentation
|
| gptkbp:is_evaluated_by |
Query Performance
Database Queries |
| gptkbp:is_optimized_for |
Database Performance
indexes queries |
| gptkbp:is_part_of |
gptkb:Microsoft_SQL_Server_suite
gptkb:SQL_Server_Management_Studio gptkb:SQL_Server_Suite database management process SQL Server Tools |
| gptkbp:is_recognized_by |
Performance Bottlenecks
Missing Indexes |
| gptkbp:is_recommended_for |
complex queries
large databases |
| gptkbp:is_used_by |
gptkb:developers
Database Administrators data analysts database administrators |
| gptkbp:is_used_for |
Database Optimization
|
| gptkbp:is_used_in |
development environments
production environments testing environments |
| gptkbp:is_used_to |
Analyze SQL Queries
|
| gptkbp:is_utilized_by |
Performance Engineers
|
| gptkbp:is_utilized_in |
Enterprise Environments
|
| gptkbp:offers |
gptkb:user_interface
|
| gptkbp:provides |
gptkb:recommendations
Recommendations |
| gptkbp:provides_support_for |
Database Optimization
Database Performance Tuning |
| gptkbp:reduces |
query response time
Resource Consumption |
| gptkbp:released_in |
gptkb:2005
|
| gptkbp:requires |
gptkb:SQL_Server_Database_Engine
SQL Server instance |
| gptkbp:support |
Multiple Databases
|
| gptkbp:supports |
gptkb:My_SQL
Query Optimization Index Optimization |
| gptkbp:used_for |
Performance Tuning
performance tuning |
| gptkbp:bfsParent |
gptkb:My_SQL
|
| gptkbp:bfsLayer |
4
|