Brendan Gregg
FEBRUARY 28, 2023
This talk originated from my updates to [Systems Performance 2nd Edition], and this was the first time I've given this talk in person! CXL in a way allows a custom memory controller to be added to a system, to increase memory capacity, bandwidth, and overall performance. Ford, et al., “TCP
SQL Performance
APRIL 26, 2019
If so, you may have heard about the Azure SQL Database DTU calculator , and you may have also read about how it has been reverse engineered by Andy Mallon. Do not expect the data to start flowing into the tables immediately; this will take time to make its way through the system. PerformanceAnalysisDataDatabaseCounter.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
SQL Performance
MARCH 15, 2021
In my last post , I illustrated one reason you should stop using deprecated system tables like sysprocesses. Since SQL Server 2012 (and, to a much lesser extent, since SQL Server 2008), the most complete and flexible solution for monitoring events on a SQL Server instance has been Extended Events.
Brendan Gregg
FEBRUARY 28, 2023
This talk originated from my updates to Systems Performance 2nd Edition , and this was the first time I've given this talk in person! CXL in a way allows a custom memory controller to be added to a system, to increase memory capacity, bandwidth, and overall performance. Ford, et al., “TCP
SQL Server According to Bob
JUNE 22, 2016
Keep in mind that the vast majority of CMemThread objects (SQL 2005, 2008, 2008 R2, 2012, 2014, Azure DB and 2016) are not partitioned. Recommendation Unchanged: Prior to SQL Server 2016 enable –T8048 on larger systems. A few are partitioned by NUMA node and fewer by CPU during their creation.
SQL Server According to Bob
JANUARY 26, 2017
Transparent Data Encryption (TDE) is a feature that was introduced in SQL Server 2008 (and is also available for Azure SQL Database, Azure SQL Data Warehouse, and Parallel Data Warehouse) with the purpose of encrypting your data at rest. For more information about the tempdb system database, see tempdb Database.
SQL Performance
JUNE 21, 2019
This article will expand on my previous article and point out how these apply to SQL Server , Azure SQL Database , and Azure SQL Managed Instance. I always check backups first when looking at a new system. Azure SQL Database and Azure Managed Instance have managed backups. Memory settings. Statistics. DBCC CHECKDB.
Expert insights. Personalized for you.
110 
Let's personalize your content