Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                
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
3,165

​​​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,625

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...
1,798

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.
5,066

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,351

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...
12.7K

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.
5,237

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...
3,948

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...
25K

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...
1,533

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...
3,472

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 ...
82K

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,002

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...
7,621

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...
2,903

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...
1,996

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...
1,628

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,368

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...
519

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...
440

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...
355

SQL 2016 - It Just Runs Faster: AlwaysOn Parallel Compression / Improved Algorithms

mssql-support on Jan 15 2019 05:05 PM
First published on MSDN on May 03, 2016 SQL Server 2016 introduces two distinct changes in the AlwaysOn transport, compr...

Latest Comments

KashifAkram03
in Intermittent ANONYMOUS LOGON of SQL Server linked server double hop on Mar 24 2023 07:51 AM
Hi, Thanks for sharing the info. In my situation, I have 2 environments let's call them old and new. The Old is working perfectly fine with no issues. In New, we have added a windows server 2019 which will be accessing the Report Server from the Old environment. In New, the server we are getting is ...
0 Likes
KothariRaunak
in Using Amazon RedShift with Power BI on Mar 23 2023 01:18 AM
@Krishnakumar_Rukmangathan - when we setup the redshift DB as a a ODBC connection, is it possible in power BI to directly connect to the DB using this connection WITHOUT the user needing to provide DB CREDENTIALS again? I have already provided the user/password when setting up the ODBC DSN driver so...
0 Likes
alexmpowers
in When in doubt, Reboot! on Mar 03 2023 08:01 AM
Turning it off and back on again is like magic. Great advice!
0 Likes
David Shiflet
in Why do I get the infrastructure error for login failures? on Feb 15 2023 09:21 AM
Is there any way to identify when #3 has happened? I ran into a situation that looks like that, where the local Polybase service wouldn't start because it didn't have CONNECT to ENDPOINT privilege. I had to re-grant public access to the TCP endpoint.
0 Likes
kirkhughes
in Kerberos Configuration Manager updated for Reporting Services on Feb 07 2023 03:31 AM
I wonder if this thread is still monitored. Have you had any issues with misplaced SPN's when you're using MSA's or gMSA's in SQL Server. Normal AD accounts don't seem to throw the misplaced warning. Logged with MS support who said this is likely to be a bug in the application.
0 Likes