Posts

Showing posts from August, 2024

Cannot enable the Service Broker in database "msdb" because the service Broker GUID in the database xxxxxx does not match the one in sys.databases.

Image
In recent past I have REBUILD system databases in SQL Server. After sometime. I tried to enable Database mail profile and to proceed with Mail Configuration. But the error message below stopped me to proceed further. Before I enable Database Mail and proceed with configuration the error message asked me to enable Service Broker first in msdb database. And below two commands fixed and enabled service broker in msdb database and allowed me to configure database mail configuration. ALTER DATABASE msdb SET NEW_BROKER WITH ROLLBACK IMMEDIATE ; ALTER DATABASE msdb SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE ;

sp_WhoIsActive

--Tempdb contention and blocking EXEC sp_WhoisActive @ sort_order = '[tempdb_current] DESC' , @ get_plans = 1 , @ Output_Column_List = '[start_time][session_id][sql_text][query_plan][wait_info][temp%]' ; GO EXEC sp_Whoisactive @ find_block_leaders = 1 , @ sort_order = '[blocked_session_count] DESC' , @ get_plans = 1 , @ Get_additional_info = 1 , @ Output_Column_list = '[start_Time][session_id][sql_text][query_plan][wait_info][block%][additional_info]' ; go EXEC sp_Whoisactive @ get_avg_time = 1 , @ Get_outer_Command = 1 , @ Get_plans = 1