SQL Shack

AUGUST 13, 2020

This article continues from the series on SQL Server Always On Availability Group. This is the 11th article in this series.

Availability 98

Availability Servers 98

SQL Server According to Bob

SEPTEMBER 26, 2016

When we released Always On Availability Groups in SQL Server 2012 as a new and powerful way to achieve high availability, hardware environments included NUMA machines with low-end multi-core processors and SATA and SAN drives for storage (some SSDs). As we moved towards SQL Server 2014, the pace of hardware accelerated.

Availability 40

Availability Servers Hardware Benchmarking 40

Dynatrace

MARCH 24, 2023

This orchestration includes provisioning, scheduling, networking, ensuring availability, and monitoring container lifecycles. Part of its popularity owes to its availability as a managed service through the major cloud providers, such as Amazon Elastic Kubernetes Service , Google Kubernetes Engine , and Microsoft Azure Kubernetes Service.

Infrastructure 182

Infrastructure Open Source Operating System Cloud 182

SQL Performance

JULY 24, 2022

SQL Server 2012 went out of all forms of official support about two weeks ago, on July 12 th. Best approaches for running totals – updated for SQL Server 2012. In the very first post on this site, I compared the performance of long-standing running totals methods with the new windowing functions added in SQL Server 2012.

Servers 66

Servers Strategy Availability Processing 66

SQL Performance

NOVEMBER 1, 2019

As I embark on my first PASS Summit in a few years, it is hard to contain my excitement about the newest version of SQL Server. The product is not released yet, at least at the time of writing, but they have started to shape which features (and there are a lot of them ) will be available in which editions.

Servers 40

Servers Hardware Database Availability 40

SQL Server According to Bob

DECEMBER 26, 2017

Bob Ward and I worked with our SQL Server Tool developers (thanks David) to enable ‘Q uick XE Trace ’ capabilities. The feature is available in the latest SQL Server Management Studio (SSMS) release. Here is an example using the SQL Server SSMS 2017 against my SQL 2016 server.

Servers 40

Servers Software Engineering Engineering Availability 40

CSS Wizardry

MARCH 3, 2019

This includes CDNs, proxy servers, and the like. Once the 60 seconds is up, the browser will head back to the server to revalidate the file. It means ‘do no t serve a copy from cache until you’ve revalidated it with the server and the server said you can use the cached copy’. public and private. Cache-Control: no-cache.

Cache 264

Cache Latency Strategy Servers 264

SQL Performance

JUNE 5, 2019

One of the more perplexing problems to troubleshoot in SQL Server can be those related to memory grants. SQL Server’s optimizer estimates how much memory is needed, and the query must obtain the memory grant in order to start executing. EXEC [ Sales ] [ usp_OrderInfo_OrderDate ] '2016-01-01' , '2016-06-30' ; GO.

Servers 41

Servers Cache Database Metrics 41

Scalegrid

JANUARY 19, 2024

Recovering from a MongoDB rollback involves locating rollback files, using mongorestore to load data into a separate server, cleansing unneeded data, and importing the data back into the primary cluster, coupled with ongoing monitoring and maintenance of replica sets to maintain system health.

Database 130

Database Network Servers Monitoring 130

Dynatrace

JUNE 7, 2019

We continue to grow our public synthetic monitoring locations, but customers using Dynatrace Synthetic still need to monitor the performance and availability of internal web applications. With private synthetic browser monitors, we bring the testing capabilities available in public locations right into your own environment.

Network 154

Network Monitoring Servers Hardware 154

Dynatrace

AUGUST 10, 2019

Having the ability to monitor the performance and availability of your organization’s internal applications—in addition to your organization’s customer-facing applications—from within your corporate network is an important benefit of synthetic monitoring. Windows 2016 Server (or a supported Linux distribution ).

Monitoring 103

Monitoring Hardware Tuning Mobile 103

SQL Server According to Bob

JULY 13, 2016

20+ years ago when I joined Microsoft I was handed a diskette (maybe it was two), and was told “Here is SQL Server. So I proceeded to install SQL Server 4.20 There was a GUI as part of setup but within just a few clicks, SQL Server was installed and ready for use. So now there are more choices to make when installing SQL Server.

Servers 40

Servers Media Engineering Virtualization 40

Percona

APRIL 12, 2023

Let’s start with this: MongoDB is accurately referred to as source-available software. In 2010, having seemingly gone all-in with the tenets of open source development , the company brought MongoDB to the market as an open source database server. 2016: The company adds service-loaded MongoDB Professional to its mix.

