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: 

Azure Database Support Blog
Options
592

Lesson Learned #500: Connection Leaks and Query Execution using HikariCP

Jose_Manuel_Jurado on May 31 2024 11:31 AM
Other lesson learned about HikariCP has been when we enabled setLeakDetectionThreshold working on a service request was ...
11.1K

Lesson Learned #499: HikariCP Retry Policy - The connection is closed

Jose_Manuel_Jurado on May 31 2024 10:55 AM
Today, I worked on a service request that our customer got the following error message: 19:28:43.232 [main] WARN com.zax...
845

Lesson Learned #498:Understanding the Role of STATMAN in SQL Server and Its Resource Consumption

Jose_Manuel_Jurado on May 31 2024 01:56 AM
Today, I worked on a service request that our customer reported a performance issue and they reported that this query: S...
977

Lesson Learned #497:Understanding the Ordering of uniqueidentifier in SQL Server

Jose_Manuel_Jurado on May 30 2024 07:10 AM
Today, I worked on a service request that our customer asked about how SQL Server sorts the uniqueidentifier data type. ...
821

Lesson Learned #496:Verifying Network Route to Azure SQL Database via VPN in Windows

Jose_Manuel_Jurado on May 28 2024 10:17 AM
Today, I worked on a service request where our customer was using a VPN, but the network routes seemed to indicate it wa...
717

Lesson Learned #495: Monitoring DNS Resolution with PowerShell of Azure SQL Server

Jose_Manuel_Jurado on May 28 2024 05:15 AM
Today, I worked on a service request where the DNS was providing an incorrect IP address randomly. In this article, I wo...
899

Lesson Learned #494: High number of Executions Plans for a Single Query

Jose_Manuel_Jurado on May 27 2024 09:24 AM
Today, I worked on a service request where our customer detected a high number of execution plans consuming resources in...
739

Lesson Learned #493: Monitoring Application Performance with Server Performance Counters

Jose_Manuel_Jurado on May 24 2024 11:57 AM
Today, I worked on a service request where our customer reported several performance issues in their application connect...
815

Lesson Learned #492: Improving Extended Events in Azure SQL

Jose_Manuel_Jurado on May 22 2024 05:46 AM
In the last months, our Product Team has been working to enhance Extended Events for Azure SQL as you could see in their...
794

Lesson Learned #491: Monitoring Blocking Issues in Azure SQL Database

Jose_Manuel_Jurado on May 21 2024 04:43 AM
Time ago, we wrote an article Lesson Learned #22: How to identify blocking issues? today, I would like to enhance this t...
1,029

Lesson Learned #490: Monitoring Access from Specific Applications to Azure SQL Database

Jose_Manuel_Jurado on May 18 2024 08:09 AM
This week, I worked on a service request where our customer needed to ensure that specific applications could not connec...
1,091

Lesson Learned #489:Investigating CPU Spikes with Query Store Overall Resource Consumption Report

Jose_Manuel_Jurado on May 17 2024 01:44 AM
Yesterday, I worked on a customer who experienced a CPU spike that went 90% during the timeframe of 19:00 to 21:00. I wo...
1,138

Lesson Learned #488: A severe error occurred on the current command. Operation cancelled by user.

Jose_Manuel_Jurado on May 16 2024 12:32 AM
Today, I worked on a service request that our customer got this error message: "A severe error occurred on the current c...
1,281

Lesson Learned #487: Identifying Parallel and High-Volume Queries in Azure SQL Database

Jose_Manuel_Jurado on May 15 2024 03:57 AM
Today, I worked on a service request that our customer needs to monitor and optimize queries that can significantly impa...
1,059

Lesson Learned #486: Snapshot Isolation Transaction Failed Due to a Concurrent DDL Statement

Jose_Manuel_Jurado on May 14 2024 01:33 AM
Today, we worked on a service request that our customer faced the following error message: Msg 3961, Level 16, State 1, ...
870

Lesson Learned #485: Index Recomendation or the Importance of Index Selection in SQL Server

Jose_Manuel_Jurado on May 13 2024 09:56 AM
Today, I worked on a service request that caught my attention regarding index missing recommendations given by SQL Serve...
1,048

Lesson Learned #484: Database Performance Monitoring with PowerShell and ReadScale-Out Environments

Jose_Manuel_Jurado on May 10 2024 06:20 AM
Today, I handled a service request from our customer seeking additional information on performance monitoring for ReadSc...
1,906

Lesson Learned #483: Optimizing Performance in Azure SQL Database ReadScale Out Databases

Jose_Manuel_Jurado on May 09 2024 08:02 AM
Today, I worked on a service request that our customer has a Business Critical database with 4 vCores and Read-Scale Out...
1,392

SQL MI Restore with valid SAS key failing with Operating System Error 86

SamGarth on Apr 22 2024 01:39 AM
We will provide details about a workaround for resolving the "Operating System Error 86" encountered during database res...
1,732

Lesson Learned #482: Identifying Potential Duplicate Statistics

Jose_Manuel_Jurado on Apr 01 2024 11:41 AM
Some time ago, we encountered a support case where a customer experienced significant delays in updating auto-created an...
2,111

Lesson Learned #480:Application-Level Locking in Azure SQL Database - Ensuring Exclusive Access

Jose_Manuel_Jurado on Mar 30 2024 02:41 PM
In certain circumstances, we need to apply production changes or exclusive access to one or more resources by only one i...
1,608

Lesson Learned #481: Query Performance Analysis Tips

Jose_Manuel_Jurado on Mar 18 2024 08:59 AM
When working with databases, high resource usage or a query reporting a timeout could indicate that the statistics of th...
2,207

Lesson Learned #479:Loading Data from Parquet to Azure SQL Database using C# and SqlBulkCopy

Jose_Manuel_Jurado on Mar 15 2024 12:13 PM
In the realm of big data and cloud computing, efficiently managing and transferring data between different platforms and...

Latest Comments

feili1234
in Resolve Elastic Query issues in Azure SQL Database on Jun 07 2024 03:43 PM
Thanks for your sharing, I would like to know does AAD or managed Identity still not be supported ? Security consideration: Azure Active Directory (AAD) principals are not supported in Elastic Query, only SQL Authentication will work. Managed Identity is in the scope of AAD principals and is also no...
0 Likes
divineinteriors65
in Getting Error 666 when creating non-clustered index- Msg 666, Level 16, State 2, Line 25 on Jun 07 2024 09:44 AM
Temporarily changing the database compatibility level to 160 during index creation is a clever workaround for maintaining system stability while optimizing performance. For modern and functional kitchen and bathroom accessories, visit Tapron Ireland.
0 Likes
divineinteriors65
in Getting Error 666 when creating non-clustered index- Msg 666, Level 16, State 2, Line 25 on Jun 07 2024 09:41 AM
Using DMVs to monitor index creation progress ensures administrators can track and address issues promptly, enhancing database performance management. If you're interested in luxurious bathroom fittings, explore our collection at Gold Bathroom UK.
0 Likes
divineinteriors65
in Getting Error 666 when creating non-clustered index- Msg 666, Level 16, State 2, Line 25 on Jun 07 2024 09:35 AM
The article provides practical solutions like switching to compatibility level 160 and making index creation online and resumable to handle large tables efficiently. For those looking to upgrade their home fixtures, check out a wide range of kitchen and bathroom taps at Tapron UK
0 Likes
Elapa_Suresh
in Lesson Learned #163: Failed to save Auditing settings for server: xxx .Principal xxx does not exist on Jun 04 2024 08:45 AM
Useful for resolving my issue. Thank you Paloma Garcia Martin
0 Likes