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

ScaleOut Software

JUNE 22, 2020

The pace of these changes has made it challenging for server-based infrastructures to manage fast-growing populations of users and data sources while maintaining fast response times. They transparently distribute stored objects across the cluster’s servers and ensure that data is not lost if a server or network component fails.

Ecommerce 52

Ecommerce Cache Scalability IoT 52

ScaleOut Software

JUNE 22, 2020

The pace of these changes has made it challenging for server-based infrastructures to manage fast-growing populations of users and data sources while maintaining fast response times. They transparently distribute stored objects across the cluster’s servers and ensure that data is not lost if a server or network component fails.

Ecommerce 52

Ecommerce Cache Scalability IoT 52

Rigor

JANUARY 13, 2020

Podjarny presents a series of increasingly larger-scope solutions to each issue, including client-side techniques and RESS (Responsive + Server Side). You only have a few seconds to get compelling content onto the screen. Fail, and you can kiss your customers and profits goodbye.” ” – Andy King, 2003. Responsive and Fast.

Performance 75

Performance Social Media Website Performance Website 75

SQL Server Performance

NOVEMBER 10, 2017

Reporting Server Configuration Details: SQL Server Version: SQL Server 2005 […].

Tuning 40

Tuning Performance Servers Database 40

SQL Performance

JULY 1, 2021

There was the case where a colleague constantly promoted the deprecated backward compatibility view sys.sysprocesses instead of newer dynamic management views (DMVs), and another case where a different colleague took down a production server using SQL Server Profiler.

C++ 58

C++ Database Servers Performance 58

SQL Performance

OCTOBER 9, 2019

The EOMONTH function was introduced in SQL Server 2012. Many people are not aware that SQL Server 2017 introduced a new function called TRANSLATE that simplifies such replacements a great deal. SQL Server 2017 introduced support for the function TRIM. SQL Server 2012 introduced the function CONCAT. That's pretty neat!

C++ 111

C++ Database Servers Code 111

Dean Hume

APRIL 24, 2018

As data centers and volumes of servers have grown, so has the overall amount of electricity consumed around the world. Electricity used by servers doubled between 2000 and 2005 (and has continued growing ever since) from 12 billion to 23 billion kilowatt hours. Server Power Consumption (Source: Intel Labs 2008).

Energy 40

Energy Cache Traffic Website 40

Dean Hume

APRIL 24, 2018

As data centers and volumes of servers have grown, so has the overall amount of electricity consumed around the world. Electricity used by servers doubled between 2000 and 2005 (and has continued growing ever since) from 12 billion to 23 billion kilowatt hours. Server Power Consumption (Source: Intel Labs 2008).

Energy 40

Energy Cache Traffic Website 40

Dean Hume

APRIL 24, 2018

As data centers and volumes of servers have grown, so has the overall amount of electricity consumed around the world. Electricity used by servers doubled between 2000 and 2005 (and has continued growing ever since) from 12 billion to 23 billion kilowatt hours. Server Power Consumption (Source: Intel Labs 2008).

Energy 40

Energy Cache Traffic Website 40

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 Performance

FEBRUARY 17, 2022

Since SQL Server 2005, the trick of using FOR XML PATH to denormalize strings and combine them into a single (usually comma-separated) list has been very popular. In the SQL Server 2005 days, I would have offered this solution: SELECT DISTINCT UserID , Bands =. ( 1 Pink Floyd, New Order, The Hip 2 Zamfir, ABBA.

Servers 82

Servers Code Efficiency Performance 82

SQL Server According to Bob

JANUARY 11, 2020

Microsoft, ​​ Windows, ​​ Windows NT, ​​ and Windows Server ​​ are registered trademarks of Microsoft Corporation in the United States and/or other countries. The names of actual companies and products mentioned herein may be the trademarks of their respective owners.

Servers 40

Servers Cache Database Media 40

Dynatrace

DECEMBER 22, 2021

For example, in 2005, Dynatrace introduced a distributed tracing tool that allowed developers to implement local tracing and debugging. A database could start executing a storage management process that consumes database server resources. The case for an integrated observability platform.

Artificial Intelligence 182

Artificial Intelligence Metrics Architecture DevOps 182

Brendan Gregg

MARCH 16, 2024

2005-2023: The winter of broken profilers However, the change was then applied to x86-64 (64-bit) as well, which had sixteen registers and didn't benefit so much from a seventeenth. Back-end servers. What about Linux on devices where there is no chance of profiling or debugging, like electric toothbrushes? (I

Java 145

Java Cache Google Hardware 145

Smashing Magazine

MAY 17, 2021

I founded Instant Domain Search in 2005 and kept it as a side-hustle while I worked on a Y Combinator company (Snipshot, W06), before working as a software engineer at Facebook. Over time, we’ve evolved through a variety of static site generators, JavaScript frameworks, and server technologies. server) asynchronously in the background.

