Archive for the ‘System Center 2012’ Category

DPM Installation Error ID:820

Saturday, April 19th, 2014

 

When you install DPM 2010, right after the prerequisites  verification you receive an error  “Verify that Windows Management Instrumentation (WMI) Service is running. if…

image

in order to fix this issue, you need to reinstall WMI , this is how to do it

From an elevated Command Prompt

1. Disable and stop the WMI service.

sc config winmgmt start= disabled

net stop winmgmt

2. Rename the Repository folder under C:\Windows\System32\wbem to Repository.old

3. Run the following commands.

Winmgmt /salvagerepository %windir%\System32\wbem

4. Re-enable the WMI service and then reboot the server to see how it goes.

sc config winmgmt start= auto

Management Pack Development Training

Thursday, April 17th, 2014

System Center 2012 R2 Operations Manager Management Pack

 

 

image

Microsoft Azure Brazil South region is now in public preview.

Thursday, April 17th, 2014

 

image

DPM 2012 R2 Support Windows 2003 server

Thursday, April 17th, 2014

 

Don’t be surprise , DPM 2012 R2 doesn’t support Windows server 2003 ,   the rollup update is coming shortly and it will fix the issue.

I know if Shreesh said that it will happen :)

image

Do I need to run maintenance on MY SCOM DBs ?

Thursday, April 17th, 2014

 

This question came from Momo my DBA Friend, I have SCOM 2012 installed , what kind if maintenance Plan I need to run, Momo meant DBCC check, Index rebuild etc..

my answer nothing , you don’t need to run any maintain on SCOM DBs and the  reasons are the following :

1- there is a rule name “Optimize Indexes” that execute a daily database maintenance it calls a Store Proc name “p_OptimizeIndexes” , by default the rule runs once a day  at 2:30 AM , you can change the time (Configuration Tab,View DS  ),

image

the index optimization Store Proc has the following

image

SCOM Management Pack for SQL Server Analysis Services

Thursday, April 17th, 2014

 

There is always something new , in the System Center area,  there is a new SQL Server Analysis Services released early January 2014

it supports the following :

1- SCOM 2012 and later

2- Virtualized SSAS instances

3- Clustered SSAS instances

Download the MP 

From Microsoft web site :

System Center Management Pack for SQL Server 2008 Analysis Services

System Center Management Pack for SQL Server 2012 Analysis Services

Monitoring Pack Purpose

Monitors Scenarios

1- SSAS Instance monitoring

2- SSAS Database monitoring

3- SSAS Partition monitoring

Health Rolls Up :

image

a well detailed article please visit Oleg’s Blog

ldm threshold reached in DPM

Thursday, April 17th, 2014

 

The Issue started with the ldm threshold reached and we had to delete all the protection group and recreate then.

Due to this mass deletion of protection group. The pressure on the garbae collection job mounted as it had to delete lot of objects from sql database.

Now whenever the garbage collection job ran it increased the size of the tempdb which would consume almost all the space on the drive.

In order to find what query the garbage collection gets stuck we used this script.

image

the result Was:

image

Ran the garbage collection job along with this script and waited for tempdb to grow abnormally.

We got following output from the powershell script.

image

to fix the issue :

image

A huge credit to Abhishek   from the DPM Support Team

this is just a snapshots , from the resolution , if you get this error , don’t try to run the query on your own, i really recommend to contact MSFT support

OPSMGR execution of CLR code

Thursday, April 17th, 2014

if you just installed SCOm m, and received the following ERRO , this is because CLR is not enabled  on your SQL Server

image

in order to resolve this issue , run the following command in SQL server that host your SQL server DBs

image

DPM 2012 R2 Installation ERROR

Thursday, April 17th, 2014

 

DPM 2012 R2 doesn’t come anymore with SQL server , you either have to install an instance of SQL server in the same Machine , or use a remote SQL server to host the Database

During  the  installation of DPM 2012 R2 you may receive the following Error

SNAGHTML23e560d5

the cause of the error that DPM  need to have reporting server with HTTPS configured , in order to resolve this issue you need to Configure SSRS with HTTPS ()

image

DPM Backup Summary Report

Wednesday, April 9th, 2014

Another clever work around for reporting from Steve

available at the Gallery : http://gallery.technet.microsoft.com/DPM-Backup-Summary-Report-4533bcc6

The DPM Backup Summary Report is a free SSRS based report that you can load in your DPM environment. This report works with DPM 2010 and DPM 2012/R2. For now the report is only for disk and tape based backups. In the future we are looking to extend this in the future to show online (Azure) as well. The features and data points contained in the report are:

  • Ability to select day, week, month (Time range)
  • Ability to select a single server or many
  • Ability to select a single protection group or many
  • Ability to select disk, tape or both backup type
  • Summary of the backup success and failures with a percentage of the successes (Success Rate/SLA)
  • Health trend of backups (day, week, month)
  • Backup detail including:Individual data sources (What was actually backed up)
    •      The status including the error (if there is an error)
    •      Date and time the backup was created
    •      How much data was transferred during the backup
    •      Total time it took to backup to complete

More information about the report here: http://www.buchatech.com/2014/04/free-dpm-backup-summary-report/

Screenshot of the report: