SQL Performance

SEPTEMBER 17, 2019

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. SSRS 2008 brought that component into the reporting service module. Unlike the system database tempdb, ReportServerTempDB is not recreated at startup.

Tuning 67

Tuning Servers Database Best Practices 67

Percona

APRIL 14, 2023

During the recession of 2008, they experienced firsthand how fast money and assets can vanish. Below, we outline some proactive steps for achieving cost efficiency and maintaining performant database environments amid a turbulent economy: 1. Here we are, with an economic downturn looming globally and some countries facing a recession.

Database 81

Database Serverless Tuning Cloud 81

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. For instance, in the case of poor performance, you can seamlessly toggle a feature flag and mitigate any detrimental effects.

DevOps 216

DevOps Traffic Efficiency Servers 216

Smashing Magazine

JUNE 3, 2022

Measuring The Performance Of Typefaces For Users (Part 1). Measuring The Performance Of Typefaces For Users (Part 1). How well does a typeface work and perform against another similar typeface? Fast forward to the early 1960s, phototypesetting systems appeared. Reasons To Measure The Performance Of Typefaces?

Performance 111

Performance Design Best Practices Testing 111

SQL Performance

MARCH 17, 2020

Back in 2014, I wrote an article called Performance Tuning the Whole Query Plan. The optimizer chooses this plan without any hints on my system configuration because the estimated cost of the plan is below the cost threshold for parallelism. Performance is competitive at around 15ms. Test Environment. BountyAmount.

Servers 86

Servers Tuning Database Efficiency 86

SQL Performance

JUNE 21, 2019

I always check backups first when looking at a new system. What I find is very similar to backups: No DBCC CHECKDBs performed at all DBCC CHECKDBs being performed only on select databases DBCC CHECKDBs last performed months or years ago. Memory settings. Statistics. Index maintenance. SQL Server Agent alerts.

Servers 49

Servers Azure Hardware Database 49

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). Extended Events provides data about the individual execution of queries, while Query Store and the DMVs aggregate performance data. Each option has pros and cons. Example Scenario.

C++ 74

C++ Database Servers Tuning 74