Open Source 85

Open Source Programming Database Servers 85

SQL Server According to Bob

DECEMBER 18, 2018

SQL Server relies on Forced-Unit-Access (Fua) I/O subsystem capabilities to provide data durability, detailed in the following documents: SQL Server 2000 I/O Basic and SQL Server I/O Basics, Chapter 2. Be sure to deploy SQL Server 2017 CU6 or newer for best data durability and performance results. “. The Back Story.

Servers 90

Servers Media Cache Storage 90

SQL Server According to Bob

NOVEMBER 8, 2016

SQL Server 2016 Service Pack 1 (all SKUs) , in combination with Windows Server 2016 (All SKUs) or Windows 10 Client introduces non-volatile memory support for the tail of the log file (LDF) which can significantly increase transaction throughput. As the following diagram shows the SQL Server Log Cache is in memory.

Cache 40

Cache Servers Media Storage 40

SQL Server According to Bob

JANUARY 26, 2017

My goal is to resolve mysteries about SQL Server I encounter but do this without going straight the source code first. The first case that helped me start this journey was asked by a MVP within the SQL Server community (his first name starts with Joey<g>). The question went something like this….

Servers 40

Servers Database Azure Cache 40

Percona

JANUARY 24, 2023

Some of the built-in features ( wal_compression ) have been there since 2016, and almost all backup tools do the WAL compression before taking it to the backup repository. They do a much better job than what was available in PostgreSQL (pglz). So it has never been part of the general advice for optimizations.

Database 120

Database Benchmarking Open Source Latency 120

Dynatrace

OCTOBER 28, 2021

The crisis could be technical, natural, or malicious events, for example an earthquake affecting data center availability, or a cyberattack infecting applications and websites. Chaos engineering matured at organizations such as Netflix, and gave rise to technologies such as Gremlin (2016) , becoming more targeted and knowledge-based.

Engineering 221

Engineering Entertainment Cloud Infrastructure 221

Percona

JUNE 4, 2023

In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL ). Introduction: MariaDB vs. MySQL The goal of this blog post is to evaluate, at a higher level, MariaDB vs. MySQL vs. Percona Server for MySQL side-by-side to better inform the decision making process.

Open Source 52

Open Source Servers Storage Scalability 52

SQL Server According to Bob

JULY 12, 2016

Trace flags 2562 and 2549 are documented in knowledgebase article: [link] and the blog post [link] highlights the SQL 2016 DBCC performance improvements. For SQL Server 2008, 2012 and 2014 the trace flag behavior remains the same. For SQL Server 2016 the trace flags are available but the behavior may be altered by the design changes.

Servers 40

Servers Design Engineering Database 40

SQL Server According to Bob

APRIL 25, 2017

I recently visited a customer onsite and presented to them topics on SQL Server 2016. One question I got went like this “I’ve tried to restore a database on SQL Server using the WITH STATS option. Next, I decided to use the WideWorldImporters sample database available on github to test out the RESTORE.

Servers 40

Servers Database Processing Virtualization 40

SQL Server According to Bob

APRIL 21, 2017

I recently visited a customer onsite and presented to them topics on SQL Server 2016. One question I got went like this “I’ve tried to restore a database on SQL Server using the WITH STATS option. Next, I decided to use the WideWorldImporters sample database available on github to test out the RESTORE.

Servers 40

Servers Database Processing Virtualization 40

SQL Performance

JULY 1, 2019

The results are technically non-deterministic since SQL Server could validly return any one of the rows in each group. Nevertheless, if you run this query yourself, you are quite likely to see the same result I do: The execution plan depends on the version of SQL Server used, and does not depend on database compatibility level.

C++ 58

C++ Servers Database Performance 58

Alex Russell

MARCH 6, 2021

Back in 2016, I gave a talk outlining the causes and effects of the terrible performance of web apps built using popular tools on the fastest-growing device segment: low-end to mid-range Android phones. Modern network performance and availability. The cheapest (high volume) Androids perform like 2012/2013 iPhones, respectively.

Performance 124

Performance Network Cache Metrics 124

SQL Server According to Bob

JANUARY 28, 2018

Note: SQL Server can be a client using a linked server, allowing SQL Server to become an APP and/or an RM ). The application then uses the SQL Server client (SQL Server ODBC for this example) to establish a TDS based connection to the target SQL Server (local or remote.). Local Host Name. The olehlp!

Servers 40

Servers Azure Engineering Java 40

SQL Performance

FEBRUARY 22, 2021

