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

Who, ME, an almighty Sysadmin getting a permission denied error?

This is the story of someone who claimed to be a member of the sysadmin fixed server role and, when he tried to run one stored procedure through a session in which any of the different settings that instruct the relational engine that the user is interested in retrieving the execution plan in one of…


Which database and language the domain user goes by default when is a member of multiple windows groups, and these groups have logins created in SQL with different default databases and languages?

When a domain user is in multiple Windows groups, and these group logins have a different default databases (and different language) on the same instance, and there is no login for the Windows user account, how does SQL Server decide which database (and which language) the domain user should go by default? It basically depends…

4

What’s in PREEMPTIVE_OS_FILEOPS wait type?

This one wait type is one of the many hundreds which came up new with SQL Server 2008. As my colleague Denzil Ribeiro found in the code, this one in particular is one that accounts the time SQL Server threads have waited for file system operations to complete. SQL Server workers switch preemptive before calling…

1

GetDataSourceContents will always return null for the Password member of the instance of DataSourceDefinition it returns

Even though current and past versions of the documentation have never explicitly said so, for obvious reasons the password is no returned . In fact there is no public SSRS API that can return passwords in stored credentials. Just to let you know until the documentation is improved to include that information. By reflecting the…

1

Adjusting the maximum number of worker threads per SQL Server Agent’s subsystem when processors are added or removed from the machine after the instance of SQL Server was installed

Inside MSDB, there exists a system table named dbo.subsystems which is populated the first time SQL Server Agent services runs. Every time SQL Server Agent starts up, among the several things it does, it interrogates the contents of that table to find out what subsystems are enabled and how they are configured. To do so,…

4

Reason for the mismatch between sys.dm_os_memory_nodes.virtual_address_space_committed_kb and aggregated sys.dm_os_memory_clerks.virtual_memory_committed_kb by memory_node_id

A PFE colleague presented the following scenario and asked for the justification of what seemed to be, a priori, something inexplicable. The story was like this: When I check the memory allocation using memory nodes and memory clerks DMVs the total amount of committed VM reported is a bit different. I can see similar difference…

1