article thumbnail

How It Works: SQL Server Lock Partitioning

SQL Server According to Bob

A handful of lock types (Database, Metadata, LOGIN_STATS, …) are eligible for lock partitioning. For example: When ‘use database’ takes place the session acquires a shared lock on database. Only distinct changes require an exclusive database lock, for example a drop database.

Servers 103
article thumbnail

Designing Instagram

High Scalability

When the server receives a request for an action (post, like etc.) FUN FACT : In this talk , Rodrigo Schmidt, director of engineering at Instagram talks about the different challenges they have faced in scaling the data infrastructure at Instagram. We will use a graph database such as Neo4j to store the information. API Design.

Design 334
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

New Metadata-Only Column Changes in SQL Server 2016

SQL Performance

When we ask SQL Server to change some aspect of a column's definition, it needs to check that the existing data is compatible with the new definition. Depending on the type of change and the configuration of the database, an ALTER COLUMN command will need to perform one of the following actions: Change metadata in system tables only.

Servers 63
article thumbnail

SQL Server Linux: fsync and Buffered I/O

SQL Server According to Bob

I was asked to validate the SQL Server behavior in light of the error condition involving fsync/fdatasync outlined in this article. Assume the database application opens the backup file, allowing file system caching (~_O_DIRECT.) SQL Server does NOT do this, in fact I made sure SQL Server on Linux does not allow this to occur.

Servers 40
article thumbnail

SQL Server on Linux: Why Do I Have Two SQL Server Processes

SQL Server According to Bob

When starting SQL Server on Linux why are there two (2) sqlservr processes? systemctl status mssql-server mssql-server.service – Microsoft SQL Server Database Engine … CGroup: /system.slice/mssql-server.service ??85829 Bob Dorr – Principle SQL Server Software Engineer.

Servers 40
article thumbnail

Sponsored Post: Close, Wynter, Pinecone, Kinsta, Bridgecrew, IP2Location, StackHawk, InterviewCamp.io, Educative, Stream, Fauna, Triplebyte

High Scalability

Close is building the sales communication platform of the future and we're looking for a Site Reliability Engineer to help us accomplish that goal. T riplebyte lets exceptional software engineers skip screening steps at hundreds of top tech companies like Apple, Dropbox, Mixpanel, and Instacart. Apply here. Get started for free!

Education 100
article thumbnail

Sponsored Post: G-Core Labs, Close, Wynter, Pinecone, Kinsta, Bridgecrew, IP2Location, StackHawk, InterviewCamp.io, Educative, Stream, Fauna, Triplebyte

High Scalability

Close is building the sales communication platform of the future and we're looking for a Site Reliability Engineer to help us accomplish that goal. T riplebyte lets exceptional software engineers skip screening steps at hundreds of top tech companies like Apple, Dropbox, Mixpanel, and Instacart. Try out their platform.

Education 100