Remove 2008 Remove Code Remove Servers Remove Tuning
article thumbnail

Tuning SQL Server Reporting Services

SQL Performance

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.

Tuning 67
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. For example, consider an e-commerce website that automatically sends personalized discount codes to customers who abandon their shopping carts.

DevOps 217
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

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.

article thumbnail

Improve user experience with more visibility into CDN-related HTTP errors (Part 1) 

Dynatrace

Such web resources have two things in common: Their requests never hit your data center, hence any failed requests don’t show up in your web server logs. This approach was already at its limit back in 2008 when an Akamai CDN network had only ~25,000 delivery nodes. Stay tuned for Part 2.

Tuning 186
article thumbnail

Finding Distinct Values Quickly

SQL Performance

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. ( -- Anchor.

Servers 86
article thumbnail

Analyzing "death by a thousand cuts" workloads

SQL Performance

There are multiple methods to look at poorly performing queries in SQL Server, notably Query Store, Extended Events, and dynamic management views (DMVs). Borrowing and adapting code from a previous post, Examining the Performance Impact of an Adhoc Workload , we will first create two stored procedures. Each option has pros and cons.

C++ 74
article thumbnail

Solaris to Linux Migration 2017

Brendan Gregg

It uses a Solaris Porting Layer (SPL) to provide a Solaris-kernel interface on Linux, so that unmodified ZFS code can execute. There's also a ZFS send/recv code path that should try to use the TASK_INTERRUPTIBLE flag (as suggested by a coworker), to avoid a kernel hang (can't kill -9 the process). Oracle VM Server is based on Xen.