Can I install SQL Server 2012 Standard Edition to run in a server with more than 4 sockets or more than 16 cores? Are there any limitations?

I’ve found myself answering these questions more than three times only during the the last week. All those questions coming from very different people with different profiles. Some being our customers, some being partners, and even from some coworkers. Such repetitive question definitely deserves an attempt to answer it through a post over here. First…

4

Another dirty trick played by an antivirus

A PFE colleague from Italy, recently exposed the following situation in an internal distribution list: From: <removed_to_protect_identities> Sent: Wednesday, July 18, 2012 8:36 AM To: <removed_to_protect_identities> Subject: Report hanging when rendering on IE9 Hi there, I am browsing a set of reports on RS2008 Sp3 with Internet Explorer 8 and IE9. When browsing with IE8,…

1

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

What’s the maximum level of recursion for the hash iterator before forcing bail-out?

This is a question I was asked recently whose answer I had to look in the code because it wasn’t documented anywhere. So, I’ll use this mean to propagate that piece of knowledge. The value is a constant, hard coded in the product, and its value is five (5). This means that before the hash…

1