cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

SQL Server Support Blog
Options
19.2K

What is causing the Always On AG issue? Is it cluster, AD, DNS, or SQL?

Dharshana on Apr 23 2023 02:29 PM
AG (Always On Availability Groups) is a logical container that holds one or more user databases that failover together. ...
17.8K

​​​Let's make it easy! How to read System Health and sp_server_diagnostics?​

JuanPabloSalg on Mar 29 2023 08:11 AM
Here are some useful steps on how to read System Health and SP_Server_Diagnostic with condition that will trigger warnin...
1,806

Applying SQL Server 2017 CU18 on secondary replica running on Linux OS may fail with script failure

JayaprakashJothiraman on Dec 19 2019 04:31 PM
If SQL Server 2017 is running on Linux operating system and if you have databases configured using Always ON feature, po...
2,097

Create a monitoring and notification mechanism for HADR worker thread Pool

Joseph Pilov on Feb 10 2019 05:23 PM
First published on MSDN on Dec 07, 2017 A customer approached us asking for help on automatic a monitoring process.
6,841

What really happens when HADR_CLUSAPI_CALL wait type is set?

Joseph Pilov on Feb 10 2019 05:23 PM
First published on MSDN on Aug 18, 2017 In a customer scenario we saw a query against system views related to AlwaysOn t...
1,808

DBMIRROR_DBM_MUTEX: The world of Redo Operations

Joseph Pilov on Feb 10 2019 05:23 PM
First published on MSDN on May 26, 2017 There are times when you just run into something and you can deem less important...
15.4K

DbMgrPartnerCommitPolicy::SetSyncState May Seem More Mysterious than It Actually Is

Joseph Pilov on Feb 10 2019 05:22 PM
First published on MSDN on May 24, 2017 AlwaysOn has become a major SQL Server technology.
8,236

AGLatency report tool V2.2 introduction

Simon Su on Jan 15 2019 06:04 PM
First published on MSDN on Sep 08, 2018 I wrote an article to discuss about data movement latency between AG groups:http...
5,585

Lesson learned from an Availability Group performance case

Simon Su on Jan 15 2019 06:00 PM
First published on MSDN on Apr 05, 2018 Writer: Simon SuTechnical Reviewer: Pam Lahoud, Sourabh Agarwal, Tejas Shah Prob...
32K

Troubleshooting data movement latency between synchronous-commit AlwaysOn Availability Groups

Simon Su on Jan 15 2019 05:57 PM
First published on MSDN on Apr 05, 2018 Writer: Simon SuTechnical Reviewer: Pam Lahoud, Sourabh Agarwal, Tejas ShahAppli...
2,423

Analyze Synchronous Commit Impact on High Commit Rate Workloads

mssql-support on Jan 15 2019 05:50 PM
First published on MSDN on Feb 06, 2018 Workloads that rely on auto-commit (each operation like an INSERT has an implied...
4,840

Analyze Network Latency Impact on Remote Availability Group Replica

mssql-support on Jan 15 2019 05:45 PM
First published on MSDN on Dec 21, 2017 Multisite availability groups allow customers to deploy copies of business data ...
105K

Availability Group Database Reports Not Synchronizing / Recovery Pending After Database Log File Inaccessible

mssql-support on Jan 15 2019 05:41 PM
First published on MSDN on Nov 29, 2017 You may find that one or more availability group databases is reported ‘Not Sync...
1,247

Avoid Availability Group Database Data Loss: Do not Deploy File Share Witness From DFS Namespace

mssql-support on Jan 15 2019 05:34 PM
First published on MSDN on Aug 29, 2017 Cluster Quorum File Share Witness Should Not be Part of a DFS NamespaceWhen depl...
11.2K

SQL Server : Large RAM and DB Checkpointing

Guillaume Fourrat on Jan 15 2019 05:32 PM
First published on MSDN on Jun 29, 2017 SQL Server : large RAM and DB Checkpointing Hi everyone,This post’s purpose is t...
4,200

Troubleshooting Internal Load Balancer Listener Connectivity in Azure

mssql-support on Jan 15 2019 05:25 PM
First published on MSDN on Feb 22, 2017 Problem Unable to Connect to Azure availability group listener Creating an avail...
3,295

How to Apply Transaction Logs to Secondary When it is Far Behind

mssql-support on Jan 15 2019 05:24 PM
First published on MSDN on Feb 22, 2017 Problem Large Send Queue You discover that the log send queue for a given availa...
2,188

Making Service Broker Application Highly Available With AlwaysOn

mssql-support on Jan 15 2019 05:23 PM
First published on MSDN on Jan 26, 2017 If you have a Service Broker (SSB) application connecting to SQL Server using an...
1,955

Unable to connect to SQL Server AlwaysOn Listener on Azure due to misconfigured subnet mask

mssql-support on Jan 15 2019 05:20 PM
First published on MSDN on Dec 04, 2016 When it comes to troubleshooting, the more you know the better troubleshooter yo...
841

AlwaysOn Readable Secondaries Can Display Misleading Data & Log File Paths

mssql-support on Jan 15 2019 05:09 PM
First published on MSDN on Jun 29, 2016 Written By:Grant Carter, Senior Premier Field EngineerReviewed By:Mark Weber – P...
563

SQL 2016 - It Just Runs Faster - AlwaysOn AES-NI Encryption

mssql-support on Jan 15 2019 05:05 PM
First published on MSDN on May 05, 2016 The SQL Server 2016, AlwaysOn, log transport takes advantage of hardware based e...

Latest Comments

ebialobrzeski
in Why am I getting so many checkpoint files when I have In-Memory OLTP enabled? on Apr 23 2024 04:41 AM
"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
PVerd
in Why do I get the infrastructure error for login failures? on Feb 29 2024 02:10 PM
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
dvenardos
in OS Hang or Out of Memory due to SQL Ser... No Wait, it's SQL Analysis Services (SSAS) on Feb 22 2024 03:20 PM
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
CetinBasoz
in The OLE DB provider "MSDASQL" for linked server " " supplied inconsistent metadata for a column.The column " " (compile-time ordinal 2) of object " " was reported to have a "DBCOLUMNFLAGS_ISLONG" of 0... on Feb 15 2024 03:50 AM
I am here because I got this error and hoped I would find a clue, but no dice. In your case it might be explained by nvarchar(max), however I got it on a postgreSQL boolean column which is bit on SQL server. Makes no sense. Discard this. I found my solution, naturally outside Microsoft Tech Communit...
0 Likes
jayantdass
in Changes to hashing algorithm for self-signed certificate in SQL Server 2017 on Feb 02 2024 04:35 AM
Great one
0 Likes