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 …

Continue reading Get SQL Server deadlock graph instantly on mail when it occurs

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 …

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

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 …

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