SMPdiag (version 0.1.1387)
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.
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.
- 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
|
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