Questions tagged [sql-server-2022]
SQL Server 2022 (major build version 16.00.xxxx). Please also tag sql-server.
286 questions
0
votes
0
answers
8
views
Do queries blocked by Resource Governor's GROUP_MAX_REQUESTS not consume threads?
Do queries blocked by Resource Governor's GROUP_MAX_REQUESTS not consume threads? My demo below seems to suggest so, but I find this impossible.
Take a fresh server (you really don't want these ...
- 1,398
1
vote
1
answer
24
views
How can I use Resource Governor purely as a monitoring tool?
It is clear that Resource Governor monitors how much work each group is doing. sys.dm_resource_governor_workload_groups makes this utterly obvious.
Suppose that:
I don't yet trust my ability to ...
- 1,398
0
votes
0
answers
10
views
How do we know that SQL Server will give out up to 75% of Max Server Memory to query workspace across multiple queries?
People who I rate reasonably make claims such as this
Out of the box, any query can come along and ask for ~25% of your server’s max server memory setting, and SQL Server is willing to loan out ~75% ...
- 1,398
5
votes
1
answer
146
views
Update mask evaluation will be disabled in net_changes_function because the CLR configuration option is disabled
When I enable CDC on a database table on a SQL Server instance that has CLR disabled, I see this exception in the logging:
Update mask evaluation will be disabled in net_changes_function because the ...
- 274
3
votes
2
answers
130
views
sys.dm_db_index_operational_stats, range_scan_count column
CREATE TABLE Test(A INT IDENTITY(1,1), B INT, C INT);
CREATE CLUSTERED INDEX IX_Test_A ON Test(A);
SET NOCOUNT ON;
-- stop after a few seconds
WHILE 1=1 INSERT INTO Test(B,C) SELECT CAST(RAND()*...
- 1,780
0
votes
1
answer
34
views
Are half-second PARALLEL_REDO_FLOW_CONTROL waits expected while under mild CPU pressure?
What I'm Asking
At 80% CPU usage on a readable AG secondary, is it expected that PARALLEL_REDO_FLOW_CONTROL will exceed 500 ms? If not, what does this indicate?
What I Know
I have an availability ...
- 1,398
1
vote
2
answers
110
views
Remotely Lock Table During Data Transfer Session
So I have an SQL Express 2022 database server running in our DMZ that receives records from a partner service. I want to transfer these records from the DMZ database to our main DB cluster (SQL ...
- 267
2
votes
1
answer
530
views
Cumulative Update 23 - KB5074819 - Database Mail - No longer working
Has anyone else had any trouble with Database Mail in Cumulative Update 23 - KB5074819?
When we upgraded from CU 22 to CU 23, we suddenly stopped getting email alerts on two of our SQL Servers that we ...
1
vote
1
answer
92
views
Does RCSI store the same data as accelerated database recovery?
As the documentation says
When ADR is enabled, row versions can be stored in persistent version store (PVS) in one of the following ways, depending on the size of the row prior to modification:
If ...
- 1,398
0
votes
1
answer
45
views
Do LOB columns prevent batch mode?
I copy and pasted this from somewhere. I do not remember where and Google cannot find it. It might have been about in-memory OLTP.
One of the very important points here is that it is enough just to ...
- 1,398
0
votes
1
answer
45
views
Missing SNAC DLL Preventing DB Mail Setup in SQL Server 2022
I'm getting the following error on SQL Server Agent startup when setting up Database Mail profiles on a SQL Server 2022 instance
[474] Unable to refresh Database Mail profile xxx. (reason: System....
- 1,955
0
votes
1
answer
59
views
Transaction Log Filling During Partial Backup
I have a large, active database in simple recovery mode. The data in one main table is partitioned across filegroups, and the oldest filegroups are marked as read only. I am attempting to run a ...
- 1,152
3
votes
1
answer
262
views
Do long‑running transactions on the primary make the data shown in unrelated tables on secondary replicas stale?
The documentation makes the following spectacular claim
All read workloads on the secondary replica are snapshot isolation queries. In snapshot isolation, read-only clients see the availability ...
- 1,398
0
votes
1
answer
32
views
Does WAIT_AT_LOW_PRIORITY propagate to secondary availability group replicas?
Context
I am sworn to have readable availability group replicas. I am also sworn to low RTO. These two oaths conflict. For example, automatic statistics updates can cause schema modification locks ...
- 1,398
0
votes
1
answer
36
views
Can an asynchronous secondary availability group replica without a cluster harm the primary?
One of the greatest benefits of log shipping is that the primary is completely ignorant of the secondary. You simply cannot kill a log shipping primary by torturing the secondary1. Conversely, under a ...
- 1,398