Using the "Database Health" tab with SSETools

Products

• IT Management Suite

Issue/Introduction

You want to see if there are some areas that could be reviewed for database performance improvements.

You want to do a quick check by using the SSETools ( KB 150132 )

Environment

ITMS 8.x

Resolution

With the SSETool, you should be able to connect to your database server and run a "Database Health" check.

1. Download the SSETools.exe file and run it on your SMP Server or SQL Server.
2. Click on "Health" tab and clieck on "Database Health"
   
   
   
   
3. Then, click on "Connect" button. Add the proper SQL Server information, click on "Connect" and select our database.
   
   
   
   
4. After you connect to the SQL Server, click the "play" button and it will report back your current "Configuration" (review the KB 178476 for suggested settings) and if you click on "Performance" tab, it should display a couple of tabs with reported information.
   
   
   
   
5. We would suggest you take a look at these tabs:
   • Index Fragmentation (if most are close to 99% fragmentation, try to implement suggestions under KB 158633 “SQL Maintenance script for the Symantec Management Platform database”)
   • Membership Update Duration (see if the filters that are taking the longest are custom ones or not. If so, check the logic on your filters and see if those are using tables where the Indexes are too fragmented and/or uses Stored Procedures that seems to be taking too long under the "Stored Procedures Stats" tab)
   • Stored Procedure Stats (see if there are some that seems to be executing continuously or taking too long, or using most CPU time, etc)
   • Potential New Indexes (this one should provide some suggestions on new Indexes for tables that are used the most. These are not required to be implemented but are given as a reference to DBAs for consideration)
     
     
     
     
6. There are other tabs that you could review as needed for general idea of what else can be a performance consideration.