something like this

-----------------------------

USE [msdb]

GO

EXEC msdb.dbo.sp_update_alert @name=N'Blocked',

@message_id=0,

@severity=0,

@enabled=1,

@delay_between_responses=0,

@include_event_description_in=0,

@database_name=N'',

@notification_message=N'',

@event_description_keyword=N'',

@performance_condition=N'SQLServer:General Statistics|Processes blocked||>|1',

@wmi_namespace=N'',

@wmi_query=N'',

@job_id=N'2656affe-1a04-482a-a1ac-51152174669a'

GO

------------------------------------------------

EXEC sp_WhoIsActive

@find_block_leaders = 1,

@output_column_list=

'[start_time][sql_text][session_id][login_name][CPU][blocking_session_id][reads][writes][wait_info][open_tran_count][database_name][blocked_session_count]',

@format_output = 0,

@destination_table = 'WhoIsActive';

 

---

EXEC msdb.dbo.sp_send_dbmail

@recipients='ABC@ibm.com',

@profile_name = 'MPAXCluster',

@subject = 'Who Is Active',

@body_format = 'TEXT',

@query = 'SELECT TOP 1

RIGHT(start_time,8)

,session_id

,right(login_name,20)

,RIGHT(CPU,20)

,blocking_session_id

,blocked_session_count

,RIGHT(wait_info,25)

,substring(sql_text,1,200)

FROM [WSDBA].[dbo].[whoisactive]

order...

Set up a blocking alert, when the alert fires off it should call SP_whoisactive. Dump the results into a temp table or Perm table and have it send you an...

you are correct I was really trying to solve the mystery of resource-list why it showed nothing. Fixing the underlying issue is something all together different. It just so...

Solved!

<SyncPoint> is an indication of an Exchange event. If you run profiler trace with deadlock graph it will clearly show its and exchange dead lock(...

Here is the whole output...maybe this might help

<deadlock>

Thanks Chris, That makes a little more CENTS$
I'll give a try as soon as it blocks again and report back

Thanks, I the screen shot is not to good but its sp_whoisactive with leadblocker

Thanks for the help Jeff, Thats what I thought as well.

I should have explained better, the Problem is the D: & 01-abc-01c share are the same location.

The goal is to...

Maintenance plans and AG work. I have had this problem before as well.

Try secondary only in the Ag Group and "copy-only backups" in the maintenance plan.

and yes when is fails...

According to microsoft "For availability groups, statistics that are created and maintained on the primary databases are automatically persisted on the secondary databases as part of applying the transaction log...

Thanks for the help!

yes...the C node is a 2 node cluster. so I will need to blow it up so that it is no longer a cluster.

Take one of the servers make it...

Sounds I like I need to break the C node down to a stand alone server and then add the node to the ALWAYS ON cluster.

Thanks guys....

Nothing in the error logs? strange(At this point I am just guessing I broke it)

The subscriber just disappeared. Added NC indexes and the next day I have no...

Find the Sql server agent job that the maintenance plan created. It should be the same name with a . subplan after it.

Right click and Look at the history. It...