Train for your certification. Learn the latest DevOps tools. Grow your skillset to do better work.
At Linux Academy, we release new training modules every week so you'll always be up to date on the latest tech.
DECLARE @kill as varchar(100), @body as varchar(5000), @AlertSummary as varchar(1200), @Timestamp as varchar(1200), @Instance as varchar(1200) set @kill = @kill + 'kill ' + SUBSTRING( $(AlertSummary) , 11, CHARINDEX(' ', $(AlertSummary) ,12) -11); set @body = cast(@kill as varchar(15)) + '; ' + 'A SQL process with '+ $(AlertSummary) + ' at ' + $(Timestamp) + ' on ' + $(Instance) + '. ' +' As the tempdb storage it used has reached a limit, this SQL query has been killed'; EXEC msdb.dbo.sp_send_dbmail @profile_name = 'noreply', @recipients = '<email>', @body = @body, @subject = 'Testing: A SQL query using too much tempdb database has been killed'
$(Timestamp), $(Metric) on $(Instance) is $(Severity). $(AlertText) $(Metric): $(Description)
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.