I would like to share a couple of recent examples that help illustrate how using deprecated SQL Server features continues to bite us. The system table sys.sysprocesses was replaced way back in SQL Server 2005 by a set of dynamic management views (DMVs), most notably sys.dm_exec_requests , sys.dm_exec_sessions , and sys.dm_exec_connections.

Latency 57

Latency Servers Monitoring Systems 57

Alex Podelko

OCTOBER 28, 2016

I am looking forward to share my thoughts on ‘Reinventing Performance Testing’ at the imPACt performance and capacity conference by CMG held on November 7-10, 2016 in La Jolla, CA. This option has been available for a long time, but it is much more viable now. – Cloud. – Agile. – Continuous Integration.

Performance Testing 100

Performance Testing Technology Technology Testing 100

SQL Server According to Bob

NOVEMBER 29, 2016

Back in June, Bob Dorr gave you the thinking behind why SQL Server 2016 It Just Runs Faster due to changes in our SQL Server and NUMA configurations. Bob blogged about a new SQL Server 2016 feature called Auto Soft NUMA. 144 total logical processors as exposed by the Windows OS and seen by SQL Server.

Servers 45

Servers Virtualization Scalability Hardware 45

Percona

JANUARY 17, 2019

On multi-core machines – which is the majority of the hardware nowadays – and in the cloud, we have multiple cores available for use. I will compare AWS Aurora with MySQL (Percona Server) 5.6 84.1 | | version_comment | Percona Server (GPL), Release 84.1, With faster disks (i.e. MySQL on ec2.

Cache 48

Cache C++ AWS Airlines 48

MachMetrics

JUNE 30, 2021

from wpostats, 2016 ). The factors that impact on LCP: Slow origin server response times Render-blocking JavaScript and CSS on page load Page Resource load times User side page rendering. You can make beautiful-looking websites with the supports of millions of themes & plugins available. Check the calculator image below –.

Cache 78

Cache Speed Google Website 78

SQL Performance

APRIL 20, 2021

This is the third in a five-part series taking a deep dive into the way SQL Server row mode parallel plans start executing. A reminder of the plan ( click to enlarge ): This is the first point in the process so far that an in-flight execution plan is available (SQL Server 2016 SP1 onward) in sys.dm_exec_query_statistics_xml.

C++ 98

C++ Processing Servers Cache 98

SQL Performance

MAY 1, 2019

The summary rows for heap tables without indexes are the same in both documents (no changes for SQL Server 2016): An explicit TABLOCK hint is not the only way to meet the requirement for table-level locking. The inputs to this calculation are: The version of SQL Server. Target table row size. The Data Size Calculation.

Servers 47

Servers Database Testing Performance 47

SQL Performance

MAY 29, 2019

It can be activated from SQL Server 2008 to 2014 inclusive using documented trace flag 610. From SQL Server 2016 onward, FastLoadContext is enabled by default ; the trace flag is not required. For more background, see the Data Performance Loading Guide and the Tiger Team notes on the behaviour changes for SQL Server 2016.

Cache 64

Cache Testing Servers Code 64

SQL Performance

SEPTEMBER 25, 2019

The Lazy Index Spool operator is only available with apply. For modern versions of SQL Server, this essentially means that all key columns in an index spool must be of a comparable type, no more than 900 bytes* in total, with 64 key columns or fewer. Lazy Index Spool. Optimizer Rules. Rule Matching. Trace Flags and Hints.

Performance 104

Performance Cache Servers Education 104

SQL Performance

JULY 9, 2019

The ISO/IEC 9075:2016 standard (SQL:2016) defines a feature called nested window functions. This feature is currently not available in T-SQL. I posted a suggestion to improve SQL Server by adding support for nested window functions. Make sure to add your vote if you feel that this feature could be beneficial to you.

Servers 83

Servers Availability Database Code 83

SQL Performance

APRIL 8, 2019

These VMs are not available in all regions, so you will want to check the availability in the Azure region that you are interested in using. These AMD EPYC processors have a number of advantages for SQL Server workloads, as I will explain in this article. Since then, Microsoft has changed the naming of this series to Lsv2.

Azure 42

Azure Virtualization Storage Benchmarking 42

SQL Performance

SEPTEMBER 5, 2019

I briefly mentioned that batch mode data is normalized in my last article Batch Mode Bitmaps in SQL Server. You will need SQL Server 2016 (or later) and Developer Edition (or equivalent) to reproduce the results shown here. You can skip the WHERE clauses if you are running SQL Server 2017. s = SUM ( T.

Performance 81

Performance C++ Storage Servers 81