Browse by Tags

Tagged Content List

Blog Post: How It Works: Always On–When Is My Secondary Failover Ready?

SQL Server Support Content

I keep running into the question: “When will my secondary allow automatic failover?” Based on the question I did some extended research and I will try to summarize in is blog post. I don’t want to turn this post into a novel so I am ...read more

on22 Apr 2013
Blog Post: How It Works: CMemThread and Debugging Them

SQL Server Support Content

The wait type of CMemThread shows up in outputs such as sys.dm_exec_requests. This post is intended to explain what a CMemThread is and what you might be able to do to avoid the waits. The easiest way to describe a CMemThread is to talk about ...read more

on20 Dec 2012
Blog Post: How It Works: SQL Server (NUMA Local, Foreign and Away Memory Blocks)

SQL Server Support Content

The NODE an operating system page, physically belongs to can be acquired using the QueryVirtualMemoryEx Windows API. SQL Server uses this API to track locality of memory allocations. This blog is a very high level view of SQL Server behavior but ...read more

on13 Dec 2012
Blog Post: How It Works: SQL Server 32 bit PAE/AWE on (SQL 2005, 2008, and 2008 R2) – Not Using As Much RAM As Expected!

SQL Server Support Content

This issue was puzzling until we stepped through the code and studied it in some detail. The report was “SQL Server won’t use the physical memory I expect it to use.” Scenario: SQL Server 2008 R2, 32GB RAM - SQL only using ~22GB ...read more

on11 Dec 2012
Blog Post: How It Works: Gotcha: *VARCHAR(MAX) caused my queries to be slower

SQL Server Support Content

The scenario: Table has a NTEXT column that the customer wanted converted to NVARCHAR(MAX) Data has both small and large storage for different rows Issued ALTER TABLE … ADD COLUMN …NVarCharColumn… NVARCHAR(MAX) Issued update MyTable set NVarCharColumn ...read more

on3 Dec 2012
Blog Post: How It Works: SQL Server AlwaysOn Lease Timeout

SQL Server Support Content

The lease is used between the SQL Server resource DLL and the SQL Server instance to prevent split-brain from occurring for the availability group (AG). The lease is a standard signaling mechanism between the SQL Server resource DLL and the SQL Server ...read more

on7 Sep 2012
Blog Post: How It Works: Online Index Rebuild - Can Cause Increased Fragmentation

SQL Server Support Content

SQL Server Books Online alludes to the fragmentation possibility but does not fully explain that the Online Index rebuilding may increase fragmentation when it is allowed to run with MAX DOP > 1 and ALLOW_PAGE_LOCKS = OFF directives . The process of ...read more

on5 Sep 2012

SQL Server KBs and Blogs

Browse by Tags

Blog Post: How It Works: Always On–When Is My Secondary Failover Ready?

Blog Post: How It Works: CMemThread and Debugging Them

Blog Post: How It Works: SQL Server (NUMA Local, Foreign and Away Memory Blocks)

Blog Post: How It Works: SQL Server 32 bit PAE/AWE on (SQL 2005, 2008, and 2008 R2) – Not Using As Much RAM As Expected!

Blog Post: How It Works: Gotcha: *VARCHAR(MAX) caused my queries to be slower

Blog Post: How It Works: SQL Server AlwaysOn Lease Timeout

Blog Post: How It Works: Online Index Rebuild - Can Cause Increased Fragmentation

Products

Resources

Solutions

Updates

Trials

Related Sites

Training

Certifications

Other resources

Support by product

Other support links

Not an IT pro?