Scaling Up Monitoring
How do we design a monitoring system? The Amazon Prime team realized they didn't do a good job and changed their architecture.
2023-05-31
160 reads
How do we design a monitoring system? The Amazon Prime team realized they didn't do a good job and changed their architecture.
2023-05-31
160 reads
We need to monitor our servers, but individual metrics have more complexity than just setting simple limits for their readings.
2023-02-06 (first published: 2023-01-30)
304 reads
Querying perfmon data to track memory usage patterns on NUMA nodes
2019-05-31
The max_dispatch_latency property is the maximum duration that an event, once captured, would reside in the buffer before written to the target. The default for this property is 30 seconds, which is fine in practice but for live demos you can consider reducing it (minimum is 1 second).
2019-05-31
A useful script that I wrote that will sample the DMV sys.dm_os_performance_counters table to provide an average PLE captured in (1) minute intervals.
2010-12-01 (first published: 2010-11-16)
1,665 reads
By querying a single DMV, sys.dm_os_performance_counters to be precise, you can collect counter information that you would receive from PerfMon for the various SQL Server counters.
2010-06-29
3,559 reads
You have about 100 SQL Servers installed in your production environment. You have performance problems on few of the servers, but they happen during the time when you are not watching the servers. So, how can you automate performance statistics collection on all the servers around the clock so we have the statistics for 24/7/365.
2009-07-08
3,919 reads
Quite frequently I find myself in situation where I need to get detailed information on performance monitor counters. For example I need to determine which processes are consuming all CPU at certain times.
2009-04-09
3,720 reads
2008-07-31
3,052 reads
Some reasons for the slow-running of database applications aren't obvious. Occasionally, even the profiler won't tell you enough to remedy a problem, especially when a SQL Statement is being forced to wait. Now, in SQL Server 2008, come XEvents, which allow you to look at those waits that are slowing your SQL Statements. Mario Broodbakker continues his series about SQL Server Wait Events
2008-07-30
2,343 reads
By Steve Jones
During a demo of Redgate Monitor Enterprise to a customer, they asked about how...
By Rohit Garg
What is Artificial Intelligence? Understanding Predictive vs. Generative AI Artificial Intelligence (AI) is transforming...
By Steve Jones
SQL Bits 2025 was amazing, as always. It’s been my favorite conference to attend,...
Hi, Is it possible to upgrade from sql server 2008 to sql server 2022,...
Comments posted to this topic are about the item The Hidden Cost of MAXDOP:...
Comments posted to this topic are about the item The Hidden Cost of MAXDOP:...
When does Microsoft recommend using a heap as a table structure (no clustered index)?
See possible answers