Google 93

Google Analytics Serverless Metrics 93

SQL Performance

JANUARY 23, 2020

Tom Davidson, Opening Microsoft's Performance-Tuning Toolbox SQL Server Pro Magazine, December 2003. Waits and Queues has been used as a SQL Server performance tuning methodology since Tom Davidson published the above article as well as the well-known SQL Server 2005 Waits and Queues whitepaper in 2006.

Tuning 115

Tuning Servers Monitoring Hardware 115

SQL Performance

MARCH 22, 2022

It's almost always better to explicitly parameterize statements, rather than relying on the server to do it. In any event, it would be an unusual workload that does not contain at least some parameterized statements server-side. Let’s look at an example, using the Stack Overflow 2010 database on SQL Server 2019 CU 14.

Cache 61

Cache Servers Database Code 61

SQL Performance

MARCH 30, 2021

This five-part series takes a deep dive into the way SQL Server row mode parallel plans start up. ) ; My test environment is SQL Server 2019 CU9 on a laptop with 8 cores and 16GB of memory allocated to the instance. See Myth: SQL Server Caches a Serial Plan with every Parallel Plan for details. Parallel Plan Initialization.

Cache 98

Cache Servers Operating System Processing 98

KeyCDN

MARCH 28, 2019

Features Simple and fast routing engine Comes with its own CLI Powerful template system (Blade) Good documentation CakePHP CakePHP is one of the first PHP frameworks to be released back in 2005. Many popular server-side and full stack frameworks use Express such as Feathers, KeystoneJS, MEAN, Sails, and more.

Programming 77

Programming Website Scalability Design 77

SQL Server According to Bob

JUNE 3, 2016

SQL Server 2016 ‘It Just Runs Faster’ A bold statement that any SQL Server professional can stand behind with confidence. Try SQL Server 2016 Today. The SQL Server Development team tasked several individuals with scalability improvements and real world testing patterns. – [link]. Follow-up.

Hardware 40

Hardware Software Engineering Transportation Scalability 40

Brendan Gregg

NOVEMBER 29, 2017

It's amazing to recall that it was even possible to virtualize x86 before processors had hardware-assisted virtualization (Intel VT-x and AMD-V), which were added in 2005 and 2006. AWS Bare Metal 2017 Also announced at AWS re:Invent: the Amazon EC2 Bare Metal instances, which are just that – bare metal servers.

Virtualization 111

Virtualization AWS Hardware Storage 111

SQL Performance

AUGUST 12, 2020

You can find it in the documentation of Microsoft SQL Server and Azure SQL Database. T-SQL supports it starting with SQL Server 2005. So it could be that the term originated in one of the database products and later adopted by some of the other database vendors.

C++ 140

C++ Code Design Database 140

Brendan Gregg

NOVEMBER 28, 2017

It's amazing to recall that it was even possible to virtualize x86 before processors had hardware-assisted virtualization (Intel VT-x and AMD-V), which were added in 2005 and 2006. AWS Bare Metal 2017 Also announced at AWS re:Invent: the Amazon EC2 Bare Metal instances, which are just that – bare metal servers.

Virtualization 40

Virtualization AWS Hardware Storage 40

Brendan Gregg

AUGUST 8, 2017

The oldest change in the entire Linux repo dates back to 2005, when Linus imported Linux 2.6.12-rc2, Thankfully, I found some older linux-devel mailing list archives, rescued from server backups, often stored as tarballs of digests. It's time in some cgroup paths, but this server is not doing much disk I/O. to the load average.

Latency 111

Latency Metrics C++ Systems 111