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

Dotcom-Montior

OCTOBER 6, 2021

The term site reliability engineering first came into existence at Google in 2003 when a site reliability team was created. To think about it another way, site reliability engineering is where the traditional IT role, or system administration role, and DevOps meet. At that time, the team was made up of software engineers.

Engineering 67

Engineering DevOps Monitoring Google 67

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. We need mechanisms that enable the mass production of data using software and hardware capabilities. The end effect is that the complexity of the system increases, which is not efficient.

Artificial Intelligence 72

Artificial Intelligence Social Media Logistics AWS 72

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 run at the same hardware frequency: 0. CPU Configuration.

Best Practices 40

Best Practices Scalability Performance Hardware 40

All Things Distributed

JULY 20, 2012

Werner Vogels weblog on building scalable and robust distributed systems. Back-to-Basics Weekend Reading - Virtualizing Operating Systems. This weekends back-to-basics reading is on operating system virtualization. By Werner Vogels on 20 July 2012 12:00 PM. Comments (). blog comments powered by Disqus. Contact Info.

Operating System 76

Operating System Virtualization Systems Hardware 76

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