SMPdiag (version 0.1.1387)

Products

• Management Platform (Formerly known as Notification Server)

Issue/Introduction

This application has been created by support’s EPM SWAT team. The designer’s goal is to bring scripts available in tech articles and other areas into a single summary panel. It is a work in progress. Most of the SQL behind the test can be found from other tech articles in the knowledgebase. The code has been consistently updated as the SWAT team finds bugs and new tests. This is only meant to supplement the current support and diagnostic process.

Please use this at your own discretion.

Important Note: Currently our goal is to publish a new version every Thursday if new content has been added.  Depending on when it is added it may be a week or more before a test is added once we have initially been informed of a problem.

Resolution

The SMPDiag is designed to save time maintaining, tuning, and diagnosing common concerns with implementing the Symantec Management Platform.

Features

• Optimize settings
• Diagnose common issues
• Easy searching
• Auto Updates if internet connection is available
• Details are provided and SQL code for all checks, letting you know exactly what is being evaluated
• Able to adapt and add checks quickly
• Noninvasive, it does not make any changes
• Thumbs up and down provide an easy way to give feedback
• Can be run from any system *
  *Some features only work when run from the Notification Server

Requirements

• For all checks to work correctly it must be run from the Notification Server
• x64 based Operating System
• .NET 3.5 Framework
• SQL permissions
  • SELECT on the object 'sysmaintplan_logdetail', database 'msdb', schema 'dbo. For the Maintenance Plan Status test, used to see if maintenance is being run
  • EXECUTE on xp_servicecontrol, database mssqlsystemresource. For the last Data Base backup test, to verify that backups are being created.
  • Part of the processadmin role
    • CXPacket test, used to help determine MAXDOP settings
    • OptimizeForAdHocWorkloads test, used to see if the setting is enabled
    • Potential Index test, used to help isolate indexes that could benefit specific environments.

 

Using the tool

1. Select the desired ‘Categories’ and press the oversized play button in the upper left corner or Run Tests in the left hand pane.
    
2. Enter valid database credentials and click test. This will verify the connection and provide a dropdown list of available databases.
   
3. Select the appropriate database and change the timeout if desired then click OK

Main page detailed

 

1	Play button	begins the testing process
2	Search	feature allows you to look for text that exists in the (Details, SQL and Test Name)
3	Menu bar	Provides links to Save results, Change settings etc
4	Content section
	KB Link	Takes you to an associated KB with additional information
	Refresh	refresh's a single test instead of rerunning everything
	Severity icon	Gives a quick indication of potential impact of the test
	Test description	Is a clickable link to the details page for each test
	Thumbs	A quick easy way to provide feedback to Symantec about the usefulness of the test or tool.
5	Status Bar	Additional Data is provided

Details page

 

1	Details pane	Gives a more detailed description of the check and results
2	Results pane	Gives more detailed results from the check that was run
3	Console Link	Opens the Notification Server console to a related page
4	KB Link	Clickable link to the KB
5	SQL Code	Copies SQL code if applicable to the clipboard

 

Applies To

Compatible with SMP 7.1 - 8.1