Get SQL Server deadlock graph instantly on mail when it occurs

Note:  Best viewed in Internet Explorer 6 and above Implementation: How to get SQL Server deadlock graph instantly on mail when deadlock occurs. Scenario:Lets say,there is one site where you have been deployed and you face deadlock on SQL server mostly.Now you want  to receive mail immediately with complete deadlock graph when SQL Server deadlock occurs. Infrastructure: Below queries and processes are tested with SQL server2005,2008,2008 R2,2012 and … Continue reading Get SQL Server deadlock graph instantly on mail when it occurs

How to send mail notification when SQL blocking occurs more than a defined time

Note:  Best viewed in Internet Explorer 6 and above Implementation:Sending mail alerts on SQL blocking queries details when particular query blocks other query by more than a defined time let say 2,3.. minutes. Scenario:Lets say,there is one site where you have been deployed and you face blocking on SQL server all the time.Now your TL want you to send mail notification only when there is blocking … Continue reading How to send mail notification when SQL blocking occurs more than a defined time

How to get sp_readerrorlog output into table and sending mail in html format.

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. Implementation: Sending html format mail to recipients of ‘sp_readerrorlog’ in sql server. Scenario:Lets say,Client wants to get the output of ‘sp_readerrorlog’ on mail with proper html and understandable format  and  you are asked to carry out this … Continue reading How to get sp_readerrorlog output into table and sending mail in html format.