SQL Server Support Blog

Options
19.7K
Dharshana on Apr 23 2023 02:29 PM
18.4K
JuanPabloSalg on Mar 29 2023 08:11 AM
1,814
JayaprakashJothiraman on Dec 19 2019 04:31 PM
2,125
Joseph Pilov on Feb 10 2019 05:23 PM
6,949
Joseph Pilov on Feb 10 2019 05:23 PM
1,836
Joseph Pilov on Feb 10 2019 05:23 PM
15.5K
Joseph Pilov on Feb 10 2019 05:22 PM
8,359
Simon Su on Jan 15 2019 06:04 PM
5,682
Simon Su on Jan 15 2019 06:00 PM
32.3K
Simon Su on Jan 15 2019 05:57 PM
2,468
mssql-support on Jan 15 2019 05:50 PM
4,913
mssql-support on Jan 15 2019 05:45 PM
106K
mssql-support on Jan 15 2019 05:41 PM
1,291
mssql-support on Jan 15 2019 05:34 PM
11.5K
Guillaume Fourrat on Jan 15 2019 05:32 PM
4,284
mssql-support on Jan 15 2019 05:25 PM
3,343
mssql-support on Jan 15 2019 05:24 PM
2,223
mssql-support on Jan 15 2019 05:23 PM
1,983
mssql-support on Jan 15 2019 05:20 PM
860
mssql-support on Jan 15 2019 05:09 PM
570
mssql-support on Jan 15 2019 05:05 PM

Latest Comments

@florin_gheliuc Update to at least CU6.Or disable the query store. This tells you that it is caused by Query Store.| * Exception Address = [...] pdb="qds.pdb" [...] module="qds" [...] We had a ticket with MS because of this stack dump, and a fix was pushed in CU5.Cumulative update 5 for SQL Server 2...
0 Likes
Hello!After upgrading our server to MSSQL 2022, there are lots of error messages that we receive on our email, at the IT.We have an automated mail from SSMS that sends these, if you want, i'll give you the code for that too.I just want to know if we should be worried, because every forum I've checke...
0 Likes
"Even without any memory optimized tables,number of checkpoint files keep going up every time we issue a checkpoint"Is there any reason that this keeps on happening even after the table is dropped? What is stored in those checkpoint files and why are they there even in a situation where there is no ...
0 Likes
First SQL Query as text for the next poor fellow who finds this post :D SELECT spm.class_desc, spm.permission_name, spm.state_desc, spr.name, spr.type_desc, spr.is_disabled, ep.name AS EndpointName, ep.protocol_desc AS EndPointDescription, ep.state_desc AS EndPointState, ep.type_desc AS EndpointType...
1 Likes
This is a Windows defect.If memory allocation calls are going to fail due to a lack of resident available memory then Windows should be setting the memory pressure state so that applications can voluntarily release memory rather than just crashing.
0 Likes