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.
The SMPDiag is designed to save time maintaining, tuning, and diagnosing common concerns with implementing the Symantec Management Platform.
Diagnose common issues
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
For all checks to work correctly it must be run from the Notification Server
x64 based Operating System
.NET 3.5 Framework
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
Select the desired ‘Categories’ and press the oversized play button in the upper left corner or Run Tests in the left hand pane.
Enter valid database credentials and click test. This will verify the connection and provide a dropdown list of available databases.
Select the appropriate database and change the timeout if desired then click OK
Main page detailed
begins the testing process
feature allows you to look for text that exists in the (Details, SQL and Test Name)
Provides links to Save results, Change settings etc
Takes you to an associated KB with additional information
refresh's a single test instead of rerunning everything
Gives a quick indication of potential impact of the test
Is a clickable link to the details page for each test
A quick easy way to provide feedback to Symantec about the usefulness of the test or tool.
Additional Data is provided
Gives a more detailed description of the check and results
Gives more detailed results from the check that was run
Opens the Notification Server console to a related page