Encrypted text in Profiler for unencrypted modules

A colleague came up with this situation: ************ I am tracing some SQL activity on a SQL 2008 R2, Enterprise SP2 64-bit server. In the profiler trace, I keep seeing Encrypted Text in the textdata column for procedures that are clearly plain text and are not encrypted. Though, I do notice in certain scenarios, where…


How do you explain that sys.dm_os_spinlock_stats.backoffs keeps increasing and no sqlos.spinlock_backoff event is produced?

A PFE colleague from the UK approached me yesterday with the following concern: Hi Nacho, I may need to find out the call stacks when a spinlock backoff occurs at a customer tomorrow. So I found this script from a SQLCAT article: http://sqlcat.com/sqlcat/b/msdnmirror/archive/2010/05/11/resolving-dtc-related-waits-and-tuning-scalability-of-dtc.aspx create event session lock_hash_spin on server add event sqlos.spinlock_backoff (action (package0.callstack) where…

1

Reason why the SLOTS XECustomizableAttribute of package0.synchronous_bucketizer & package0.asynchronous_bucketizer seem to be interpreted incorrectly?

Some friends of mine and I were trying to build some monitoring leveraging the XE bucketizer targets. During the exercise, we encountered that the value we were specifying in the SLOTS attribute was not exactly what was being used in the end. For example, we ran this one event session definition: CREATE event session LockCounts…