SQL Server According to Bob

MAY 29, 2020

Do you know how this works? ” -​​ Jonathan Kehayias The developer’s ( Panagiotis )​​ answer : The goal of WAIT_AT_LOW_PRIORITY is to avoid blocking any other requests while waiting for a lock. ​​ ​​ Once the SCH-M is acquired in the final partition it's good to go.

Servers 40

Servers Processing Systems 40

Speed Curve

OCTOBER 27, 2020

How is it calculated? Ultimately, how much should we care about CLS? Cumulative Layout Shift measures how visually stable a page is. It's a formula-based metric that, put very (very) simply, takes into account how much visual content shifts within the viewport, combined with the distance that those visual elements shifted.

Retail 82

Retail Benchmarking Google Metrics 82

SQL Server According to Bob

FEBRUARY 20, 2020

How It Works: TSQL TRY/CATCH ​​ Behavior ​​ Fooled Me If I would have ​​ simply ​​ read the documentation ( [link] ) the answer to my problem ​​ is answered. Create the following procedure where foo does not exist.

Design 40

Design 40

SQL Server According to Bob

SEPTEMBER 14, 2020

How It Works: Bulk Insert (BCP.exe) ​​ – Injecting a Sort Operation I ran across an interesting issue this week related to the use of Bulk Insert/BCP and sorting.

Servers 40

Servers 40

SQL Server According to Bob

NOVEMBER 29, 2016

As I’ve hit the road and talked more about SQL Server 2016: It Just Runs Faster , I’ve received some questions about how Auto Soft NUMA works and how to recognize how SQL Server detects a NUMA configuration and makes decisions to partition it even further. But how do I know which ones? What about DMVs?

Servers 45

Servers Virtualization Scalability Hardware 45

SQL Server According to Bob

OCTOBER 17, 2019

When executing a query to enumerate the locks, such as select * from sys.dm_tran_locks, how does SQL Server scan the locks and avoid impacting the overall concurrency? The marker maintains the stability of the lock and the restart position for the iterator while allowing other workers to continue working, limiting the impact on concurrency.

Servers 40

Servers Software Engineering Database Monitoring 40

SQL Server According to Bob

SEPTEMBER 9, 2019

Save the current row information (last values) with the new session object. Update the LOGIN_STATS row with the current time for successful login. Acknowledge login. LOGIN_STATS (Lock Type By Stat Row) – Partitioned. To acquire the SCH_M the SCH_M must be granted in all 132 partitions, in order from 0 to 131.

Servers 40

Servers Software Engineering Database Engineering 40

SQL Server According to Bob

AUGUST 4, 2016

Here is how to reproduce the scenario. Connection does some work under the DTC transaction umbrella Client disconnects (or enlists in NULL). and still be doing work. Now that I have described the scenario steps let’s step through how the DTC transaction flow works.

Servers 40

Servers Software Engineering Database Engineering 40

SQL Server According to Bob

JULY 23, 2016

T1 – Acquires access for read T1 – Starts doing some work T2 – Attempts to acquire access for read – BLOCKED and spins, burning CPU and not making forward progress. T1 – Release access T2 – Stops spinning and finishes acquire T2 – Does some work T2 – Releases access. T2 – Starts doing some work T1 – Releases T2 – Releases.

Cache 40

Cache Software Engineering Servers Code 40

SQL Server According to Bob

MAY 23, 2017

While this is a pretty unusual scenario, I wanted to highlight how the trace flag works so you can use appropriately. The test in question is designed to cause large amounts of deadlocks in order to stress the deadlock detection and resolution code paths.

Servers 40

Servers Software Engineering Monitoring Design 40

SQL Server According to Bob

JANUARY 28, 2018

Transaction GUID used by MSDTC, often referred to as a UOW (Unit-of-Work). A common question is how to enable DTC (MSDTC and/or XA) with SQL Server on Linux. Do work with SQL Server using a local SQL Server transaction, not distributed. Microsoft MSDTC protocol. Transaction identifier used by XA with proper OID data section.

Servers 40

Servers Azure Engineering Java 40

SQL Server According to Bob

SEPTEMBER 1, 2016

I was approached to revisit the details of how Error Message 833 is detected and reported. To recap, Scheduler Monitor does the work to look at the I/O state and when pending and greater than 15 seconds the 833 logic is invoked. The OS file handle is 0x%p. The offset of the latest long I/O is: %#016I64x.

