SQL Performance

JANUARY 23, 2020

The queues component of our methodology comes from Performance Monitor counters, which provide a view of system performance from a resource standpoint.". Tom Davidson, Opening Microsoft's Performance-Tuning Toolbox SQL Server Pro Magazine, December 2003. Waiting queries mean waiting applications and users, and no one likes to wait!

Tuning 115

Tuning Servers Monitoring Hardware 115

All Things Distributed

DECEMBER 20, 2017

That was the provocative thesis of a much-talked-about article from 2003 in the Harvard Business Review by the US publicist Nicolas Carr. These examples underline that the purpose of software today is not solely to support business processes, but that software solutions have broadly become an essential element in multiple business areas.

Artificial Intelligence 79

Artificial Intelligence Social Media Logistics AWS 79

HammerDB

OCTOBER 12, 2018

As with the previous guides as an Intel employee (#IAMINTEL) the examples are taken from a MySQL 8 on Linux on Intel system and the approach is the same for whatever system you are testing although some of the settings you see may be different. System Setup: CPU, Memory and I/O Configuration. hardware limits: 1000 MHz - 3.80

Best Practices 40

Best Practices Scalability Performance C++ 40

HammerDB

OCTOBER 8, 2018

This post gives a HOWTO guide on system configuration for achieving top levels of performance with the HammerDB PostgreSQL TPC-C test. Firstly for system choice a 2 socket system is optimal for PostgreSQL OLTP performance at the time of writing. CPUs which need to have their frequency coordinated by software: 0.

Best Practices 40

Best Practices Scalability Performance Hardware 40

O'Reilly Software

MARCH 7, 2018

Build a more scalable, composable, and functional architecture for interconnecting systems and applications. Software today is not typically a single program—something that is executed by an operator or user, producing a result to that person—but rather a service : something that runs for the benefit of its consumers, a provider of value.

Transportation 72

Transportation Java Programming Architecture 72

The Agile Manager

NOVEMBER 30, 2014

Obviously, we don't want to pay to maintain multiple e-Commerce sites or pay licensing fees for multiple ERP systems. We need to combine systems, and do so quickly. There are plenty of cookie-cutter frameworks for combining businesses, even their technology systems and operations. True, but not very helpful.

Airlines 40

Airlines Efficiency Systems Processing 40

Tasktop

OCTOBER 29, 2019

Measurements of the exchange of value and risk have produced the financial system that defines the world economy. With the underpinnings of our organizations and our economy shifting to intangible assets powered by software, how is that we still do not have an established way of measuring value and risk in software delivery?

Metrics 9

Metrics DevOps Programming Innovation 9

Highly Scalable

MARCH 10, 2015

Most of this article represents an overview of the results published by retailers and researchers who built practical decision making and optimization systems combining abstract economic models with data mining methods. The most typical use cases for this problem are recommender systems, personalized search results ranking, and targeted ads.

Retail 152

Retail C++ Analytics Metrics 152

SQL Server According to Bob

JANUARY 11, 2020

​​ Without limiting the rights under copyright, no part of this document may be reproduced, stored in or introduced into a retrieval system, or transmitted in any form or by any means (electronic, mechanical, photocopying, recording, or otherwise), or for any purpose, without the express written permission of Microsoft Corporation.

Servers 40

Servers Cache Database Media 40