article thumbnail

The Return of the Frame Pointers

Brendan Gregg

2005-2023: The winter of broken profilers However, the change was then applied to x86-64 (64-bit) as well, which had sixteen registers and didn't benefit so much from a seventeenth. The overhead to walk DWARF is also too high, as it was designed for non-realtime use. The actual overhead depends on your workload.

Java 145
article thumbnail

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

​​ With new ​​ innovations ​​ come ​​ new terms, designs, ​​ and ​​ algorithms. The ​​ SQL Server 2000 I/O Basics ​​ document is a prerequisite to ​​ the information contained in this ​​ document.

Servers 40
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

Why Waits Alone Are Not Enough

SQL Performance

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. Since CPU and IO consumption translate directly to server hardware and cloud spend, this is significant. Most Queries Don't Wait.

Tuning 115
article thumbnail

SQL 2016 – It Just Runs Faster Announcement

SQL Server According to Bob

My development collogues and I are starting a regular blog series, outlining the vast range of scalability improvements, allowing SQL Server 2016 to run across a wide array of hardware configurations, faster and better than previous releases of SQL Server. Where SOS_RWLock is used, no matter the SKU, the new design applies.