SQL Performance

JULY 24, 2022

SQL Server 2012 went out of all forms of official support about two weeks ago, on July 12 th. Best approaches for running totals – updated for SQL Server 2012. In the very first post on this site, I compared the performance of long-standing running totals methods with the new windowing functions added in SQL Server 2012.

Servers 66

Servers Strategy Availability Processing 66

SQL Performance

JANUARY 23, 2020

Tom Davidson, Opening Microsoft's Performance-Tuning Toolbox SQL Server Pro Magazine, December 2003. Waits and Queues has been used as a SQL Server performance tuning methodology since Tom Davidson published the above article as well as the well-known SQL Server 2005 Waits and Queues whitepaper in 2006.

Tuning 115

Tuning Servers Monitoring Hardware 115

Particular Software

JULY 18, 2017

We built a custom content management website backed by a single SQL Server database. Yes/No) Is my web server up? (Yes/No) Yes/No) Is my web server up? Yes/No) Can my web server talk to my database? I remember the first time I deployed a system into production.

Systems 56

Systems Monitoring Website Virtualization 56

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? I recently posted on aspects of the SQL Server Lock Manager and found the iteration of the locks interesting as I was stepping in the code. link] [link].

Servers 40

Servers Software Engineering Database Monitoring 40

Percona

OCTOBER 2, 2023

Percona Toolkit is a collection of advanced open source command-line tools, developed and used by the Percona technical staff, that are engineered to perform a variety of MySQL, MariaDB, MongoDB, and PostgreSQL server and system tasks that are too difficult or complex to perform manually. And did I mention they are open source?! virtual = 2.2G

Cache 97

Cache Database Virtualization Servers 97

Testsigma

DECEMBER 4, 2020

Web app testing : Optimized for mobile browsing and server-driven, the web apps should be tested for UI to ensure that all the elements of the app are aligned for different screens and resolutions. Back-end or database testing deals with the server-side of the mobile app. App users want to see something new and innovative.

Mobile 65

Mobile Testing Operating System Storage 65

SQL Performance

MAY 17, 2021

This is the final part of a five-part series taking a deep dive into the way SQL Server row mode parallel plans start executing. Part 1 initialized execution context zero for the parent task, and part 2 created the query scan tree. Branch B Parallel Tasks Start. Branch C (additional parallel tasks). Checkpoint.

C++ 139

C++ Processing Design Availability 139