TABLE OF CONTENTS

• Overview
• Technical Execution
• Execution Context
• Activity Detail
  • IIS Server Information Collection 
  • SQL Server Information Collection 
  • Project Script Execution Information 
  • Network and System Connectivity Checks 
  • Configuration File Validation 
  • Folder Permission Verification 
  • Storage Usage Overview 
• Further Assistance

Overview

To ensure optimal performance and stability, ManagementStudio performs an automated Server Health Check once per week. This process is designed to proactively identify potential configuration drifts, file system permission errors, or environment issues that could impact the availability of the ManagementStudio application.

Technical Execution

The health check is a localised process that runs directly on the Webserver hosting the ManagementStudio instance.

Execution Context

The check does not run as a generic system task; instead, it utilises the ManagementStudio Service Account. This is the specific identity configured within Internet Information Services (IIS) to run the ManagementStudio website and its associated Application Pool.

Activity Detail

During the health check, the system executes a series of standard Windows administrative commands to gather diagnostic data for the health report. 

IIS Server Information Collection 

• Collects OS and hardware details to verify the environment. 
• Attempts to read registry keys (may fail under restricted permissions). 
• Reads disk usage for mounted drives to ensure adequate storage. 
• Attempts to list IIS worker processes for performance monitoring. 

SQL Server Information Collection 

• Queries SQL Server version and configuration. 
• Attempts to read SQL registry keys (may fail due to permissions). 
• Retrieves schema and database storage usage. 
• Identifies the largest tables, custom form data usage, and growth trends. 
• Checks SQL backup history for recovery readiness. 

Project Script Execution Information 

• Identifies long‑running project scripts to detect performance issues. 
• Lists failing scripts with associated error messages for diagnosis. 

Network and System Connectivity Checks 

• Reads proxy configuration to confirm outbound connectivity. 
• Collects IP configuration details for network diagnostics. 
• Reads ARP and NETSTAT connection tables. 
• Identifies active network sessions, including external connection attempts. 

Configuration File Validation 

Loads appsettings.json to verify system configuration such as DB settings, URLs, authentication, and scheduler settings. 

Folder Permission Verification 

• Checks NTFS permissions for Scratch Folder and Install Folder. 
• Confirms service account has required read/write access. 

Storage Usage Overview 

• Calculates total size of file storage and log folders to track growth and detect issues. 

This activity is expected behaviour and is a core part of the product's self-diagnostic toolkit. 

Further Assistance

If you require a detailed breakdown of the specific flags these commands check, or if your security team requires further justification for these processes, please contact your ManagementStudio Consultant for additional technical documentation.