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. Recently one of our teams was investigating a log reader latency issue. dm_os_performance_counters.

Latency 57

Latency Servers Monitoring Systems 57

Dean Hume

APRIL 24, 2018

Electricity used by servers doubled between 2000 and 2005 (and has continued growing ever since) from 12 billion to 23 billion kilowatt hours. Without effective caching on the client, the server will see an increase in workload, more CPU usage and ultimately increased latency for the end user. Show me the money! Conclusion.

Energy 40

Energy Cache Traffic Website 40

Dean Hume

APRIL 24, 2018

Electricity used by servers doubled between 2000 and 2005 (and has continued growing ever since) from 12 billion to 23 billion kilowatt hours. Without effective caching on the client, the server will see an increase in workload, more CPU usage and ultimately increased latency for the end user. Show me the money! Conclusion.

Energy 40

Energy Cache Traffic Website 40

Dean Hume

APRIL 24, 2018

Electricity used by servers doubled between 2000 and 2005 (and has continued growing ever since) from 12 billion to 23 billion kilowatt hours. Without effective caching on the client, the server will see an increase in workload, more CPU usage and ultimately increased latency for the end user. Show me the money! Conclusion.

Energy 40

Energy Cache Traffic Website 40

John McCalpin

APRIL 2, 2020

This was a keynote presentation at the “2nd International Workshop on Performance Modeling: Methods and Applications” (PMMA16), June 23, 2016, Frankfurt, Germany (in conjunction with ISC16 ). This system would be considered a “high-memory-bandwidth” system at the time these results were collected.

Benchmarking 59

Benchmarking Performance Latency Architecture 59

Dynatrace

DECEMBER 22, 2021

With observability, teams can understand what part of a system is performing poorly and how to correct the problem. Metrics are measures of critical system values, such as CPU utilization or average write latency to persistent storage. Traces provide performance data about tasks that are performed by invoking a series of services.

Artificial Intelligence 177

Artificial Intelligence Metrics Architecture DevOps 177

SQL Server According to Bob

JANUARY 11, 2020

As ​​ the ​​ administrator of a SQL Server 2005 installation, ​​ you will find that ​​ visibility into ​​ the ​​ SQL Server ​​ I/O ​​ subsystem ​​ has been ​​ significantly increased.

Servers 40

Servers Cache Database Media 40