Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!
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)
|Sql Join Problem||2||32|
|SQL Server merge records in one table||2||12|
|Find data in a column which is not in a date format||29||18|
|Create formula that divides total amount by 30 or 31 depending on what month of the year it is looking at||5||11|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
17 Experts available now in Live!