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

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

Percona

JANUARY 14, 2019

What if we use ClickHouse (which is a columnar analytical database) as our main datastore? Well, typically, an analytical database is not a replacement for a transactional or key/value datastore. Although such databases can be very efficient with counts and averages, some queries will be slow or simply non existent. 2006-01-01

Database 40

Database Analytics Blockchain Healthcare 40

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. But not all workloads: some are network bound (proxies) and storage bound (databases). ## 5. The first was c3. 0% performance overhead.

Virtualization 111

Virtualization AWS Hardware Storage 111

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. But not all workloads: some are network bound (proxies) and storage bound (databases). ## 5. The first was c3. 0% performance overhead.

Virtualization 40

Virtualization AWS Hardware Storage 40

SQL Performance

SEPTEMBER 25, 2020

Back in 2006, I complained via multiple Connect items about the lack of visibility of the default values for parameters in the catalog views. However, the problem still exists in SQL Server 2019. Here’s the only item I’ve found that made it to the new feedback system.). now we need to try parsing.

Code 42

Code C++ Database Servers 42

The Agile Manager

MAY 31, 2013

For software we build, we underwrite the responsibility for the fact that it will be technically sound and functionally fit, secure and reliable, and will work in the client and server environments where it needs to operate. As builder-owners, we have responsibility for these things during the entire useful life of the software.

Software 45

Software Software Mobile Technology 45