SQL Performance

JULY 3, 2019

A recent consulting engagement was focused on blocking issues inside of SQL Server that were causing delays in processing user requests from the application. Depending on which DMV you look at for SQL Server, a session can have a few different statuses. So, we had to dig in further. Understanding Session Status.

Servers 64

Servers Hardware Code Virtualization 64

SQL Server According to Bob

MAY 20, 2018

I have been asked several times about how to get a Performance Monitor like view on Linux. There are lots of Linux tools available (top, iotop, Grafana, and SQL Sentry just scratch the surface of available options) to monitor the Linux system. Allow me to share one such example to capture and monitor a system.

Monitoring 40

Monitoring Servers Performance C++ 40

SQL Performance

JANUARY 23, 2020

"Waitstats helps us identify performance-related counters. But waits information by itself isn't enough to accurately diagnose performance problems. The queues component of our methodology comes from Performance Monitor counters, which provide a view of system performance from a resource standpoint.".

Tuning 115

Tuning Servers Monitoring Hardware 115

Dynatrace

JULY 7, 2022

It’s easy to see why, with benefits such as better testing, easier deployment, faster performance, and more. While microservices vs. monolithic architecture is a common debate, organizations have other considerations, like service-oriented architecture (SOA), tools, monitoring solutions, and potential migration issues.

Architecture 199

Architecture Serverless Azure Programming 199

The Netflix TechBlog

APRIL 29, 2019

Content is placed on the network of servers in the Open Connect CDN as close to the end user as possible, improving the streaming experience for our customers and reducing costs for both Netflix and our Internet Service Provider (ISP) partners. We are proud to say that our team’s tools are built primarily in Python.

Open Source 279

Open Source Network Infrastructure Big Data 279

HammerDB

DECEMBER 9, 2020

This means that the performance metrics reported in NOPM/TPM could be different from previous releases as well as the ratio between NOPM and TPM for these workloads. Another key feature introduced with HammerDB v4.0 is the refactoring of the stored procedures for some of the TPROC-C workloads. Therefore results from v4.0 NOPM vs TPM.

C++ 52

C++ Benchmarking Metrics Database 52

Percona

SEPTEMBER 1, 2023

MySQL server performance can sometimes be perplexing, and if you’ve ever wondered about the role of triggers in influencing your MySQL server’s memory allocation, this post is for you. This code can include SQL statements, procedures, or other actions defined within the trigger. What is a Trigger in MySQL?

Cache 59

Cache Database Games Healthcare 59

Percona

MAY 15, 2023

Nothing is impossible; however, the performances will be so impacted that each operation may take seconds instead of milliseconds or a fraction of it unless lifting some of the rules breaks the relational model. In the MySQL open source ecosystem, we have only two consolidated ways to perform sharding — Vitess and ProxySQL.

Traffic 121

Traffic Scalability Database Servers 121

HammerDB

JULY 5, 2022

This post addresses both questions to illustrate exactly why HammerDB is written in Tcl and why using Python to benchmark a database can result in poor performance and misleading results. We use stored procedures because, as the introductory post shows, using single SQL statements turns our database benchmark into a network test).

Benchmarking 98

Benchmarking Database C++ Virtualization 98

SQL Server According to Bob

JANUARY 11, 2020

Copyright The information ​​ that is contained ​​ in this document represents the current view of Microsoft Corporation on the issues discussed as of the date of publication. This White Paper is for informational purposes only. Complying with all applicable copyright laws is the responsibility of the user.

Servers 40

Servers Cache Database Media 40

HammerDB

NOVEMBER 30, 2018

This article Threads Done Right… With Tcl gives an excellent overview of these capabilities and it should be clear that to build a scalable benchmarking tool this thread performance and scalability is key. Programming Languages. TCL is a dynamic or interpreted language where the code is compiled into bytecode at runtime.

Architecture 40

Architecture Virtualization Open Source C++ 40

The Symphonia

DECEMBER 6, 2017

Correspondingly, 3GB functions should see a 2x CPU performance improvement over 1.5GB Lambdas, but this is through doubling the number of cores the function has access to, rather than double the virtualized time-slices. Tooling has been updated to support this new feature too (see below.)

Serverless 40

Serverless Lambda AWS Traffic 40

Dynatrace

APRIL 16, 2019

Many of our customers also run their.NET, ASP.NET,NET Core, SQL Server, CRM, SharePoint … applications on AWS and have reached out to us in the past to ask about best practices around optimizing these workloads in order to run more efficiently and more cost effective. Dynatrace automatically pulls AWS tags for all monitored resources.

AWS 125

AWS Best Practices Database Traffic 125