I have seen a few cases where there is poor query performance using the Network Summary Dashboard and decided to investigate because of Errors displayed.
NSD1.JPG
A few items to investigate:
·         BIOS – High performance power setting enabled
·         OS – High performance power setting selected
·         Remote Query Timeout Setting
·         MAX Worker Threads
·         MAX Degree of Parallelism (MAX DOP) = 1

 ·        SQL Profiler stating high CPU Stored Procedures coming from the Network Summary Dashboard

Since this was a VM, I didn’t need to investigate BIOS settings although it is always nice to do on the hosts themselves.  I understand that power efficiency settings in the BIOS reduce the frequency at which a CPU can operate as well as other performance factors.
 
Then, I changed MAX Worker threads to 576 (per the Microsoft Article Below) and set MAX DOP = 1.  I restarted the SQL Engine, then restarted the SSRS service on the Report Server.
 
I have enabled these settings at other client sites and haven’t noticed poor performancce difference in reporting or other operations.
MAX WT – http://msdn.microsoft.com/en-us/library/ms190219.aspx
MAX DOP – http://msdn.microsoft.com/en-us/library/ms189094.aspx
 MAX Worker Threads.jpg

I am now able to populate the Network Summary Dashboard!!

NSD2.JPG
ERROR:
Microsoft.EnterpriseManagement.Presentation.DataAccess.DataProviderException: An error occurred executing the command: [Microsoft.EnterpriseManagement.Presentation.DataProviders.Library!NetworkDashboardProvider/GetCurrentTopInterfacesByPerformance] in provider: [Microsoft.EnterpriseManagement.Presentation.DataProviders.NetworkDashboardProvider, Microsoft.EnterpriseManagement.Presentation.DataProviders.Library, Version=7.0.5000.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]. : Unable to execute stored procedure needed for dashboard.  If you just installed Operations Manager Reporting Server, please wait a while and try again.  This can also occur if the Operations Manager Reporting Server SQL Server is not started or inaccessible. —> Microsoft.EnterpriseManagement.Presentation.DataProviders.DataWarehouseException: Unable to execute stored procedure needed for dashboard.  If you just installed Operations Manager Reporting Server, please wait a while and try again.  This can also occur if the Operations Manager Reporting Server SQL Server is not started or inaccessible. —> Microsoft.EnterpriseManagement.Common.UnknownDatabaseException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
The statement has been terminated.
   at Microsoft.EnterpriseManagement.Common.Internal.ServiceProxy.HandleFault(String methodName, Message message)
   at Microsoft.EnterpriseManagement.Common.Internal.MonitoringDataWarehouseServiceProxy.GetDataWarehouseStoredProcedureResult(String SpName, StoredProcedureParameterCollection param, IEnumerable1 columnFilter, Int32 timeout)
   at Microsoft.EnterpriseManagement.Warehouse.DataWarehouse.GetDataWarehouseData(String storedProcedureName, StoredProcedureParameterCollection param, IEnumerable
1 columnFilter, Int32 timeout)
   at Microsoft.EnterpriseManagement.Presentation.DataProviders.NetworkDashboardProvider.GetCurrentTopInterfacesByPerformance(DateTime startDateTime, IDataObjectCollection performanceCounterArray, Boolean sortAscending, Int32 numEntities)
   — End of inner exception stack trace —
   at Microsoft.EnterpriseManagement.Presentation.DataProviders.NetworkDashboardProvider.GetCurrentTopInterfacesByPerformance(DateTime startDateTime, IDataObjectCollection performanceCounterArray, Boolean sortAscending, Int32 numEntities)
   — End of inner exception stack trace —
   at Microsoft.EnterpriseManagement.Presentation.DataAccess.DataProviderCommandMethod.Invoke(CoreDataGateway gateWay, DataCommand command)
   at Microsoft.EnterpriseManagement.Presentation.DataAccess.CoreDataGateway.ExecuteInternal[TResult](DataCommand command)
   at Microsoft.EnterpriseManagement.Presentation.DataAccess.CoreDataGateway.<ExecuteAsync>b__0[TResult](<>f__AnonymousType0`1 data)