sp_send_dbmail - database mail
EXEC msdb.dbo.sp_send_dbmail
@recipients = ‘me@myemail.com’,
@query = ’sp_configure ”max server memory”
GO
sp_configure ”min server memory”
GO
select left(counter_name,50),cntr_value from sys.dm_os_performance_counters
where counter_name in (”Target Server Memory (KB)”,”Total Server Memory (KB)”)
and object_name = ”SQLServer:Memory Manager”’,
@subject = ‘DEMO - MEMORY UPGRADE’,
@attach_query_result_as_file = 1 ;
