Search
Operations Manager 2007
Find Database Sizes With Operations Manager
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 [...]
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 [...]
AutoGrow Apparently Means “I Don’t Care”
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 up [...]
Uptime? You betcha.
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 better [...]
Health Service Flushing
If you are judging this post by the title, you are probably going to be surprised it is about Operations Manager 2007, and not about personal hygiene. But I came across something very useful in the OpsMgr GUI the other day and I thought I should share with those that may care.
Often times I find [...]
Operations Manager Authoring
I got excited the other day. Very excited. “Big Idea” excited. That’s right, I had a Big Idea, and in that moment of Kramer-esque Zen I could clearly see what I was destined to build with Operations Manager. Alas, in order to build it, I would need to make customizations that I was not sure [...]
Database Dump Monitoring
About a month ago I came across a wonderful idea. I thought about how I could use Operations Manager to monitor my databases to ensure they have had a backup done within a predefined amount of time. I know lots of DBAs out there that have similar checks in place, most of which involve reports [...]
PASS Update
Sorry I have been so quiet lately, but it was hard finding time to write about everything that is happening to me this week. I took some notes and plan on writing individual blog entries. Most of them should be done before the end of next week, so expect a handful (or more) of entries [...]
My Book
Categories