Servers 45

Servers Software Engineering Monitoring Database 45

SQL Server According to Bob

SEPTEMBER 16, 2016

Yesterday I had a discussion with a customer and realized that the BCP, TDS pattern could use a bit of documentation. Customer Scenario/Question: I am using BCP.exe to import a large data set. BCP.exe takes 15 minutes to complete but I only see a few seconds for the BULK INSERT command when monitoring dm_exec_requests.

Traffic 40

Traffic Software Engineering Servers Monitoring 40

SQL Server According to Bob

JULY 4, 2016

There are a variety of posts talking about the black box recorder (XEL Health Session) explaining what the recorder is and does: [link]. This week I ran into niche behavior while looking at the health session output. While it is unlikely to have any impact on your server the output during a SQL Server shutdown could mislead you.

Software Engineering 40

Software Engineering Servers Design Monitoring 40

SQL Server According to Bob

AUGUST 17, 2016

Have you encountered the following in your SQL Server error log? Long Sync IO: Scheduler 95 had 1 Sync IOs in nonpreemptive mode longer than 1000 ms. There are two general types of I/O performed by SQL Server. Async – Vast majority of SQL Server I/Os, as outlined in the provided link: [link].

Software Engineering 56

Software Engineering Servers Engineering Software 56

SQL Server According to Bob

JUNE 9, 2016

I have received questions related to how SQL Server accomplishes the alignment on both bare metal and VM installations. SQL Server, as outlined in the following post ( [link] ) adjusts to various processor configurations.

Servers 40

Servers Virtualization Tuning Architecture 40

SQL Server According to Bob

JUNE 6, 2016

The inquiries have centered around the support boundaries of the SSE and AVX instructions. This post will outline SQL Server’s decisions around SSE/AVX or software algorithm use. SQL Server asks the CPU if it supports SSE or AVX in order to determine the level of hardware support present on the system.

Servers 40

Servers Hardware Software Engineering Software 40

SQL Server According to Bob

NOVEMBER 8, 2016

How much faster you can go using direct access? This post is targeted at explaining how the tail of the log is optimized to take advantage of direct access. SQL works with the operating system to detect the non-volatile storage devices and leverage them for the tail of the log. Announcement and Syntax Example: [link]. .

Cache 40

Cache Servers Media Storage 40

Dynatrace

APRIL 2, 2024

More specifically, all the things that can go wrong when moving to Kubernetes—and how to avoid making the mistakes that can lead to such problems. As someone who has worked deep in the coding trenches with developers my whole life, I’ve hand-picked the top three mistakes you can make when moving to Kubernetes. What are resource limits?

Virtualization 236

Virtualization Cloud Infrastructure Code 236

Dynatrace

FEBRUARY 8, 2024

Today’s macroeconomic environment is dynamic and uncertain, generating many questions about the future of work. As artificial intelligence becomes more pervasive in organizations, the workforce senses that the future of work is undergoing massive shifts. This strategy is becoming essential to thrive in the future of work.

Artificial Intelligence 271

Artificial Intelligence Technology Technology Strategy 271

DZone

MARCH 21, 2024

In today's world, where people expect apps to work quickly and without any problems, knowing how to use NCache Java Edition is very important. NCache Java Edition with distributed cache technique is a powerful tool that helps Java applications run faster, handle more users, and be more reliable.

Java 310

Java Cache Technology Technology 310

Scalegrid

MARCH 23, 2020

How it works. Check out the Pgpool-II architecture that supports all of its features, and learn how the connection pooler works. How it works. However, in this section, we will limit ourselves to describing how connection pooling works. Pgpool-II also provides logical replication. At a glance.

Cache 264

Cache Servers Architecture Processing 264

Dynatrace

MARCH 6, 2024

During a breakout session at the Dynatrace Perform 2024 conference, Dynatrace DevSecOps activist Andreas Grabner and staff engineer Adam Gardner demonstrated how to use observability to monitor an IDP for key performance indicators (KPIs). Argo works in a GitOps fashion to automate the deployment of files stored in Git.

Engineering 248

Engineering Development DevOps Infrastructure 248

DZone

MARCH 7, 2024

In this article, we'll explore what the Vector API is, how it works, and provide examples demonstrating its usage. In this article, we'll explore what the Vector API is, how it works, and provide examples demonstrating its usage.

Java 250

Java Processing Performance Development 250

The Netflix TechBlog

FEBRUARY 13, 2024

