SQL Performance

FEBRUARY 22, 2021

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. I would like to share a couple of recent examples that help illustrate how using deprecated SQL Server features continues to bite us.

Latency 57

Latency Servers Monitoring Systems 57

SQL Performance

MARCH 30, 2021

The fundamentals of row mode parallel execution haven’t changed since SQL Server 2005, so the following discussion is broadly applicable. At this point, only the original thread processing the current request exists. The process of transforming the plan template for a specific run is known as creating the executable plan.

Cache 98

Cache Servers Operating System Processing 98

MachMetrics

NOVEMBER 22, 2020

These often add a lot of time to the loading process and don’t add value of any kind. Obviously, you don’t need to make your website look like it’s from 2005. Look again at the websites above. Instead, consistently focus on what your users are there to see.

Website 57

Website Speed Google Cache 57

O'Reilly

APRIL 23, 2024

In 2005, in “ What is Web 2.0? ,” I made the case that the companies that had survived the dotcom bust had all in one way or another become experts at “harnessing collective intelligence.” If they begin to twist its objectives for their own benefit, we should be able to see it in the numbers.

Social Media 108

Social Media Google Internet Internet 108

IO River

NOVEMBER 2, 2023

Therefore, there might be cases where your system could experience a downtime during the migration process. Not only that, but there can be cases where a piece of your application could break during the migration process that could take a long time to get back running.‍How How does vendor lock-in occur?It's

Lambda 52

Lambda AWS Cache Website 52

SQL Performance

MARCH 29, 2022

Forced parameterization wasn’t added until SQL Server 2005, so Microsoft had the opportunity to incorporate some lessons from the simple parameterization experience, and didn’t have to worry much about backward-compatibility issues. As said before, you’re better off using explicit parameters with known data types wherever possible.

Cache 90

Cache Servers Database Testing 90

SQL Performance

SEPTEMBER 29, 2021

In SQL Server 2005, I started using schemas to hold shadow copies of tables I simply transferred around using the same shell game technique, which I wrote about in these two posts: Trick Shots: Schema Switch-a-Roo. Partition switching allows you to pick which part of your process bears the cost of concurrency.

Servers 55

Servers Games Database Processing 55

SQL Performance

MARCH 22, 2022

Being explicit gives you complete control over all aspects of the parameterization process, including where parameters are used, the precise data types used, and when plans are reused. When SQL Server 2005 introduced Forced Parameterization , the existing auto-parameterization feature was renamed to Simple Parameterization.

Cache 61

Cache Servers Database Code 61

IO River

NOVEMBER 2, 2023

Therefore, there might be cases where your system could experience a downtime during the migration process. Not only that, but there can be cases where a piece of your application could break during the migration process that could take a long time to get back running.‍How does vendor lock-in occur?It's

Lambda 52

Lambda AWS Cache Website 52

SQL Server According to Bob

JUNE 3, 2016

The new column store engine and query processing technology could increase query performance up to 100X and the new In-memory OLTP engine can process 1.25million batches/sec on a single 4 socket server, which is more than 3X of SQL 2014. “ – Rohan Kumar, Director of SQL Software Engineering.

Hardware 40

Hardware Software Engineering Transportation Scalability 40

John McCalpin

APRIL 2, 2020

The presentation discusses a family of simple performance models that I developed over the last 20 years — originally in support of processor and system design at SGI (1996-1999), IBM (1999-2005), and AMD (2006-2008), but more recently in support of system procurements at The Texas Advanced Computing Center (TACC) (2009-present).

Benchmarking 59

Benchmarking Performance Latency Architecture 59

All Things Distributed

AUGUST 17, 2011

But while this blog happily runs out of S3, the process of creating and updating the content still required a server to run my Moveable Type installation and hold the database. I have regenerated all pages since 2005, the pages before that can be found in the "/historical" section.

Servers 126

Servers Social Media AWS Website 126

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 EC2 uses a different image type and boot process for PV and HVM, as described on the [Linux AMI Virtualization Types] page.

Virtualization 111

Virtualization AWS Hardware Storage 111

The Agile Manager

SEPTEMBER 30, 2013

Technocracy was, too: "best practice" was derived from people performing narrowly defined tasks in rigid processes that yielded poor quality products at a high cost. Microcomputing was expected to change information processing patterns of businesses, enabling better analysis and decision support at lower levels of the organization.

Education 45

Education Best Practices Retail Network 45

Brendan Gregg

AUGUST 8, 2017

This measures demand, which can be greater than what the system is currently processing. 42/3411 43603. . ## History The original load averages show only CPU demand: the number of processes running plus those waiting to run. The load average is an average of the number of runnable processes over a given time period.

Latency 111

Latency Metrics C++ Systems 111

SQL Performance

AUGUST 12, 2020

T-SQL supports it starting with SQL Server 2005. The issue with this solution is that you cannot assign a name to a table expression and reuse it in the same logical query processing step. In logical query processing terms, by the time you get to the outer query, the CTE name is already defined and available. orderyear , CUR.

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 EC2 uses a different image type and boot process for PV and HVM, as described on the [Linux AMI Virtualization Types] page.

Virtualization 40

Virtualization AWS Hardware Storage 40

Highly Scalable

MARCH 10, 2015

More specialized data mining applications like supply chain optimization and fraud detection are out of scope, as well as the implementation details of the data mining process (such as evaluation of model quality). Outputs of this tier can be used to configure downstream processes. and the supporting data mining processes.

Retail 152

Retail C++ Analytics Metrics 152

SQL Server According to Bob

DECEMBER 18, 2018

CSA ISO/IEC 9945-1:2005 (R2009) 3.375 Synchronized I/O Data Integrity Completion. Refer to the ISO documentation on file integrity for complete details: CSA ISO/IEC 9945-1:2005 (R2009) 3.376 Synchronized I/O File Integrity Completion. The data storage always uses the multi-step flush process. File Integrity Standard. O_NONBLOCK.

Servers 90

Servers Media Cache Storage 90

Smashing Magazine

JULY 9, 2021

The British Standards Institution (2005) defines inclusive design as : “The design of mainstream products and/or services that are accessible to, and usable by, as many people as reasonably possible. without the need for special adaptation or specialized design.”. Or one that I have used in the past, don’t ask, just do it.

Website 145

Website Mobile Design Testing 145

Smashing Magazine

SEPTEMBER 16, 2021

It looked realistic in 2004 but the rule was already irrelevant by 2005. It also can be used during the conception and design process using excerpts of the checklist. However, we found the audit or pre-launch was probably not the first thing needed to efficiently start a web quality assurance process.

Automotive 138

Automotive Website Social Media Design 138

The Agile Manager

FEBRUARY 28, 2021

When I first joined ThoughtWorks in 2005, one of our core messages was to solve an “outer quadrant” problem first - something in the problem space that is difficult and complex. Mentoring can be a slow process, the results difficult to measure, it doesn’t scale, and it doesn’t garner a whole lot of attention.

Virtualization 52

Virtualization Systems Technology Technology 52

The Agile Manager

MAY 7, 2010

A contract from 2005 between one firm and another is a binding legal document in the context of that relationship. We tame the data monster through our mental memories and our synaptic processes. Search is really a simple attribute-based pattern matching tool that abdicates results processing to the individual.

Storage 40

Storage Internet Internet Mobile 40