Remove 2016 Remove Azure Remove Database Remove Tuning
article thumbnail

Is MongoDB Open Source? Is Planet Earth Flat?

Percona

They came up with a horizontally scalable NoSQL database. Instead of relational (SQL) databases defined primarily through a hierarchy of related sets via tables and columns, their non-relational structure used a system of collections and documents. 2016: The company adds service-loaded MongoDB Professional to its mix.

article thumbnail

Common SQL Server Mishaps

SQL Performance

This article will expand on my previous article and point out how these apply to SQL Server , Azure SQL Database , and Azure SQL Managed Instance. When looking at backups, I check for recovery model and the current history of backups for each database. Azure SQL Database and Azure Managed Instance have managed backups.

Servers 49
article thumbnail

Introduction to Wait Statistics

SQL Performance

Understanding what these mean and how to investigate them is critical so you don’t succumb to what I call ‘knee-jerk performance tuning’ and waste time and effort trying to fix a problem that isn’t actually a problem. Remember, you still need to understand what the wait types mean once you’ve collected the metrics. Waits Resources.

Servers 40