2008 Servers Systems Tuning 
SQL Performance
SEPTEMBER 17, 2019
Many database administrators find themselves having to support instances of SQL Server Reporting Services (SSRS), or at least the backend databases that are required for SSRS. This article will cover many areas that database administrators need to be aware of in order to properly license, recover, and tune a Reporting Services installation.
Percona
APRIL 14, 2023
During the recession of 2008, they experienced firsthand how fast money and assets can vanish. Here are a few ways you can scale down and save: Audit your systems: Auditing your system for unused servers and eliminating those servers can reduce your cloud spend. If needed, you can spin up a backup.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
SQL Performance
MARCH 17, 2020
Back in 2014, I wrote an article called Performance Tuning the Whole Query Plan. This follow-up post revisits the question for SQL Server 2019, using a larger number of rows. It has 32GB RAM, with 24GB available to the SQL Server 2019 instance. Test Environment. The cost threshold for parallelism is set to 50.
SQL Performance
OCTOBER 29, 2019
There are multiple methods to look at poorly performing queries in SQL Server, notably Query Store, Extended Events, and dynamic management views (DMVs). ORDER BY ExecutionCount DESC ; Note: The sys.dm_exec_function_stats DMV was added in SQL Server 2016. Each option has pros and cons. query_hash AS [ query_hash ] , qs.
Dynatrace
JULY 24, 2023
The evolution of DevOps automation Since the concept of DevOps emerged around 2007 and 2008 in response to pain points with Agile development, DevOps automation has been continuously evolving. Consider an event-driven automation system designed for incident management. But it doesn’t stop there.
SQL Performance
JUNE 21, 2019
I've been teaching and writing about common SQL Server mistakes for many years. 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. SQL Server Agent alerts. I always check backups first when looking at a new system. Statistics.
The Netflix TechBlog
AUGUST 29, 2023
A brief history of IPC at Netflix Netflix was early to the cloud, particularly for large-scale companies: we began the migration in 2008, and by 2010, Netflix streaming was fully run on AWS. To improve availability, we designed systems where components could fail separately and avoid single points of failure.
Expert insights. Personalized for you.
67 
Let's personalize your content