Browse by Tags

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

on 12 Nov 2012
Blog Post: SQL Server: Correlating Timestamps From Various Data Points

SQL Server Support Content

I was looking at data from a customer, in a different time zone (UTC+1) from mine, this week involving SQL Server AlwaysOn (HADRON) and found that lining up the timestamps in the various logs was challenging. Some times are local to the SQL ...read more

on 11 Sep 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

on 20 Dec 2012
Blog Post: Every time I ‘ATTACH DATABASE’ SQL logs error 1314 for SetFileIoOverlappedRange

SQL Server Support Content

Turns out this is an issue in the SQL Server code and the error is a bit noisy during attach database. When opening the database files, SQL Server calls SetFileIoOverlappedRange (when enabled properly) in order to help improve I/O performance. This ...read more

on 16 Oct 2013
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

on 5 Sep 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

on 11 Dec 2012
Blog Post: T-SQL Update Takes Much Longer Than The Matching Select Statement

SQL Server Support Content

I realize the title is generic and that is because the problem is generic. On the surface it would not surprise me that an update takes longer than a select. (A little bit anyway.) There is logging, updates to index rows, triggers, replication ...read more

on 21 Sep 2012
Blog Post: Strange Sch-S / Sch-M Deadlock on Machines with 16 or More Schedulers

SQL Server Support Content

Since it took me several days to track down this bug, and I did learn a couple of new things along the way, I thought I would share some of my work. 16 or More CPUS When a system presents SQL Server with 16 or more CPUs, and you are using a high end SQL ...read more

on 31 Aug 2012
Blog Post: When Does sp_prepare Return Metadata

SQL Server Support Content

I was running an RML Utilities Suite test pass and encountered varying behavior from our sp_prepare suite. Here is what I uncovered. The command sp_prepare returns (or does not return) metadata depending on the server version. For the client ...read more

on 23 Jul 2013
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

on 14 Dec 2012
Blog Post: Change Data Capture gets disabled when you break mirroring and bring the database online

SQL Server Support Content

Issue ================ Recently we encountered an issue where customer performed a planned failover for a mirrored database and after the failover the new principal went into suspect mode because of some reason (which is outside the scope ...read more

on 15 May 2013
Blog Post: How to monitor deadlock using extended events in SQL Server 2008 and later

SQL Server Support Content

Before I talk about how to monitor the deadlocks let us have a small brief what is deadlock and how we were handling them in the previous versions of SQL Server. Deadlock : A deadlock occurs when there is a cyclic dependency between two or more threads ...read more

on 27 Apr 2013

Products

Resources

Solutions

Updates

Trials

Related Sites

Training

Certifications

Other resources

Support options

More support

Not an IT pro?

SQL Server KBs and Blogs

Browse by Tags

Blog Post: How Can Reference Counting Be A Leading Memory Scribbler Cause?

Blog Post: SQL Server: Correlating Timestamps From Various Data Points

Blog Post: SQLCLR and sp_OA* procedures are not compatible

Blog Post: Every time I ‘ATTACH DATABASE’ SQL logs error 1314 for SetFileIoOverlappedRange

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

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: T-SQL Update Takes Much Longer Than The Matching Select Statement

Blog Post: Strange Sch-S / Sch-M Deadlock on Machines with 16 or More Schedulers

Blog Post: When Does sp_prepare Return Metadata

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

Blog Post: Change Data Capture gets disabled when you break mirroring and bring the database online

Blog Post: How to monitor deadlock using extended events in SQL Server 2008 and later