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 … Read more
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 … Read more
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 … Read more
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 … Read more
Well, at least that is the impression I have from Operations Manager. Let me explain why. It all started around the time we were making some adjustments to one of our servers that was not performing as well as our end users would have liked. The short end of that story is that we ended … Read more
Just thought I would share some info from Operations Manager that shows the amount of uptime on our servers here since 1/1/2008. Why? Well, since I am the official DBA of Uptime, a distinction that many have questioned, it felt right to provide some numbers. I am sure many others will be able to provide … Read more
