Besides the SQL Server Assessment Intelligence Pack, you can also use Log Management functionality to collect the ‘Application’ event log from your SQL Servers and monitor activity from it with search. For example, this is my simple recipe for finding SQL Backup Failures Type=Event EventID=3041 EventLog=Application Source=MSSQLSERVER That’s it. I can see in my workspace… Read more
"Corporate" Blog of Daniele Muscetta, Premier Field Engineer.
Since the release of System Center 2012 R2 Preview (and more after GA was announced) a lot of people asked me why did we rename the Operations Manager agent to “Microsoft Monitoring Agent”? Some information that went out together with the GA of SC2012R2 can be found at the following link: http://technet.microsoft.com/en-us/library/dn465154.aspx And here is… Read more
Warning for people who landed here: this post is VERY OLD. It was written in the early days of struggling with OpsMgr 2007, and when nobody really knew how to do things. I found that this way was working – and it surely does – but what is described here is NOT the recommended way… Read more