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

SQL Performance

MARCH 17, 2020

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. The Sort only has 19 rows to process, so it consumes only 1ms or so. Test Environment. There is a clustered primary key index on the Id column of the dbo.Votes table.

Servers 86

Servers Tuning Database Efficiency 86

SQL Performance

MAY 1, 2020

In a recent tip , I described a scenario where a SQL Server 2016 instance seemed to be struggling with checkpoint times. Still, if you stack a bunch of high-transaction databases on there, checkpoint processing can get pretty sluggish. A SQL Server DBA myth a day: (15/30) checkpoint only writes pages from committed transactions.

C++ 58

C++ Database Servers Storage 58

Brendan Gregg

FEBRUARY 28, 2023

My personal opinion is that I don't see a widespread need for more capacity given horizontal scaling and servers that can already exceed 1 Tbyte of DRAM; bandwidth is also helpful, but I'd be concerned about the increased latency for adding a hop to more memory. That's about 24 hours from now!

Performance 52

Performance Latency Cache Virtualization 52

All Things Distributed

APRIL 5, 2012

Troy: We moved our service from internal servers to AWS. Jack: Since our launch in late 2008, weve grown to over 6 million teachers and students globally primarily through word of mouth of teachers who have shared Edmodo with each other. The best part was that the entire process was what I call Ã?hands hands freeÃ?

Innovation 146

Innovation AWS Education Network 146

Testsigma

FEBRUARY 9, 2022

Wikipedia states that in a 2008 report, open-source projects were able to save over USD 60 billion for the customers. This whole process will initiate communication between you and people from all around the world. Knowing them before starting real work is extremely important to do the process correctly. Find a mentor.

Open Source 52

Open Source Code Software Software 52

Dynatrace

JULY 24, 2023

We will also explore the evolution of DevOps automation and the significance of data-driven answers in unlocking streamlined, automated DevOps and SRE processes. Business process automation Business process automation is the foundation for improving operational efficiency.

DevOps 213

DevOps Traffic Efficiency Servers 213

SQL Performance

APRIL 26, 2019

The DTU calculator is a free tool you can use to upload performance metrics from your server, and use the data to determine the appropriate service tier if you were to migrate that server to an Azure SQL Database (or to a SQL Database elastic pool ). NOTE : This process is not officially supported by SentryOne.

Azure 40

Azure Database Metrics Servers 40

SQL Server According to Bob

JANUARY 11, 2020

Using SQL Server’s SNITrace to Troubleshoot Networking Issues In the process of tracking down a few TCP 10054 issues (highlighted here: ​​ [link] ) I ​​ also ​​ used ​​ the ​​ SNITrace ​​ (SNI Trace) ​​ capabilities.

Network 40

Network Servers Processing Software Engineering 40

SQL Performance

JUNE 21, 2019

I've been teaching and writing about common SQL Server mistakes for many years. This article will expand on my previous article and point out how these apply to SQL Server , Azure SQL Database , and Azure SQL Managed Instance. SQL Server Agent alerts. This situation applies to on-premises SQL Server and IaaS. Statistics.

Servers 49

Servers Azure Hardware Database 49

Smashing Magazine

AUGUST 20, 2021

Yet, for all these technological developments, it’s interesting that many of us are still serving sites in the same way Tim did with the very first website — a web server serving static website files. MovableType was one of the first static site generators on the market, although that term wouldn’t become popular until 2008.

Ecommerce 140

Ecommerce Website Government Internet 140

The Netflix TechBlog

AUGUST 29, 2023

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. For Inter-Process Communication (IPC) between services, we needed the rich feature set that a mid-tier load balancer typically provides.

Traffic 220

Traffic Latency Cloud C++ 220

SQL Performance

JULY 16, 2019

A close monitoring of the hardware enthusiast community, including many of the most respected hardware analysts and reviewers paints an even more dire picture about Intel in the server processor space. Despite all of this, Intel is not going to lose their entire server processor business any time soon. So, what has changed my mind?

Servers 46

Servers Hardware Architecture Retail 46

O'Reilly

JULY 25, 2023

And if I switch tabs to view a paper from 2008, then a song from 2008 could start up. To provide some coherence to the music, I decided to use Taylor Swift songs since her discography covers the time span of most papers that I typically read: Her main albums were released in 2006, 2008, 2010, 2012, 2014, 2017, 2019, 2020, and 2022.

Programming 98

Programming Code Design Benchmarking 98

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

SQL Performance

SEPTEMBER 6, 2022

I happen to be using SQL Server 2019 CU16 but the details I’ll describe haven’t materially changed since partition level lock escalation was added to SQL Server 2008. The SQL Server lock manager keeps track of the number of locks held by the current transaction. Testing environment. This seems like an oversight.

Database 98

Database Storage Testing Servers 98

SQL Performance

JANUARY 22, 2020

Table-valued parameters have been around since SQL Server 2008 and provide a useful mechanism for sending multiple rows of data to SQL Server, brought together as a single parameterized call. } ; We now have correct lengths for the column definitions, and we won't be passing them as LOBs over TDS to SQL Server.

Servers 55

Servers Azure Hardware Network 55

Randon ASCII

FEBRUARY 25, 2018

1) Building Chrome very quickly causes CcmExec.exe to leak process handles. Each build can leak up to 1,600 process handles and about 100 MB. This bug shows up from Server 2008 R2 (Windows 7) up to the latest stable build of Windows 10 and OS fixes will take a while to propagate so you might as well be careful.

Programming 79

Programming Hardware Cache Code 79

Brendan Gregg

SEPTEMBER 5, 2017

There's also a ZFS send/recv code path that should try to use the TASK_INTERRUPTIBLE flag (as suggested by a coworker), to avoid a kernel hang (can't kill -9 the process). On Linux, containers are a combination of namespaces (restricting what a process sees) and cgroups (similar to Solaris resource controls). amazon").

Virtualization 76

Virtualization AWS Engineering Hardware 76

Percona

JANUARY 14, 2019

Processed 4.15 Processed 4.15 Processed 8.19 Processed 8.19 Processed 4.15 Processed 3.05 Processed 8.19 toDate(max(created_utc))??????count()?? count()?? ? 2006-01-01 ? 2018-05-31 ? 4148248585 ? ???????????????????????????????????????????????????????????????????? 1 rows in set. Elapsed: 11.554 sec.

Database 40

Database Analytics Blockchain Healthcare 40