There is no universally safe set of SQL Server performance settings. The right change depends on your SQL Server version, deployment platform, workload, and measured bottleneck. Start with Query Store or equivalent evidence, change one relevant setting at a time, compare plans and runtime behavior, and keep a tested rollback path. Before changing anything, identify whether the control applies at query, database, server, or workload-group scope; those scopes have different reach and precedence.
Start with a baseline, not a magic setting
Before tuning, record the SQL Server release, database compatibility level, deployment type (such as on-premises SQL Server or Azure SQL Database), workload mix, and the symptom you are trying to fix. Capture representative query plans and runtime measures, including duration, CPU, waits, and concurrency. A setting that helps a reporting query may harm a latency-sensitive OLTP workload.
Query Store retains query and plan history and can help identify regressions and establish a before-and-after comparison. Check that it is enabled and review its capture and retention configuration: defaults vary by SQL Server version and Azure service. SQL Server 2022 enables Query Store by default for newly created SQL Server databases, but that does not establish its state or configuration for every existing database or cloud service. See Microsoft’s Query Store guidance.
- Choose a baseline period that includes the workload patterns you need to assess, such as peak and batch periods.
- Change one control at a time so you can attribute a result.
- Compare the same queries and representative operating conditions before and after the change.
- Define how to reverse the change before applying it.
Some database options and scoped configurations invalidate affected cached plans, leading to recompilation that can temporarily affect performance. Account for that immediate effect separately from the longer-term behavior you are trying to measure. Microsoft documents this plan-cache consideration.
Quick wins for a faster PC:
Fix the driver behind crashes, sound loss and screen glitchesFind Drivers →Repair Windows errors before they cause bigger problemsFix Now →Scan for outdated or missing drivers - takes under a minuteDriver Scan →#1 Best Overall
- Read Before You Buy — No Video Output: These adapters support charging and USB 2.0 data transfer, but cannot transmit video signals. Except for standard USB webcams (which use USB data only), they are not compatible with HDMI/DisplayPort cables, video-capable USB-C hubs, or docking stations with video output.
- Convert USB-A Ports to USB-C: Designed to connect USB-C earphones, cables, flash drives, card readers, and other USB-C accessories to standard USB-A ports. Plug-and-play with no drivers or software required.
- Aluminum Alloy Housing: Built with a sturdy aluminum alloy shell that aids in heat dissipation and protects against daily wear and scratches. Designed to maintain a stable and secure connection.
- Compact & Travel-Friendly: The ultra-compact design allows the adapter to stay plugged into your device without blocking adjacent ports or adding bulk, reducing wear and tear on your original USB ports.
- 12-Month Warranty: Backed by a 12-month manufacturer warranty for peace of mind. Designed to meet strict quality control standards for reliable everyday performance.
Which settings are worth evaluating?
| Control | Scope and effect | When to investigate |
|---|---|---|
| Database compatibility level | Database-wide; gates query-processor behavior and can change plan selection. | After an engine upgrade, or when measured plan changes point to optimizer behavior. |
| MAXDOP | Can be set at query, database, server, or Resource Governor workload-group scope; caps processors used for parallel plan execution. | When evidence suggests parallel execution is affecting CPU, waits, or query performance. |
| Cost threshold for parallelism | Server-level advanced setting; affects when SQL Server considers parallel plans based on estimated plan cost. | When observed parallel-plan selection and workload behavior justify reviewing the threshold. |
| Query Store hints | Query-scoped plan influence, available in supported configurations. | When a specific query regresses and a database-wide behavior change is unsuitable. |
These controls are not interchangeable. Compatibility level changes can affect plans across a database; MAXDOP and cost threshold affect parallel-plan behavior at different scopes; a Query Store hint targets an individual query. SQL Server version, compatibility level, and cloud service determine which options are available. Review Microsoft’s documentation on intelligent query processing and scoped configurations for the applicable features and configuration details.
Compatibility level: separate the engine upgrade from optimizer changes
Compatibility level controls which query-processor behaviors are available to a database. Moving to a newer level can change execution plans, so an engine upgrade does not mean you must immediately change every database’s compatibility level.
Rank #2
- 5-in-1 USB-C Hub: Experience comprehensive connectivity featuring a Power Delivery input, two USB-A 2.0 ports, a USB-A 3.0 port, and an HDMI port. (Note: The USB-C power delivery input port is only for connecting an external wall charger to power your laptop and cannot power peripheral devices.)
- 90W Pass-Through Charging: Achieve optimal charging with 90W pass-through power to your laptop, supported by a total input of 100W, with the hub reserving 10W for operational efficiency. (Note: Wall charger not included.)
- Quick Data Transfers: Accelerate your productivity with rapid data transfers using a high-speed 5Gbps USB 3.0 port and two 480Mbps USB 2.0 ports.
- 4K HDMI Display: Enhance your visual experience with a hub capable of delivering 4K resolution at 30Hz in both mirror and extend modes. Please note that this hub is compatible with MacBook (macOS 12 and newer), Windows 10 and 11, ChromeOS, and laptops equipped with DP Alt Mode and Power Delivery. Note: This device is not compatible with Linux.
- What You Get: Anker USB-C Hub (5-in-1, 4K HDMI), welcome guide, 18-month warranty, and our friendly customer service.
A safer upgrade sequence
- Upgrade the SQL Server engine while retaining the database’s existing compatibility level.
- Enable Query Store and collect enough representative workload history to establish a baseline.
- Test the newer compatibility level and compare query plans and runtime behavior against that baseline.
- Investigate regressions query by query; use a targeted remediation when the evidence identifies a limited set of affected queries.
Microsoft recommends using Query Store to establish a baseline before changing compatibility level. The new level can expose newer optimizer behavior, but the outcome depends on the database’s queries and workload, not on the level number alone. See Microsoft’s compatibility-level guidance and Query Store guidance.
When only a few queries regress
A regression in a small set of queries does not automatically require reverting the whole database. Inspect the affected plans and determine whether a query-scoped remedy is appropriate. Microsoft recommends testing the application at the latest compatibility level before applying Query Store hints; hints can influence optimizer behavior for an individual query when a newer database-wide level is unsuitable or that query regresses. A hint is a targeted intervention, not a substitute for diagnosing the plan. See Query Store hints and compatibility levels and Query Store hints.
Free tools Windows power users keep installed
One-click scans. No signup required.
Rank #3
- Sleek 7-in-1 USB-C Hub: Features an HDMI port, two USB-A 3.0 ports, and a USB-C data port, each providing 5Gbps transfer speeds. It also includes a USB-C PD input port for charging up to 100W and dual SD and TF card slots, all in a compact design.
- Flawless 4K@60Hz Video with HDMI: Delivers exceptional clarity and smoothness with its 4K@60Hz HDMI port, making it ideal for high-definition presentations and entertainment. (Note: Only the HDMI port supports video projection; the USB-C port is for data transfer only.)
- Double Up on Efficiency: The two USB-A 3.0 ports and a USB-C port support a fast 5Gbps data rate, significantly boosting your transfer speeds and improving productivity.
- Fast and Reliable 85W Charging: Offers high-capacity, speedy charging for laptops up to 85W, so you spend less time tethered to an outlet and more time being productive.
- What You Get: Anker USB-C Hub (7-in-1), welcome guide, 18-month warranty, and our friendly customer service.
MAXDOP: tune parallelism to the workload and scope
MAXDOP sets the maximum number of processors used for parallel plan execution. It is not a guarantee that a query will run faster, nor is it a per-query total-worker limit: Microsoft explains that the limit applies per task, and one request can create multiple tasks.
MAXDOP may be configured at query, database, server, or Resource Governor workload-group scope. A database-scoped MAXDOP setting overrides the server setting unless the database value is 0; a query hint can override the database setting, while a workload-group limit can cap the result. Therefore, check all applicable scopes before interpreting the effective value. The correct setting depends on workload and platform, so do not choose a number without topology and workload evidence. See Microsoft’s MAXDOP configuration guidance.
Rank #4
- Dual Converters, Infinite Potential：Includes 2× USB C male to USB A female adapters and 2× USB A male to USB C female adapters. Perfect for a wide range of uses—tablets with Bluetooth keyboards, expand USB ports on macbook, and more. Two different converters for all your daily needs
- Next-Level 10Gbps & 3A Charging: No more slow 480Mbps, this usb to usb c adapter has a transfer speed of up to 10Gbps, allowing you to do more transferring in less time. This usb adapter fits both USB A and USB C charger, supporting up to 3A fast charging
- Upgraded Exquisite Craftsmanship: With an aluminum alloy housing and metal connector, the usbc to usb adapter is extremely durable and sturdy. Rigorously tested to withstand more than 10,000 times of plugging and unplugging, ensuring long-lasting performance
- Broad Compatible: The usb c to usb adapter widely supports all USB C/ USB A devices like laptops, tablets, cellphones, car chargers, and phone chargers. Such as compatible with MacBook Pro/Air 2023/2022, Thunderbolt 4/3 Devices,Apple MagSafe Watch 9/8/7/SE/Ultra, iPad Pro 2022/2021, Samsung Galaxy S23/S20/S10, and iPhone 17/16/15 Pro. Plug and play
- Please Note: To reach 10Gbps speed, keep the cable under 3.3 ft. For USB A Male to USB C adapters, try flipping the USB C connector. USB C Male to USB A adapters support bidirectional 10Gbps transfer within 3.3 ft
What to look for
- Whether the queries of concern use parallel plans and whether their CPU, duration, waits, or concurrency are problematic.
- Whether query hints or Resource Governor workload-group settings change or constrain the effective MAXDOP.
- Whether the workload is mixed, such as concurrent OLTP queries alongside reporting or batch work, making a single broad setting a poor fit.
SQL Server 2022 provides Degree of Parallelism Feedback for supported configurations at compatibility level 160. It can adjust parallelism for repeating queries and revert changes if performance regresses. Its availability is version- and configuration-dependent; it is not a reason to skip measurement. Microsoft’s intelligent query processing documentation describes the feature.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.Cost threshold for parallelism: do not treat 5 as a target
Cost threshold for parallelism is a server-level advanced setting that determines when SQL Server considers parallel plans, using estimated plan cost. Estimated cost is a relative measure for plan selection, not a prediction of actual elapsed time. Microsoft states: “The default value of 5 is a starting point, not a recommendation.”
Best Value
- 5-in-1 Connectivity: Equipped with a 4K HDMI port, a 5 Gbps USB-C data port, two 5 Gbps USB-A ports, and a USB C 100W PD-IN port. Note: The USB C 100W PD-IN port supports only charging and does not support data transfer devices such as headphones or speakers.
- Powerful Pass-Through Charging: Supports up to 85W pass-through charging so you can power up your laptop while you use the hub. Note: Pass-through charging requires a charger (not included). Note: To achieve full power for iPad, we recommend using a 45W wall charger.
- Transfer Files in Seconds: Move files to and from your laptop at speeds of up to 5 Gbps via the USB-C and USB-A data ports. Note: The USB C 5Gbps Data port does not support video output.
- HD Display: Connect to the HDMI port to stream or mirror content to an external monitor in resolutions of up to 4K@30Hz. Note: The USB-C ports do not support video output.
- What You Get: Anker 332 USB-C Hub (5-in-1), welcome guide, our worry-free 18-month warranty, and friendly customer service.
Microsoft advises experienced database professionals to increase the threshold in small increments and observe a full business cycle before making another change. Consider the workload evidence rather than selecting a replacement value by convention. A low threshold can coincide with many CPU-light queries going parallel and parallelism-related waits; a high threshold can leave CPU-heavy queries serial and CPU utilization higher than optimal. These are clues to investigate, not proof that the threshold caused the problem. Microsoft’s cost-threshold guidance covers the setting and tuning advice.
Azure SQL Database does not allow users to set this server option. Microsoft points to MAXDOP as the parallelism control there, so do not apply on-premises server-setting instructions to that service.
Parameter sensitivity: diagnose before disabling sniffing
Do not disable parameter sniffing as a blanket performance fix. Queries can behave differently for parameter values when data distributions are nonuniform, but an intervention should begin by identifying and measuring the specific affected query. SQL Server 2022 at compatibility level 160 enables Parameter Sensitive Plan optimization by default; it can handle eligible cases by using distinct plans for different parameter ranges. Check version, compatibility level, and the observed query behavior before considering a broader change. Microsoft’s Parameter Sensitive Plan optimization documentation explains applicability.
How to choose and validate a change
- Identify the scope. Decide whether the symptom belongs to one query, one database, a workload group, or the server as a whole.
- Confirm applicability. Check SQL Server release, database compatibility level, and deployment platform; cloud services do not expose every server setting.
- State the hypothesis. Tie a proposed change to observed plans and measures, such as duration, CPU, waits, and concurrency, rather than to a default value alone.
- Assess blast radius. Consider how many queries the change can affect and whether it can invalidate cached plans or trigger recompilations.
- Apply one change and observe. For compatibility-level testing, use Query Store baselines; for cost threshold changes, follow Microsoft’s advice to use small increments and observe a full business cycle.
- Compare and decide. Keep the change only if representative workload results support it; otherwise use the rollback plan and continue diagnosis.
The defensible result may be no setting change. If evidence isolates a small group of queries, a query-scoped remedy may have a smaller blast radius than changing behavior database-wide. If the evidence points to broader behavior, assess the broader setting at its actual scope.
Crashes, No Sound, or Screen Glitches?
Random freezes, missing sound and display glitches usually trace back to one bad driver. Find and replace yours safely.Free scan · under a minuteWindows Errors? Fix Them Before They Spread
Repair common Windows errors and clear accumulated junk for a smoother, more stable PC - no reinstall needed.Free scan · no reinstallQuick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
