article thumbnail

Tuning SQL Server Reporting Services

SQL Performance

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
article thumbnail

How To Reduce the Costs of Database Management in Financial Services

Percona

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.

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

Finding Distinct Values Quickly

SQL Performance

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. Cost" column shows the optimizer's cost estimate for each query as reported on the test system.

Servers 86
article thumbnail

Analyzing "death by a thousand cuts" workloads

SQL Performance

ORDER BY [ Short Query Text ] ; The query_hash was added in SQL Server 2008, and is based on the tree of the logical operators generated by the Query Optimizer for the statement text. In some scenarios, parameterizing five to 10 ad hoc queries can improve system performance as a whole. query_hash AS [ query_hash ] , qs.

C++ 74
article thumbnail

Measuring The Performance Of Typefaces For Users (Part 1)

Smashing Magazine

These compiled systems for letters and symbols, which are representations of sounds and information, get a lot of use and are a large part of graphic communication. Fast forward to the early 1960s, phototypesetting systems appeared. Instead, we need to address multiple factors within the design system. Stay tuned!

article thumbnail

DevOps automation: From event-driven automation to answer-driven automation [with causal AI]

Dynatrace

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.

DevOps 220
article thumbnail

Zero Configuration Service Mesh with On-Demand Cluster Discovery

The Netflix TechBlog

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.

Traffic 220