drag matrix into design pane select report data
, drag month_name into rows
, drag physical_year into columns
, drag member_cnt into data.
Preview. When happy build and deploy

matrix view in SSRS

orignial data rows view

source: https://docs.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2016?view=sql-server-2017

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/basic-availability-groups-always-on-availability-groups?view=sql-server-2017

https://docs.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2016?view=sql-server-2017

0xC004706B Source: Data Flow Task DTS.Pipeline Description: “component “OLE DB Source” (1)” failed validation and returned validation status “VS_NEEDSNEWMETADATA”, more than likely the column mapping in the data flow is broken due to change to table column data type or stored procedure return dataset

select b.name, a.last_execution_time
from sys.dm_exec_procedure_stats a 
inner join sys.objects b on a.object_id = b.object_id 
where DB_NAME(a.database_ID) = 'MyDatabase'

• Transactional replication. For more information, see Transactional Replication.
• Merge replication. For more information, see Merge Replication.

• Snapshot replication. For more information, see Snapshot Replication.

  The type of replication you choose for an application depends on many

https://www.wikihow.com/Turn-Off-the-Pop%E2%80%90Up-Blocker-in-Internet-Explorer

try this one

1.

check the waits

SELECT * FROM sys.dm_os_wait_stats
WHERE wait_type IN (‘CLR_AUTO_EVENT’, ‘CLR_CRST’, ‘CLR_JOIN’, ‘CLR_MANUAL_EVENT’
, ‘CLR_MEMORY_SPY’, ‘CLR_MONITOR’, ‘CLR_RWLOCK_READER’, ‘CLR_RWLOCK_WRITER’, ‘CLR_SEMAPHORE’
, ‘CLR_TASK_START’, ‘CLRHOST_STATE_ACCESS’, ‘ASSEMBLY_LOAD’, ‘FS_GARBAGE_COLLECTOR_SHUTDOWN’
, ‘SQLCLR_APPDOMAIN’, ‘SQLCLR_ASSEMBLY’, ‘SQLCLR_DEADLOCK_DETECTION’, ‘SQLCLR_QUANTUM_PUNISHMENT’)
ORDER BY wait_time_ms DESC, wait_type ASC;

check the wait type explanation

Wait statistics, or please tell me where it hurts

checking each wait type explain

3.

index fragmentation

SELECT
    *
   ,wait_time_ms/waiting_tasks_count AS 'Avg Wait in ms'
FROM
   sys.dm_os_wait_stats 
WHERE
   waiting_tasks_count > 0
ORDER BY
   wait_time_ms DESC

https://social.msdn.microsoft.com/Forums/en-US/02385e50-a048-435e-ac53-d8ca2b19932e/what-is-waiting-in-waiting-tasks-in-activity-monitor?forum=sqldatabaseengine

SELECT OBJECT_NAME(ind.OBJECT_ID) AS TableName,
ind.name AS IndexName, indexstats.index_type_desc AS IndexType,
indexstats.avg_fragmentation_in_percent
FROM sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL, NULL) indexstats
INNER JOIN sys.indexes ind
ON ind.object_id = indexstats.object_id
AND ind.index_id = indexstats.index_id
WHERE indexstats.avg_fragmentation_in_percent > 35
ORDER BY indexstats.avg_fragmentation_in_percent DESC

4. MS

High waits on CLR_MANUAL_EVENT and CLR_AUTO_EVENT