The inside scoop on SQL / debugging you won't find anywhere else!
Mumbai Tech Community
SQL High Availability
SQL Server 2014
SQL Server 2016
SQL Wait Types
Browse by Tags
Spread the word!
Tagged Content List
Exotic wait types: PREEMPTIVE_OS_ENCRYPTMESSAGE
Some time ago, we were discussing wait types with a group of customers. To demonstrate the waits-and-queues methodology we use, I showed the group the sys.dm_os_wait_stats DMV, and the results were sorted by wait_time_ms in descending order. On the top of that list was the PREEMPTIVE_OS_ENCRYPTMESSAGE...
21 Jan 2015
Error message “Copying cluster-resource …fssres.dll to C:\Windows\system32\fssres.dll failed…” during SQL Server 2014 setup
First and foremost, let me reproduce the complete error message I refer to above: “Copying cluster-resource C:\Program Files\Microsoft SQL Server\MSSQL12.SQL14\MSSQL\Binn\fssres.dll to C:\Windows\system32\fssres.dll failed because the destination file exists and is read-only” Investigation I received...
12 Jan 2015
Exotic spinlocks: X_PACKET_LIST and XID_ARRAY
A Twitter conversation sparked this blog post; the question there was about the relevance of the X_PACKET_LIST spinlock. As with most spinlocks, there is no public documentation on this one, and that is primarily because the spinlock is an implementation detail and can change from release to release...
13 May 2014
“Could not add cluster access…” during SQL 2012 Failover Cluster Instance setup
Today a lab setup of SQL 2012 SP1 + CU7 (I was using the /UpdateSource flag to have a patched setup + roll in the updated bits in one go) failed sometime before creating the SQL resource in cluster. The error message from the detail.txt file showed: Could not add cluster access for SID ‘S-1-5-80-2358576813...
23 Jan 2014
Data Quality Services (DQS) and Failover Cluster instances
One of my customers made the observation that it is not possible to uncheck the Data Quality Services component in the Feature Selection screen in SQL Server 2012 setup. The interesting thing was that she clearly recalled that earlier it was possible to select it (the default was unchecked), and we wondered...
24 Jul 2013
Aviation BI Project - Part 1: Requirements
Background One of my hobbies is following the commercial aviation scene. My job requires me to fly around a lot, and that only sparks my curiosity further around how the commercial aviation business works. What better then, that to use this hobby as a motivation to test new features in SQL Server...
25 Oct 2012
Page 1 of 1 (6 items)
© 2015 Microsoft Corporation.
Privacy & Cookies