For instance, when using react-testing-library , a unit testing solution, you maintain complete control over what to render and how the underlying services and imports should behave. However, each of these methods presents a unique trade-off: you have to choose between controlling the test fixture and setup, or controlling the test driver.

Testing 244

Testing Code Servers Testing Tools 244

DZone

DECEMBER 14, 2023

It lets systems keep working properly even when problems occur. Additionally, we'll examine how different testing methods can identify potential issues and improve resilience. Emerging trends like cloud computing, containers, and serverless platforms are changing how resilient systems are built.

Strategy 293

Strategy Systems Serverless Cloud 293

Dynatrace

MARCH 20, 2024

This is the problem domain on which Keptn can help Platform Engineers provide a solution and guard rails for teams to deploy software that works perfectly. Integrate Keptn with your applications , which shows you how to configure your applications to be deployed with Keptn.

Open Source 275

Open Source Hardware DevOps Infrastructure 275

Dynatrace

MARCH 26, 2024

Values are the fabric of who we are, what we stand for as a company, and how we deliver what we promise to ourselves and our stakeholders. Why and how we refreshed our Core Values For more than 20 years, the Dynatrace team has been united by the vision of a world where software works perfectly.

Innovation 252

Innovation Tuning Strategy Software 252

DZone

SEPTEMBER 28, 2023

Previously, our application was using one database; developers knew how it worked, and the deployment rarely happened. A single database administrator was capable of maintaining the database, optimizing the queries, and making sure things worked as expected. Cloud and microservices changed the world.

Database 276

Database Software Engineering Cloud Software 276

Dynatrace

FEBRUARY 28, 2024

With Notebooks, analysts can “explore their data, use ad-hoc analysis, and work with data in a sequential fashion to refine, refine, refine,” Ziegelbecker said. When you work with data, it comes down to three steps: Discover, browse, and explore,” Zielgelbecker said.

Analytics 218

Analytics Metrics Media Monitoring 218

Dynatrace

APRIL 5, 2024

For me, working in tech has brought flexibility and continuous learning. As we reflect on Women’s History Month, I’d like to share my experience of how women can navigate a field where women in leadership often must carve their own paths. As a mother of two children, this flexibility helps me manage my home and team in tandem.

Technology 214

Technology Technology Innovation 214

Dynatrace

MARCH 29, 2024

During a breakout session at Dynatrace Perform 2024 , Alois Mayr, principal product manager at Dynatrace, and Stefano Doni, CTO at Akamas, broke down how Dynatrace and Akamas can help organizations enhance Kubernetes cluster management. Then, we can see how many nodes and workloads are running,” Mayr said. “We It’s using 1.5

Engineering 234

Engineering DevOps Operating System Open Source 234

Dynatrace

APRIL 15, 2024

Enhance authentication: From global to flexible identity federation Our established Global Identity Federation works by identifying the domain part of the user’s email address during the login. For more information about how Dynatrace implements identity federation, check out Dynatrace Documentation.

Strategy 264

Strategy Scalability Infrastructure Systems 264

Dynatrace

APRIL 3, 2024

Security operations center operators are typically security professionals and analysts who work closely with staff in IT operations and development roles. Telemetry data — such as metrics, logs, and traces — gives IT teams crucial context to understand how all entities are connected.

Government 164

Government Social Media Metrics Infrastructure 164

Dynatrace

APRIL 16, 2024

In all seriousness, the shift-left mantra has shaken things up quite a bit in the tech industry, bringing a paradigm shift in how we approach software development. It’s about seeing how the whole jigsaw puzzle fits together in a production-like setting. Maybe it’s not quite so dramatic, but that’s how it feels. It’s a big deal.)

Development 212

Development Software Software Tuning 212

Dynatrace

NOVEMBER 20, 2023

In the first year of applying for a Great Place to Work® certification, Dynatrace has been named a great place to work in 13 countries around the world. This is a huge accomplishment and shows that Dynatracers, our employees , truly enjoy working here. Why did we apply for Great Place to Work® certifications? In the U.S.

Innovation 200

Innovation C++ Programming Network 200

Dynatrace

APRIL 22, 2024

In the research, “Code Transformed: Tracking the Impact of Generative AI on Application Development,” sponsored by Dynatrace, findings indicate that AI and automation are already having a major impact on how developers are working today. What are continuous integration and continuous delivery?

Software 172

Software Software Artificial Intelligence Development 172