Welcome to TechNet Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL   (RSS)

Everything you wanted to know about OpsMgr Data Warehouse Grooming but were afraid to ask

I know there are already quite some other blog posts about OpsMgr Data Warehouse Grooming. But I was helping a customer with grooming their OpsMgr Data Warehouse Database (OperationsManagerdw) and got some questions. And you may have the same questions

My Operations Manager 2007 SQL Queries

Jonathan Almquist started a blog post about Operations Manager 2007 SQL Queries . “I’m starting a new post here, similar to my Command Shell reference . This will include some useful SQL queries that I happen to need and direct my customers to on a daily
Posted by stefstr | 1 Comments
Filed under: , ,

Reblog: Using Operations Manager Reports to Validate Your Uptime

Source: Simple-Talk Thomas LaRock has written an article about using OpsMgr Reports to Validate (your SQL components) uptime. Check it out. You can also follow Thomas LaRock ( @sqlbatman ) on Twitter if you want.
Posted by stefstr | 0 Comments
Filed under: , ,

OpsMgr SQL Full or Differential Backup Check

I helped a customer creating a OpsMgr Monitor for checking if the there has been a SQL Full or Differential Backup within a specified number of hours. David Scheltens created the SQL query. This is how you could create this kind of monitor in your own

Designing a new Report for OpsMgr 2007

Some time ago Jonathan Hambrook has written an article about Designing a new Report in SCOM 2007 . Although this is great article you need to have some prerequisites ready to get started with Designing your new OpsMgr 2007 Reports. Here are the prerequisites:
 
Page view tracker