Remove 2008 Remove Availability 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

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. Step 1: Quantify the errors.

Tuning 185
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

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. Since there were no existing solutions available, we needed to build them ourselves. It’s been a great experience working with you all on this.

Traffic 220
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.

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). DMV data is always available, so very often it's the easiest method to get a quick first look at query performance. Each option has pros and cons. CROSS APPLY sys. CROSS APPLY sys.

C++ 74
article thumbnail

Solaris to Linux Migration 2017

Brendan Gregg

What follows are topics that may be of interest to anyone looking to migrate their systems and skillset: scan these to find topics that interest you. ## ZFS ZFS is available for Linux via the [zfsonlinux] and [OpenZFS] projects, and more recently was included in Canonical's Ubuntu Linux distribution: Ubuntu Xenial 16.04 LTS (April 2016).

article thumbnail

Should You Use ClickHouse as a Main Operational Database?

Percona

With the latest ClickHouse version, all of these features are available, but some of them may not perform fast enough. Updating a single message in the past (e.g. in the case of messages, we may need to update the final price; in the case of comments, we may need to upvote or downvote a comment). Deleting messages. Text search.