Browse by Tags

Tagged Content List

Blog Post: SQL Server–Storage Spaces/VHDx and 4K Sector Size

SQL Server Support Content

This blog outlines a new twist to my previous blog outlining issues with 4K sector sizes. SQL Server - New Drives Use 4K Sector Size: http://blogs.msdn.com/b/psssql/archive/2011/01/13/sql-server-new-drives-use-4k-sector-size.aspx In the previous post ...read more

on15 May 2013
Blog Post: SQLIOSim Checksum Validations

SQL Server Support Content

I had a very specific question asked of me related to the SQLIOSIM.exe, checksum validation logic. It is pretty simple logic (on purpose) but effective so here are the basics. The key is that there are multiple memory locations used to hold the ...read more

on5 Apr 2013
Blog Post: Don’t change value of that parameter

SQL Server Support Content

Parameter sniffing is a well known among SQL User community. But I have seen variations of this frequently that need a bit creative handling and solution may not that straight forward. One of the variation is that a user changes the value ...read more

on3 Feb 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: SQLCLR and sp_OA* procedures are not compatible

SQL Server Support Content

We ran into an issue today that is a bug you may need to be aware of because of its behavior. When a SQLCLR procedure calls back into the SQL Server (in proc provider) and executes sp_OA*, during the callback activity, it triggers a bug (currently ...read more

on20 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 Can Reference Counting Be A Leading Memory Scribbler Cause?

SQL Server Support Content

The concept of the memory scribbler comes up quite a bit in support. The term can often be over used but I ran into a specific example that commonly fools people, including support engineers. The random nature and even the resulting ...read more

on12 Nov 2012

SQL Server KBs and Blogs

Browse by Tags

Blog Post: SQL Server–Storage Spaces/VHDx and 4K Sector Size

Blog Post: SQLIOSim Checksum Validations

Blog Post: Don’t change value of that parameter

Blog Post: How It Works: CMemThread and Debugging Them

Blog Post: SQLCLR and sp_OA* procedures are not compatible

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 Can Reference Counting Be A Leading Memory Scribbler Cause?

Products

Resources

Solutions

Updates

Trials

Related Sites

Training

Certifications

Other resources

Support by product

Other support links

Not an IT pro?