Remove 2008 Remove Code Remove Processing Remove Testing
article thumbnail

Zombie Processes are Eating your Memory

Randon ASCII

Zombies probably won’t consume 32 GB of your memory like they did to me, but zombie processes do exist, and I can help you find them and make sure that developers fix them. He’d even written a tool that would dump a list of zombie processes – their names and counts. I ran his tool and it showed 506,000 zombie processes!

article thumbnail

The Lock Escalation Threshold – Part 1

SQL Performance

Testing environment. I happen to be using SQL Server 2019 CU16 but the details I’ll describe haven’t materially changed since partition level lock escalation was added to SQL Server 2008. DECRYPTION BY CERTIFICATE Banana ; Start : -- Recreate the test table. BEGIN TRANSACTION ; -- Test statement(s). Test 1 with 6213 rows.

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

If there was ever a good time to be sure you have good governance, this is it

The Agile Manager

It's target state one month after launch was to have 5 locations running the new software in parallel with legacy, processing 0.15% of corporate transactions, with another 5 locations ready for go-live the following month. We're all ok here" has been the modus operandi for IT governance for the past two decades.

article thumbnail

Finding Distinct Values Quickly

SQL Performance

Test Environment. It comes set to SQL Server 2008 compatibility (level 100), but we will start with a more modern setting of SQL Server 2017 (level 140): ALTER DATABASE StackOverflow2013 SET COMPATIBILITY_LEVEL = 140 ; The tests were performed on my laptop using SQL Server 2019 CU 2. Row Store Clustered Index. ( -- Anchor.

Servers 86
article thumbnail

Why & How to Contribute to Open Source Projects?

Testsigma

The simplest of them is that open-source projects are those whose source code is available to read and reuse in other projects. You can just navigate to their repository, open the files, analyze the code, change according to yourself and reuse it as per your requirement. . A small list of some of the famous open-source technologies.

article thumbnail

SQL 2016 – It Just Runs Faster Announcement

SQL Server According to Bob

The SQL Server Development team tasked several individuals with scalability improvements and real world testing patterns. “SQL Server 2016 running on the same hardware as SQL Server 2014, 2012, 2008, 2008 R2 or 2005 uses fewer resources and executes a wide range of workloads faster. – [link]. Auto-soft NUMA.

article thumbnail

MariaDB vs MySQL: Key Differences and Use Cases

Percona

Introduction: MariaDB vs. MySQL The goal of this blog post is to evaluate, at a higher level, MariaDB vs. MySQL vs. Percona Server for MySQL side-by-side to better inform the decision making process. Efficient data processing and indexing, making it optimal for executing queries and handling large datasets. What is MariaDB?