article thumbnail

The Speed of Time

Brendan Gregg

These strange questions came to the fore back in 2014 when Netflix was switching services from CentOS Linux to Ubuntu, and I helped debug several weird performance issues including one I'll describe here. A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. How would you _time_ time?

Speed 126
article thumbnail

The DBCC_OBJECT_METADATA Latch

SQL Performance

You might wonder why I’m writing about an issue that affects older versions, but there are still a huge number of SQL Server 2014 and older instances out there, so it's a valid topic for my series. I strongly recommend you read the initial post in the series before this one, so you have all the general background knowledge about latches.

C++ 54
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

Using JSONB in PostgreSQL: How to Effectively Store & Index JSON Data in PostgreSQL

Scalegrid

Why should a relational database even care about unstructured data? JSON database in 9.2 It is useful to validate incoming JSON and store in the database. 2014) added support for JSONB data type. B-tree indexes are the most common index type in relational databases. JSONB Patterns & Antipatterns. JSONB Indexes.

Storage 321
article thumbnail

Refreshing SQL Server Tables With Less Interruption Using Partition Switching

SQL Performance

Joe Sack went into detail about this enhancement added back in SQL Server 2014: “ Exploring Low Priority Lock Wait Options in SQL Server 2014 CTP1.”. First, we’ll create two new databases: CREATE DATABASE NewWay ; CREATE DATABASE OldWay ; GO. SQL Server Partition Switching Example. Vegetables_OldWay ; END.

Servers 55
article thumbnail

Minimal Logging with INSERT…SELECT into Heap Tables

SQL Performance

The following demo script should be run on a development instance in a new test database set to use the SIMPLE recovery model. For SQL Server 2014 and later , the transition point is 950 rows for this table. The thresholds are not dependent on the Cardinality Estimation model in use or the database compatibility level.

Servers 47
article thumbnail

Finding Distinct Values Quickly

SQL Performance

Back in 2014, I wrote an article called Performance Tuning the Whole Query Plan. Test Environment. Test Environment. I will be using the 50GB Stack Overflow 2013 database , but any large table with a low number of distinct values would do. The Votes table has just under 53 million rows (52,928,720 to be exact).

Servers 86
article thumbnail

AWS EC2 Virtualization 2017: Introducing Nitro

Brendan Gregg

It's all a bit confusing, and I wrote about this in 2014: [Xen Modes]. When I joined Netflix in 2014, we had begun transitioning from PV to HVM (PVHVM). But not all workloads: some are network bound (proxies) and storage bound (databases). ## 5. This recommendation quickly became out of date. The first was c3. Impressive!