Gathering VMWare Metrics
Anytime that you a large environment, gathering metrics in any form can be daunting and cumbersome. Using scripting languages can usually greatly improve the efficiency of this process as well as be more accurate. Whether it’s VMWare, SQL Server, or some other platform, it would behoove you to see what scripting languages it may support. […]
Function Fn_PageResCracker Internals
In a previous blog post, I discussed two new methods to determine exactly which page a request might be waiting for when there is contention. One of these new methods involves a new function, fn_pagerescracker. Naturally, I wanted to see how this function operates. Let’s look at the Master database to investigate how it works! […]
New Page Functions in SQL Server 2019
I will be the first to admit that I am what one might call a “SQL Head”. In other words, I’m a nerd that likes to dig into the internal workings of SQL Server, sometimes down to the bits and bytes. The tools to facilitate this archaeology have slowly been evolving and with the release […]
SQL Server Data Pages on Linux
One of the new phrases coming out of Microsoft is that “SQL is just SQL” regardless of what operating system it resides on. This was echoed during the keynote at SQL Bits 2019 by the Microsoft team, which you can watch here. Later that weekend, I gave a session about database internals. My presentation is […]