Archive

Archive for November, 2010

Hyper-V Resource Control

November 30, 2010 1 comment

Virtual Machine Reserve (percentage) – this value says how much CPU is kept aside for the running Virtual Machine.

Percent of total system resources – this is a precent of a Virtual Machine processor time, that is measured by how many processors are assigned to the virtual machine

Virtual Machine Limit (percentage) – this is a percent of CPU that the running Virtual Machine is not allowed to go over the top of

Percent of total system resources – this is percent of a VM processor time, that is measured by how many processors are assigned to the physical computer

Relative Weight – this is used to decide how CPU is distributed. (Basically a virtual machine with the higher weight (say 500) will get twice the CPU time as a virtual machine with a weight lower weight (say 400).

Example:

Basically on a 1 CPU and 4 Core computer you can run 40 1 CPU Virtual Machines if their reserve is 10%.

-Eric

Source: MS TechNet Forums.

Advertisements

SCE 2010 Reporting, Essentials Reports not working

November 18, 2010 3 comments

Date: 18/11/2010 16:53:44
Application: System Center Essentials
Application Version: 7.0.2432.1
Severity: Error
Message: Cannot initialize report.

Microsoft.Reporting.WinForms.ReportServerException: An error has occurred during report processing.
(rsProcessingAborted) —> Microsoft.Reporting.WinForms.ReportServerException: Query execution failed for dataset ‘StatusList’.
(rsErrorExecutingCommand) —> Microsoft.Reporting.WinForms.ReportServerException: The SELECT permission was denied on the object ‘fnUpdateInstallationStateMap’, database ‘SUSDB’, schema ‘PUBLIC_VIEWS’.
— End of inner exception stack trace —
— End of inner exception stack trace —
at Microsoft.Reporting.WinForms.ServerReport.GetExecutionInfo()
at Microsoft.Reporting.WinForms.ServerReport.GetParameters()
at Microsoft.EnterpriseManagement.Mom.Internal.UI.Reporting.Parameters.ReportParameterBlock.Initialize(ServerReport serverReport)
at Microsoft.EnterpriseManagement.Mom.Internal.UI.Console.ReportForm.SetReportJob(Object sender, ConsoleJobEventArgs args)
Microsoft.Reporting.WinForms.ReportServerException: Query execution failed for dataset ‘StatusList’.
(rsErrorExecutingCommand) —> Microsoft.Reporting.WinForms.ReportServerException: The SELECT permission was denied on the object ‘fnUpdateInstallationStateMap’, database ‘SUSDB’, schema ‘PUBLIC_VIEWS’.
— End of inner exception stack trace —
Microsoft.Reporting.WinForms.ReportServerException: The SELECT permission was denied on the object ‘fnUpdateInstallationStateMap’, database ‘SUSDB’, schema ‘PUBLIC_VIEWS’.

If you get this error when you try to access your essentials reports under Reporting there is a quick and easy way to fix it.

Solution:

  • Open your SQL Management Studio.
  • Then browse to SUSDB database and select it, right click and select properties.
  • Under properties select permissions. There should be only 3 entries, which are Domain\Username, NT Authority\Network Service and COMPUTERNAME\WSUS Administrators. You want Domain\Username user, so select that one.
  • Under Explicit tab scroll down until you see Select. Tick it under Grant and press OK. Now go and try to run your reports again.

-Eric