For technical questions about the internal workings of the database engine.

learn more… | top users | synonyms

2
votes
0answers
358 views

SQL Server Internal Memory Pressure

I am trying to identify the cause of internal memory pressure. From what I have learned, Resource Monitor Ring Buffer returns an indicator for internal pressure. For example by using this query, ...
1
vote
0answers
87 views

Page Header DB Frag ID Property

I am using SQL Server version: Microsoft SQL Server 2012 - 11.0.2100.60 (X64). I created a single table containing one and only one integer-valued column. I then added one and only one row to the ...
0
votes
0answers
21 views

If I were to peak under the hood, how does MySQL's GET_LOCK function work?

I am curious about how MySQL's GET_LOCK function actually works. I understand what it means when I ask for a lock, and what the potential return values are. But I want to get a better understanding ...
0
votes
0answers
117 views

Page count differences between sys.dm_db_index_physical_stats and sys.allocation_units

In doing research for index maintenance, I found some significant differences between the page counts reported by sys.dm_db_index_physical_stats and sys.allocation_units in some of the clustered ...