Happy Monday, SQL peeps. I hope everyone had a great weekend. I, for one, had so much fun on Saturday, that I spent Sunday recovering. When did I get old? Anyway, time for another installment of SQL Server A to Z. Today we’re talking about heaps. What is a heap? A heap is a table […]
Today’s episode of SQL Server A to Z is brought to you by the letter D. D is for Dynamic Management View (DMV). DMVs were introduced in SQL 2005 as a way to provide administrators with a window into what’s going on in SQL Server at any given moment. This can range from OS statistics, […]
I want to stick with the subject of memory because I think it’s probably the most misunderstood (and sometimes downright mysterious) component of SQL Server. I know I, for one, could benefit from a better understanding of its inner workings. So today I’d like to share that little bit of code I mentioned last week, […]
My research into the Resource Governor question and its answer brought up another question for me: Where does that total_memory_kb number for the default pool actually come from? After all, I have a max server memory of 26000MB for the instance, so why 18175MB? The BOL description for this field wasn’t very helpful. Googling for […]
