Expert insights. Personalized for you.
My last talk for 2017 was at AWS re:Invent, on "How Netflix Tunes EC2 Instances for Performance," an updated version of my [2014] talk. Our team looks after the BaseAMI, kernel tuning, OS performance tools and profilers, and self-service tools like Vector. We're not the only people doing performance and performance tuning at Netflix either: all the development teams do performance work. MORE
The post Angular Performance Tuning: 15 Ways to Build Sophisticated Web Apps appeared first on Insights on Latest Technologies - Simform Blog. Angular is, by default, a powerful and high performing front-end framework. Yet, unexpected challenges are bound to happen when you’re building mission-critical apps, apps that are content-heavy and complex on the architectural side. MORE
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 Options. Tuning SSRS is much like any other application. DBAs must tune for overall health of the Reporting Services infrastructure as well as tuning the actual reports. General Tuning. The post Tuning SQL Server Reporting Services appeared first on SQLPerformance.com. MORE
performance jmeter performance tuning performance monitoring performance optimization performance engineering loadrunner neoload performance and monitoring tools performance tutorialThe purpose of this article is to assist performance engineers and IT organizations to estimate their current situation and successfully build and maintain their Performance Center of Excellence. MORE
How to fine-tune failure detection. The post How to fine tune failure detection appeared first on Dynatrace blog. Dynatrace news. Failure detection with services. When I work with customers, I usually get their requirements to alert on failures. This is especially true when Dynatrace replaces an older generation of monitoring software. Typically, these products rely on hand-crafted rules from error logs. MORE
A performance tuning engagement can end up taking many turns as you work through it – it all depends on what is showing up as the problem and what the data tells you. One of my favorite parts of tuning is working with indexes and, as I was thinking about this post, I was tempted to label index tuning as an "easier" task… but it really isn't. I think of index tuning as an art and a science. SQL Indexes index tuning MORE
java jvm jvm performance tuning q&a 32 bit 64 bitThere are a few distinct differences and subtle nuances between 32-bit JVM and 64-bit JVM. We thought we will try to clarify them through this question-and-answer article. Do I need to understand the difference between 32-bit JVM and 64-bit JVM? If you aren’t building a performance-critical application, you don’t have to understand the difference. MORE
performance performance testing performance and monitoring performance tuning performance engineering application scaling performance caching scalability and performanceWhen you build a great product or application, sooner or later, it will be drawing attention more and more users who will expect a flawless, perfect application as the demand grows in the time it handles more and more requests per minute. MORE
When dealing with SQL Server performance tuning waits, we may see RESOURCE_SEMAPHORE waits along with other related monitoring that indicates memory as a possible pain point for our server (such as the below image that shows memory being one of the top waits overall). MORE
In my last post , I started to outline the process I go through when tuning queries – specifically when I discover that I need to add a new index, or modify an existing one. This is where index tuning becomes an art. It's a lot friends, which is why it's ironic that I initially thought about stating that index tuning was easy. Just like query tuning, there is no perfect process. The post An approach to index tuning – Part 2 appeared first on SQLPerformance.com. MORE
This article will cover some essential techniques for SQL query tuning. Query tuning is a very wide topic to talk about, but some essential techniques never change in order to tune queries in SQL Server. Particularly, it is a difficult issue for those who are a newbie to SQL query tuning or who are thinking […]. Performance Query analysis MORE
performance mobile apps performance testing performance engineering performance testing and tuning load timePoor Mobile App Performance: A Horror Story. I can vividly remember one of the horrors I faced due to poor mobile app performance, which occurred while traveling across Europe with nothing but two friends, a backpack, and my iPhone in tow. All summer long, I relied on mobile apps for getting from one place to the next. MORE
Edge Computing Performance Tuning Cloud DNS Performance & Scalability Network Programming Edge DevOps newsRyan Landry, the senior director for TechOps at Fastly, has shared how network automation enables them to manage traffic peaks during popular live-streamed events such as the Super Bowl LIV. MORE
Performance Tuning QueryEditor’s Note: In the first of this four part series, I gave an overview of the tools and techniques of query optimization in SQL Server. In the second part, I talked about the process of displaying and interpreting query execution plans. I also showed how to generate query execution plans usin gSQL Server Management Studio, […]. MORE
In this article, we will learn some basic tips for SQL Server performance tuning. Tuning the SQL Server performance will help to access data faster so the applications data interaction performances will enhance. MORE
General DBA Performance Tuning hardwareAn important concern in optimizing the hardware platform is hardware components that restrict performance, known as bottlenecks. Quite often, the problem isn’t correcting performance bottlenecks as much as it is identifying them in the first place. Start with obtaining a performance baseline. You monitor the server over time so that you can determine Server average […]. MORE
performance development web developement heroku software engineering performance management tuning and testingYou’ve just released your new app into the wild, live in production. Success! Now what? Your job is done, right? Wrong. Now that you’ve deployed your code, it’s time to monitor it, collect data, and analyze your metrics. Without application performance monitoring in place, you can’t accurately determine how well things are going. Are people using your app? Is the app performant? MORE
Performance TuningA commonly altered setting is Maximum Degree of Parallelism (MAXDOP), which controls the maximum number of CPUs that can be used in executing a single task. For example, a large query may be broken up into different parts, with each part executing threads on separate CPUs. Such a query is known as a parallel query. […]. MORE
How do you tune the Snowflake data warehouse when there are no indexes, and few options available to tune the database itself? Snowflake was designed for simplicity, with few performance tuning options. best practices performance tuning data warehouse performance and scalability snowflake computing data warehouse performance snowflake tutorialThis article summarizes the top five best practices to maximize query performance. MORE
In this installament of the TSQL Performance Tuning series we turn our attention to Views Views Used Within Joins or Where Conditions As a generic concept, an inner join with an object which has insufficient indexing will result in index scanning or perhaps a table scan which also applies for Views Impacts: • Much CPU […]. Developer Performance Tuning Uncategorized T-SQL Tuning Views MORE
In this article series we will focus on the primary points of T-SQL performance tuning. In this first installment I will lopok at tuning temp tables, table variables and the Union command. Developer Performance Tuning T-SQL Table Variable Temp Table TSQL UNIONTemp Tables and Table Variables Most database developers are used to breaking down code into small chunks using temp tables or table variables […]. MORE
Performance TuningThere are several for creating queries that return data from multiple tables. The one you choose depends on your data retrieval requirements and the underlying structure of the database. In this three part article series, I will demonstrate how to combine data from multiple tables by using UNION, INTERSECT, and EXCEPT. You’ll perform advanced queries […]. MORE
Performance TuningSQL Server trace, the most common tool DBAs use to evaluate query performance, provides the ‘logical reads’ counter on which many DBAs rely for evaluating a query’s I/O performance. In this article, we will examine this counter’s true meaning and provide examples that prove it can sometimes be quite misleading… I am sure you have […]. MORE
Developer General DBA Performance Tuning SQL T-SQL TSQLRecently one of my developers came to and complained of slow performance on a particular query. During the investigation I noticed that the primary cause was the poor query execution plan. In this article, I will discuss the approach which I used to improve the execution plan. For demonstration purpose, I will be creating a […]. MORE
This may help tune your table level autovacuum settings appropriately. Tuning Autovacuum in PostgreSQL. How do we identify the tables that need their autovacuum settings tuned ? . In order to tune autovacuum for tables individually, you must know the number of inserts/deletes/updates on a table for an interval. In turn, this should help you with tuning your autovacuum settings for individual tables. The following are the parameters used to tune autovacuum IO. MORE
General DBA Performance Tuning index re-indexing Update StatisticsRecently we started experiencing a very strange issue in our production reporting environment where the Re-indexing and Update Statistics operation suddenly began taking more than 2 days to complete and was thus causing blockage in the database which in turn caused impairment in application performance. Reporting Server Configuration Details: SQL Server Version: SQL Server 2005 […]. MORE
Then we need to see IF implementing the tuning will work or not. It is possible to do more tuning in the case that ETL is too compromised. MySQL Performance TuningMySQL Resource Groups, introduced in MySQL 8, provide the ability to manipulate the assignment of running threads to specific resources, thereby allowing the DBA to manage application priorities. Essentially, you can assign a thread to a specific virtual CPU. MORE
performance testing jmeter performance tuning performance engineering performance analysis performance and scalability loadrunner client side performance nonfunctional requirements plugin testingFind out more about client-side performance! Client-Side Performance Testing Importance and Introduction. If you're worried about the performance of your web application, you need to test and analyze not only with what happens on the server but also with what happens in the browser. MORE
In this post, we will discuss some important kernel parameters that can affect database server performance and how these should be tuned. You can tune the difference between the two ratios depending on your disk IO load. You can tune other parameters for performance, but the improvement gains are likely to be minimal. Some applications perform better by tuning some parameters and some applications don’t. MORE
SQL Server Performance Tuning can be a difficult assignment, especially when working with a massive database where even the minor change can raise a significant impact on the existing query performance. Performance Tuning always plays a vital role in database performance as well as product performance. MORE
Databases Tuning hugepages linux postgres tuningFor this experiment I am using Postgres v11 on Linux 3.10 kernel. The goal was to see what gains can be made from using hugepages. I use the “built in” benchmark pgbench to run a simple set of queries. Since I am interested in only the gains from hugepages I chose to use the “-S” parameter to pgbench which means perform only the “select” statements. MORE
Out of the box, the default PostgreSQL configuration is not tuned for any particular workload. It is primarily the responsibility of the database administrator or developer to tune PostgreSQL according to their system’s workload. If queries perform full table scans where an index could be used or perform heavy joins or expensive aggregate operations, then the system can still perform poorly even if the database parameters are tuned. MORE
Insight for DBAs Insight for Developers MySQL Performance Tuning MySQL Query Tuning query tuningSome time ago, a customer had a performance issue with an internal process. He was comparing, finding, and reporting the rows that were different between two tables. This is simple if you use a LEFT JOIN and an IS NULL comparison over the second table in the WHERE clause, but what if the column could be null? MORE
What happens when you're out of memory? You may also like: Java Out of Memory Heap Analysis. Recently we experienced an interesting production problem. This application was running on multiple AWS EC2 instances behind Elastic Load Balancer. The application was running on a GNU/Linux OS, Java 8, Tomcat 8 application server. All of a sudden, one of the application instances became unresponsive. All other application instances were handling the traffic properly. MORE
Please join Percona’s Senior Software Engineer, Ibrar Ahmed as he presents his High-Performance PostgreSQL, Tuning and Optimization Guide on Friday, January, 4th, at 8:00 AM PDT (UTC-7) / 11:00 AM EDT (UTC-4). Out of the box, the default PostgreSQL configuration is not tuned for any workload. PostgreSQL provides a system where you can tune your database according to your workload and machine’s specifications. We will also touch on tuning some Linux kernel parameters. MORE
MySQL Performance Tuning parallel query Parallel Query ExecutionFor a very long time – since when multiple CPU cores were commonly available – I dreamed about MySQL having the ability to execute queries in parallel. This feature was lacking from MySQL, and I wrote a lots of posts on how to emulate parallel queries in MySQL using different methods: from simple parallel bash script to using Apache Spark to using ClickHouse together with MySQL. MORE
performance testing software testing automated testing mobile app testing software test automation performance engineering performance testing and tuning automated testing life cycle automated testing best practicesPerformance engineering at its finest. As the world becomes more decidedly digital, the demand for apps has skyrocketed like never before. " There's an app for that " is not just a popular saying. It is an accurate depiction of how people live their lives. MORE
MySQL Performance Tuning Character Sets MySQL Character SetsFollowing my post MySQL 8 is not always faster than MySQL 5.7, this time I decided to test very simple read-only CPU intensive workloads, when all data fits memory. In this workload there is NO IO operations, only memory and CPU operations. My Testing Setup. Environment specification. Release | Ubuntu 18.04 LTS (bionic). Kernel | 4.15.0-20-generic. Processors | physical = 2, cores = 28, virtual = 56, hyperthreading = yes. MORE
In this webinar, I will give an overview of Performance Schema, focusing on its tuning, performance, and usability. Additionally, it comes with hundreds of options which allow for greater precision tuning. Performance Schema Performance Tuning Technical WebinarsPlease join Percona’s Principal Support Engineer, Sveta Smirnova, as she presents MySQL Performance Schema in 1 hour on Thursday, March 21st, 2019, at 10:00 am PDT (UTC-7) / 1:00 pm EDT (UTC-4). Register Now. MySQL 8.0 MORE
You may also like: How to Properly Plan JVM Performance Tuning. While Performance Tuning an application both Code and Hardware running the code should be accounted for. java performance performance tuning java performance tuning java application linux performanceLearn how to make your Java applications performance perfectly. MORE
MySQL Percona Monitoring and Management Performance Tuning PMM MySQL indexing MySQL Query Performance MySQL Query TuningIn this blog post, I want to share a case we worked on a few days ago. I’ll show you how we approached the resolution of a MySQL performance issue and used Percona Monitoring and Management PMM to support troubleshooting. MORE
These pauses are sometimes called Stop-The-World pauses, and the minimization of them is the primary concern of GC tuning, as they can have a huge impact on the performance of a Java application. java tutorial performance garbage collection java performance tuning gc garbage collector heapGarbage collection is the mechanism by which the JVM reclaims memory on behalf of the application when it's no longer needed. MORE
In this article, I’m going to explain what actually happens under the hood and how to tune it up. performance hibernate 5 bytecode hibernate performance tuning dirty trackingHave you ever wondered how Hibernate keeps track of changes made to an entity, what exactly happens at a flush time, and why is Hibernate is sometimes too slow? MORE
In this article, we will continue to learn essential techniques of the SQL Server query tuning with practical examples. Query tuning is a bit complicated issue and if any database programmer wants to be successful on this topic, they can start with learning these basic methods to improve their skill. These methods can be quickly […]. Performance Query analysis MORE
Tuning Related Topics DZone
APRIL 21, 2019
These pauses are sometimes called Stop-The-World pauses, and the minimization of them is the primary concern of GC tuning, as they can have a huge impact on the performance of a Java application. java tutorial performance garbage collection java performance tuning gc garbage collector heapGarbage collection is the mechanism by which the JVM reclaims memory on behalf of the application when it's no longer needed.
SQL Shack
AUGUST 27, 2020
In this article, we will learn some basic tips for SQL Server performance tuning. Tuning the SQL Server performance will help to access data faster so the applications data interaction performances will enhance.
SQL Performance
MARCH 26, 2020
A performance tuning engagement can end up taking many turns as you work through it – it all depends on what is showing up as the problem and what the data tells you. One of my favorite parts of tuning is working with indexes and, as I was thinking about this post, I was tempted to label index tuning as an "easier" task… but it really isn't. I think of index tuning as an art and a science. SQL Indexes index tuning
DZone
DECEMBER 4, 2019
You may also like: How to Properly Plan JVM Performance Tuning. While Performance Tuning an application both Code and Hardware running the code should be accounted for. java performance performance tuning java performance tuning java application linux performanceLearn how to make your Java applications performance perfectly.
SQL Performance
APRIL 13, 2020
In my last post , I started to outline the process I go through when tuning queries – specifically when I discover that I need to add a new index, or modify an existing one. This is where index tuning becomes an art. It's a lot friends, which is why it's ironic that I initially thought about stating that index tuning was easy. Just like query tuning, there is no perfect process. The post An approach to index tuning – Part 2 appeared first on SQLPerformance.com.
SQL Shack
APRIL 14, 2020
SQL Server Performance Tuning can be a difficult assignment, especially when working with a massive database where even the minor change can raise a significant impact on the existing query performance. Performance Tuning always plays a vital role in database performance as well as product performance.
SQL Shack
APRIL 21, 2020
This article will cover some essential techniques for SQL query tuning. Query tuning is a very wide topic to talk about, but some essential techniques never change in order to tune queries in SQL Server. Particularly, it is a difficult issue for those who are a newbie to SQL query tuning or who are thinking […]. Performance Query analysis
SQL Shack
JUNE 16, 2020
When dealing with SQL Server performance tuning waits, we may see RESOURCE_SEMAPHORE waits along with other related monitoring that indicates memory as a possible pain point for our server (such as the below image that shows memory being one of the top waits overall).
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. Tuning Options. Tuning SSRS is much like any other application. DBAs must tune for overall health of the Reporting Services infrastructure as well as tuning the actual reports. General Tuning. The post Tuning SQL Server Reporting Services appeared first on SQLPerformance.com.
Dynatrace
JULY 2, 2019
How to fine-tune failure detection. The post How to fine tune failure detection appeared first on Dynatrace blog. Dynatrace news. Failure detection with services. When I work with customers, I usually get their requirements to alert on failures. This is especially true when Dynatrace replaces an older generation of monitoring software. Typically, these products rely on hand-crafted rules from error logs.
SQL Shack
MAY 8, 2020
In this article, we will continue to learn essential techniques of the SQL Server query tuning with practical examples. Query tuning is a bit complicated issue and if any database programmer wants to be successful on this topic, they can start with learning these basic methods to improve their skill. These methods can be quickly […]. Performance Query analysis
DZone
SEPTEMBER 25, 2019
What happens when you're out of memory? You may also like: Java Out of Memory Heap Analysis. Recently we experienced an interesting production problem. This application was running on multiple AWS EC2 instances behind Elastic Load Balancer. The application was running on a GNU/Linux OS, Java 8, Tomcat 8 application server. All of a sudden, one of the application instances became unresponsive. All other application instances were handling the traffic properly.
Percona
AUGUST 31, 2018
Out of the box, the default PostgreSQL configuration is not tuned for any particular workload. It is primarily the responsibility of the database administrator or developer to tune PostgreSQL according to their system’s workload. If queries perform full table scans where an index could be used or perform heavy joins or expensive aggregate operations, then the system can still perform poorly even if the database parameters are tuned.
Percona
AUGUST 29, 2018
In this post, we will discuss some important kernel parameters that can affect database server performance and how these should be tuned. You can tune the difference between the two ratios depending on your disk IO load. You can tune other parameters for performance, but the improvement gains are likely to be minimal. Some applications perform better by tuning some parameters and some applications don’t.
Percona
AUGUST 10, 2018
This may help tune your table level autovacuum settings appropriately. Tuning Autovacuum in PostgreSQL. How do we identify the tables that need their autovacuum settings tuned ? . In order to tune autovacuum for tables individually, you must know the number of inserts/deletes/updates on a table for an interval. In turn, this should help you with tuning your autovacuum settings for individual tables. The following are the parameters used to tune autovacuum IO.
SQL Server Performance
JANUARY 27, 2019
In this installament of the TSQL Performance Tuning series we turn our attention to Views Views Used Within Joins or Where Conditions As a generic concept, an inner join with an object which has insufficient indexing will result in index scanning or perhaps a table scan which also applies for Views Impacts: • Much CPU […]. Developer Performance Tuning Uncategorized T-SQL Tuning Views
Percona
AUGUST 27, 2018
Then we need to see IF implementing the tuning will work or not. It is possible to do more tuning in the case that ETL is too compromised. MySQL Performance TuningMySQL Resource Groups, introduced in MySQL 8, provide the ability to manipulate the assignment of running threads to specific resources, thereby allowing the DBA to manage application priorities. Essentially, you can assign a thread to a specific virtual CPU.
Simform
APRIL 21, 2020
The post Angular Performance Tuning: 15 Ways to Build Sophisticated Web Apps appeared first on Insights on Latest Technologies - Simform Blog. Angular is, by default, a powerful and high performing front-end framework. Yet, unexpected challenges are bound to happen when you’re building mission-critical apps, apps that are content-heavy and complex on the architectural side.
SQL Server Performance
SEPTEMBER 16, 2018
Developer General DBA Performance Tuning SQL T-SQL TSQLRecently one of my developers came to and complained of slow performance on a particular query. During the investigation I noticed that the primary cause was the poor query execution plan. In this article, I will discuss the approach which I used to improve the execution plan. For demonstration purpose, I will be creating a […].
Percona
JANUARY 3, 2019
Please join Percona’s Senior Software Engineer, Ibrar Ahmed as he presents his High-Performance PostgreSQL, Tuning and Optimization Guide on Friday, January, 4th, at 8:00 AM PDT (UTC-7) / 11:00 AM EDT (UTC-4). Out of the box, the default PostgreSQL configuration is not tuned for any workload. PostgreSQL provides a system where you can tune your database according to your workload and machine’s specifications. We will also touch on tuning some Linux kernel parameters.
SQL Server Performance
JANUARY 3, 2019
In this article series we will focus on the primary points of T-SQL performance tuning. In this first installment I will lopok at tuning temp tables, table variables and the Union command. Developer Performance Tuning T-SQL Table Variable Temp Table TSQL UNIONTemp Tables and Table Variables Most database developers are used to breaking down code into small chunks using temp tables or table variables […].
SQL Server Performance
NOVEMBER 10, 2017
General DBA Performance Tuning index re-indexing Update StatisticsRecently we started experiencing a very strange issue in our production reporting environment where the Re-indexing and Update Statistics operation suddenly began taking more than 2 days to complete and was thus causing blockage in the database which in turn caused impairment in application performance. Reporting Server Configuration Details: SQL Server Version: SQL Server 2005 […].
Brendan Gregg
DECEMBER 31, 2017
My last talk for 2017 was at AWS re:Invent, on "How Netflix Tunes EC2 Instances for Performance," an updated version of my [2014] talk. Our team looks after the BaseAMI, kernel tuning, OS performance tools and profilers, and self-service tools like Vector. We're not the only people doing performance and performance tuning at Netflix either: all the development teams do performance work.
DZone
MAY 15, 2020
performance development web developement heroku software engineering performance management tuning and testingYou’ve just released your new app into the wild, live in production. Success! Now what? Your job is done, right? Wrong. Now that you’ve deployed your code, it’s time to monitor it, collect data, and analyze your metrics. Without application performance monitoring in place, you can’t accurately determine how well things are going. Are people using your app? Is the app performant?
DZone
JUNE 22, 2020
performance mobile apps performance testing performance engineering performance testing and tuning load timePoor Mobile App Performance: A Horror Story. I can vividly remember one of the horrors I faced due to poor mobile app performance, which occurred while traveling across Europe with nothing but two friends, a backpack, and my iPhone in tow. All summer long, I relied on mobile apps for getting from one place to the next.
DZone
MAY 21, 2019
In this article, I’m going to explain what actually happens under the hood and how to tune it up. performance hibernate 5 bytecode hibernate performance tuning dirty trackingHave you ever wondered how Hibernate keeps track of changes made to an entity, what exactly happens at a flush time, and why is Hibernate is sometimes too slow?
DZone
JUNE 4, 2020
performance jmeter performance tuning performance monitoring performance optimization performance engineering loadrunner neoload performance and monitoring tools performance tutorialThe purpose of this article is to assist performance engineers and IT organizations to estimate their current situation and successfully build and maintain their Performance Center of Excellence.
Percona
MARCH 7, 2019
MySQL Percona Monitoring and Management Performance Tuning PMM MySQL indexing MySQL Query Performance MySQL Query TuningIn this blog post, I want to share a case we worked on a few days ago. I’ll show you how we approached the resolution of a MySQL performance issue and used Percona Monitoring and Management PMM to support troubleshooting.
DZone
AUGUST 16, 2019
performance performance testing performance and monitoring performance tuning performance engineering application scaling performance caching scalability and performanceWhen you build a great product or application, sooner or later, it will be drawing attention more and more users who will expect a flawless, perfect application as the demand grows in the time it handles more and more requests per minute.
DZone
JULY 22, 2019
java jvm jvm performance tuning q&a 32 bit 64 bitThere are a few distinct differences and subtle nuances between 32-bit JVM and 64-bit JVM. We thought we will try to clarify them through this question-and-answer article. Do I need to understand the difference between 32-bit JVM and 64-bit JVM? If you aren’t building a performance-critical application, you don’t have to understand the difference.
DZone
SEPTEMBER 17, 2019
performance testing software testing automated testing mobile app testing software test automation performance engineering performance testing and tuning automated testing life cycle automated testing best practicesPerformance engineering at its finest. As the world becomes more decidedly digital, the demand for apps has skyrocketed like never before. " There's an app for that " is not just a popular saying. It is an accurate depiction of how people live their lives.
DZone
JANUARY 14, 2020
performance testing jmeter performance tuning performance engineering performance analysis performance and scalability loadrunner client side performance nonfunctional requirements plugin testingFind out more about client-side performance! Client-Side Performance Testing Importance and Introduction. If you're worried about the performance of your web application, you need to test and analyze not only with what happens on the server but also with what happens in the browser.
n0derunner
MARCH 7, 2019
Databases Tuning hugepages linux postgres tuningFor this experiment I am using Postgres v11 on Linux 3.10 kernel. The goal was to see what gains can be made from using hugepages. I use the “built in” benchmark pgbench to run a simple set of queries. Since I am interested in only the gains from hugepages I chose to use the “-S” parameter to pgbench which means perform only the “select” statements.
Percona
OCTOBER 3, 2018
Insight for DBAs Insight for Developers MySQL Performance Tuning MySQL Query Tuning query tuningSome time ago, a customer had a performance issue with an internal process. He was comparing, finding, and reporting the rows that were different between two tables. This is simple if you use a LEFT JOIN and an IS NULL comparison over the second table in the WHERE clause, but what if the column could be null?
InfoQ
MARCH 24, 2020
Edge Computing Performance Tuning Cloud DNS Performance & Scalability Network Programming Edge DevOps newsRyan Landry, the senior director for TechOps at Fastly, has shared how network automation enables them to manage traffic peaks during popular live-streamed events such as the Super Bowl LIV.
Percona
FEBRUARY 27, 2019
MySQL Performance Tuning Character Sets MySQL Character SetsFollowing my post MySQL 8 is not always faster than MySQL 5.7, this time I decided to test very simple read-only CPU intensive workloads, when all data fits memory. In this workload there is NO IO operations, only memory and CPU operations. My Testing Setup. Environment specification. Release | Ubuntu 18.04 LTS (bionic). Kernel | 4.15.0-20-generic. Processors | physical = 2, cores = 28, virtual = 56, hyperthreading = yes.
SQL Server Performance
MARCH 19, 2019
Performance Tuning QueryEditor’s Note: In the first of this four part series, I gave an overview of the tools and techniques of query optimization in SQL Server. In the second part, I talked about the process of displaying and interpreting query execution plans. I also showed how to generate query execution plans usin gSQL Server Management Studio, […].
SQL Server Performance
MARCH 12, 2019
General DBA Performance Tuning hardwareAn important concern in optimizing the hardware platform is hardware components that restrict performance, known as bottlenecks. Quite often, the problem isn’t correcting performance bottlenecks as much as it is identifying them in the first place. Start with obtaining a performance baseline. You monitor the server over time so that you can determine Server average […].
Percona
MARCH 19, 2019
In this webinar, I will give an overview of Performance Schema, focusing on its tuning, performance, and usability. Additionally, it comes with hundreds of options which allow for greater precision tuning. Performance Schema Performance Tuning Technical WebinarsPlease join Percona’s Principal Support Engineer, Sveta Smirnova, as she presents MySQL Performance Schema in 1 hour on Thursday, March 21st, 2019, at 10:00 am PDT (UTC-7) / 1:00 pm EDT (UTC-4). Register Now. MySQL 8.0
SQL Server Performance
MARCH 4, 2019
Performance TuningA commonly altered setting is Maximum Degree of Parallelism (MAXDOP), which controls the maximum number of CPUs that can be used in executing a single task. For example, a large query may be broken up into different parts, with each part executing threads on separate CPUs. Such a query is known as a parallel query. […].
Percona
JANUARY 23, 2019
MySQL Performance Tuning parallel query Parallel Query ExecutionFor a very long time – since when multiple CPU cores were commonly available – I dreamed about MySQL having the ability to execute queries in parallel. This feature was lacking from MySQL, and I wrote a lots of posts on how to emulate parallel queries in MySQL using different methods: from simple parallel bash script to using Apache Spark to using ClickHouse together with MySQL.
SQL Server Performance
DECEMBER 18, 2018
Performance TuningThere are several for creating queries that return data from multiple tables. The one you choose depends on your data retrieval requirements and the underlying structure of the database. In this three part article series, I will demonstrate how to combine data from multiple tables by using UNION, INTERSECT, and EXCEPT. You’ll perform advanced queries […].
SQL Server Performance
OCTOBER 19, 2018
Performance TuningSQL Server trace, the most common tool DBAs use to evaluate query performance, provides the ‘logical reads’ counter on which many DBAs rely for evaluating a query’s I/O performance. In this article, we will examine this counter’s true meaning and provide examples that prove it can sometimes be quite misleading… I am sure you have […].
48 
Let's personalize your content