Post the results of the following two queries from BOTH servers for each instance:

select name, value, value_in_use

from sys.configurations

where name = 'affinity mask';

select

dos.scheduler_id,

dos.cpu_id,

dos.is_online,

don.cpu_affinity_mask,

don.online_scheduler_count,

don.online_scheduler_mask,

don.memory_node_id

from sys.dm_os_schedulers as dos

inner join sys.dm_os_nodes as...

cryovenom (3/15/2013)

---

This may sound like a rather basic question, but what do you mean by "you've mixed NUMA nodes in your settings"? Can two instances not use cores in the...

My guess without being able to query the system is that you've mixed NUMA nodes in your settings. The AMD 6212 would have been my last choice for a...

Grant Fritchey (3/13/2013)

---

Ha! Don't hold your breath. I still haven't received the...

Grant Fritchey (3/13/2013)

---

There are currently two drawbacks. The GUI only exists in 2012. A little bit of an issue, but you can get a GUI for 2008 from CodePlex. The...

colin.Leversuch-Roberts (1/6/2011)

---

well it's a bit of a guess but I'd say the combination of VMware and 2 cores just doesn't provide enough workers.

There's some things you could try: disable parallelism,...

You should be able to query the Memory Broker notifications and see which Broker triggered the memory notification:

SELECT

EventTime,

n.value('(Pool)[1]', 'int') AS [Pool],

...

I am pretty certain that this is the same bug reported by Aaron Bertrand here:

http://connect.microsoft.com/SQLServer/feedback/details/758984/showplan-raises-unexpected-exception-when-disallow-results-from-triggers-option-is-enabled

Hey John,

It's an easy mistake to make, but I bet it will never happen again. Ask me how I know this, I made a very similar mistake 4-5 years...

BTW:

You also need to CAST the @Success variable to VARCHAR in you concatenation code for the email body:

+ char(10) + 'Success'+CAST(@Success AS VARCHAR)

Your activation stored procedure is the problem. Before you configured the queue for activation did you test the procedure by executing it? I am going to bet not...

Send me the scripts for the Queue, Service, Event Notification, and Activation Procedure by email through my blog. Let me know what specific version of SQL Server you are...

John Esraelo-498130 (11/10/2012)

---

Hi Jonathan,

Before I ask a question I wanted to say that I really like your articles, especially in the events area.

Here is the question:

I have create a queue...

jvkondapalli (11/7/2012)

---

Gurus,

In our OLTp systems, we have a job which will capture queries running more than 1 min and report to us. The job runs every 1 minute through...

jvkondapalli (11/5/2012)

---

Gurus, I have a question regarding the 2012 Availability Groups. please consider this scenario and answer at your earliest convenience.

We have APP1, APP2. When I create Windows Server Failover...