A timeout (30000 milliseconds) was reached while waiting for a transaction response from the MSSQLSERVER service

Disclaimer:Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses. ISSUE: A timeout (30000 milliseconds) was reached while waiting for a transaction response from the MSSQLSERVER service. Follow the best link which I have found on search.   http://blog.sqlauthority.com/2016/08/15/sql-server-timeout-30000-milliseconds-reached-waiting-transaction-response-mssqlserver-service/ https://blogs.msdn.microsoft.com/psssql/2010/07/21/why-does-preemptive_os_getprocaddress-show-a-large-accumulation/ https://support.microsoft.com/en-us/kb/3126587 Continue reading A timeout (30000 milliseconds) was reached while waiting for a transaction response from the MSSQLSERVER service

Get SQL Server agent Service Stopped Mail Notification

Implementation: Get a mail alert via powershell when SQL server agent service gets stopped. Scenario: When SQL server agent service gets stopped,its dependence jobs,DR,operators,DB mail,replication failed to succeed.In these case,you can have a mail alert which will notify whenever agent service gets stopped by triggering mail to provided mail id via windows powershell. Infrastructure:The below query/steps have been run/tested successfully on SQL server 2005,2008,2008 R2 and 2012. Steps: … Continue reading Get SQL Server agent Service Stopped Mail Notification