Core component of SQL Server for storing, processing, and securing data
SQL Server 2022 Always On metadata calls slow after patching
Following recent patching of our on-premises SQL Server 2022 environment, transaction log backups have become significantly slower than before the patch. The servers are configured with SQL Server Always On Availability Groups. The issue affects…
SQL Server Database Engine
SQL Server: Index creation and conversion issues with columnstore indexes — Encountering internal query processor errors
Problem description I am experiencing issues when creating or converting indexes on a table with existing data in SQL Server running on an Azure VM. Specifically, when I attempt to create or modify clustered columnstore indexes with options like…
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
Cannot successfully install SQL Server 2025 Developer Standard Edition due to Engine Services Feature failure
Attempted to install SQL Server 2025, but was provided with the error details listed below. It should be noted that previous versions of SQL Server, 2019 and 2022, were installed in the past, but are now removed from the device. Attempted repair resulted…
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
SQL Server new Python version?
We are running SQL Server 2022 with machine learning services to execute python scripts. At the moment we are using the supported Python version 3.10 but this version is End Of Life. Microsoft is not supporting a new version? What is the path to take on…
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
Performance Regression Observed on SQL Server 2025 Running on Windows Server 2025
A reproducible performance degradation is observed when executing an identical SQL workload through SQL Server Management Studio (SSMS) on SQL Server 2025 running on Windows Server 2025. The workload consists of inserting 200,000 records into a table…
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
firewall rule preventing user login
I have a sql database "LIMLdb" running on "apgsystems01" sql server running on a virtual machine. I need to be able to have my users log in from different locations. When they try the are assigned a new ip and cannot log in until I…
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
SQL Server 2025 executing request with in SQL connexion is very slow
Hello, I installed SQL 2025 on a new VM to test the installation of my application, which currently runs on SQL 2022. I’m facing an issue with SQL 2025 (fresh installation on a new machine with a new DB): the queries are extremely slow when I use a SQL…
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
SQL Server 2022 performance degradation (2x slower) with increased Context Switches/sec under Compatibility Level 110 after migration
Hi, Please note that this message was translated using Generative AI. I apologize in advance for any unnatural phrasing or translation errors. We recently migrated our database from SQL Server 2017 to SQL Server 2022 on a new virtual machine. After the…
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
Is MS ODBC driver 18.5.1.1 compatible with SQL Server 2025 for new JSON and VECTOR types?
Hello, I would like to test the new JSON and VECTOR types of SQL Server 2025 with the Microsoft ODBC driver for SQL Server. I have installed SQL Server 2025 CTP 2.0 on my Windows 11. For now I have MS ODBC driver 18.5.1.1 for Linux (Debian 12). Is this…
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
SQL 2016 to 2022 AG migration on Azure VMs: how to keep the existing DNN listener name working for apps that cache DNS and can't be restarted?
Environment Source: 2-node SQL Server 2016 AG on Azure VMs, using a DNN listener Target: new 2-node SQL Server 2022 AG on Azure VMs, Database: about 4 TB, to be migrated using a distributed AG Clients: many applications and reports that use the…
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
Geography STDistance() and ShortestLineTo() overestimate polygon-to-polygon distance in SRID 104001 (unit sphere)
(Microsoft SQL Server 2022) In SRID 104001 (unit sphere), STDistance() between two non-intersecting polygons returns values that are too large. In the cases tested, the error was up to about 63 km (converted with R = 6371 km) for polygons 200–500 km…
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
sys.fn_hadr_backup_is_preferred_replica() are taking much longer than expected since the patch
We’ve noticed that SQL transaction log backups have become significantly slower following the recent SQL Server 2022 patching. The issue appears to be affecting multiple Availability Groups rather than a single database. For example, even checks such as…
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
Error 8624, Severity 16: Internal Query Processor Error: The query processor could not produce a query plan.
Hi, Environrment : SQL Server 2022, build 16.0.4252.3 (CU24 + GDR, May 2026) We are experiencing an intermittent issue on Microsoft SQL Server 2022 Enterprise Edition running in an Always On Availability Group environment.A specific stored procedure…
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
Source files within source systems are not synchronized with raw tables in Azure database
Hello, I would like to ask for suggestions regarding the following problem: Our DWH architecture was initially configured in the way, that source files from various source systems should be aligned with actual raw tables in our Azure database [we…
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
SQL Server 2025 PBKDF2 login performance regression with Microsoft Access/ACE – supported mitigation?
We have reproduced a significant SQL Authentication performance regression after migrating an on-premises Microsoft Access application from SQL Server 2022 to SQL Server 2025. Environment SQL Server 2025 Express CU9, 17.0.5005.3 Windows Server 2022 …
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
Clarification on MSOLEDBSQL19 Behavior with TrustServerCertificate=True
Hello Team, We are currently using the MSOLEDBSQL19 driver on Windows systems and would like to better understand its connection behavior related to encryption and certificate validation. While testing SQL Server connectivity, we observed that a…
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
What AES mode does TDE use in on-premises SQL Server?
We are certifying a software product that uses Microsoft SQL Server as its database engine. The certification body has asked us to identify the AES mode of operation used by Transparent Data Encryption (TDE) when SQL Server is deployed on-premises. The…
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
SQL Server: Unexpected CPU Spike on Primary Replica — Troubleshooting Assistance Needed
Problem description I am experiencing an issue with my SQL Server virtual machine where the primary replica of an Always On availability group in the UK South region is experiencing unexpected CPU utilization spikes up to 100%. This occurs under a…
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
Log shipping backups
Good Morning Can we take full backup of primary database and full backup of secondary database in Log Shipping?
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
Fix a broken Log shipping
Good Morning, In our environment, we have log shipping backup configured every 15 minutes. In the middle, manual log backup was taken and this breaks log chain. How to fix this?
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data