article thumbnail

Understanding the deadlock definition in SQL Server

SQL Shack

This article explains the deadlock definition in SQL Server, and it also mentions how to capture deadlock with extended events. Deadlock Definition Deadlock occurs when two processes want […]. Deadlock is a resource contention issue that occurs between two or more than two processes.

Servers 93
article thumbnail

Is ANALYZE TABLE Safe on a Busy MySQL Database Server?

Percona

MySQL Server – Community Edition The problem applies to all versions of the upstream MySQL Community up to 8.0.23. Here is an example scenario you may end up here: mysql > select @@version,@@version_comment; + --+ + | @@version | @@version_comment | + --+ + | 5.7.43 | MySQL Community Server (GPL) | + --+ + 1 row in set (0.00

Servers 93
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

Percona Server for MongoDB 7 Is Now Available

Percona

Why choose Percona Server for MongoDB? The difference between Percona Server for MongoDB and MongoDB CE is that we strive to provide a gap-closing set of features for users who want to use MongoDB in production. Why release Percona Server for MongoDB 7 now? which was released as Percona Server for MongoDB RC 7.0.2-1.

article thumbnail

T-SQL Windowing Improvements in SQL Server 2022

SQL Performance

Microsoft recently released the first public preview of SQL Server 2022. This clause is now available in Azure SQL Database and SQL Server 2022, provided you use database compatibility level 160 or higher. For example, the following query is valid since the window name definitions aren’t cyclic: SELECT 'This is valid'.

Servers 145
article thumbnail

HammerDB v4.10 New Features: Partitioning and Advanced Statistics for SQL Server TPROC-H

HammerDB

adds performance enhancements for the SQL Server TPROC-H workload in the form of partitioning for the orders and lineitem tables as well as the option to create advanced statistics. Certain primary and foreign key definitions defined in HammerDB are no longer valid and will not be created. HammerDB v4.10 Summary HammerDB v4.10

Servers 62
article thumbnail

SQL Server Stored Procedure Recompilation Factors

SQL Shack

In this article, we will explore in detail the factors that cause SQL Server stored procedures to be recompiled. Introduction SQL Server Stored procedures are the make-ready T-SQL codes that can be executed again and again by the database users to perform data manipulation commands and data definition commands.

Servers 90
article thumbnail

Dynatrace memory analysis helps Product Architects identify unknown unknowns

Dynatrace

We recently extended the pre-shipped code-level API definitions to group logical parts of our code so they’re consistently highlighted in all code-level views. Another benefit of defining custom APIs is that the memory allocation and surviving object metrics are split by each custom API definition.

Java 214