There are multiple instance that whenever I am seeing
xp_sysmail_activate running in SQL Server, DB performance is degrading. Whenever I kill the process, the database can't recover and restarting SQL Service does not help either so I have no choice but to restart the server. In relation to this, I do have questions
- what exactly is this extended procedure doing that causes performance issue
- any logs or area in SQL Server that I can look at to better understand this issue and troubleshoot (either using SQL Server Management Studio or TSQL)
- any alternative to killing this process that will not require server restart?
Microsoft SQL Server 2012 - 11.0.2100.60 (X64) Feb 10 2012 19:39:15 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.0 <X64> (Build 6003: Service Pack 2) (Hypervisor)