I was asked last week if knew a query that would return the size of the databases that have been discovered by Operations Manager. I went about digging through some old queries I put together and found the information that was requested.
Inside the OperationsManager database look for a view named MTV_Database. All discovered databases will [...]
Operations Manager 2007
What Time Is It?
Joe the DBA sent me the usually morning email, detailing the failed custom collections in Operations Manager. I had asked for Joe to do this routinely so that we could monitor our monitoring system, as any good DBA with OCD would do. With our recent push for server consolidation I have been spending more time [...]
Another tip at MSSQLTips
I had a tip published over at MSSQLTips yesterday and wanted to drop a quick post to brag tell people about it. The tip is very straightforward, it uses xp_fileexist to verify if your database dumps are still on disk or not.
Keep in mind that xp_fileexist is one of those undocumented stored procedures, which is [...]
Operations Manager 2007 Introduction Video
On more than one occasion I have seen or heard a DBA ask a common question about Operations Manager 2007: “How do I know it is working?” Last week I spent time with Brent Ozar to put together a video on how to navigate your way around OpsMgr. Brent was a perfect choice to have [...]