SMPdiag (version 0.1.1357)

Article:TECH202997  |  Created: 2013-02-20  |  Updated: 2014-08-07  |  Article URL http://www.symantec.com/docs/TECH202997
Article Type
Technical Solution

Issue



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.


Environment



Target SMP 7.1 SP2 MP1

Compatible with SMP 7.1 - 7.5 SP1


Solution



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


Attachments

SMPDiag.exe (3.9 MBytes)


Article URL http://www.symantec.com/docs/TECH202997


Terms of use for this information are found in Legal Notices