System Administration

View SQL Server Health Charts

These charts display current data used to monitor system performance, to troubleshoot memory issues, or to assist in performance tuning.
This dashboard contains the following charts:

View the Database: Current Connections Chart

Use the Database: Current Connections page to view databases currently connected to the Stewardship Tier because of file reads, writes, executing processes or other factors.

To access this chart in System Administration, select Admin > Resources > SQL Server Health > Database: Current Connections in the Navigation pane.

View the Database: Current Requests Chart

Use the Database: Current Requests page to view information about each database request per session ID that is executing within the SQL server environment.

To access this chart in System Administration, select Admin > Resources > SQL Server Health > Database: Current Requests in the Navigation pane.

View the Database: File Sizes Chart

Use the Database: File Sizes page to view the size in kilobytes of the database file and database log file for each database associated with a data source in the Stewardship Tier. This information can help track file size growth that can impact system performance.

To access this chart in System Administration, select Admin > Resources > SQL Server Health > Database: File Sizes in the Navigation pane.

View the Database: File Reads Chart

Use the Database: File Reads page to view the percentage of total files read, broken out by database, since the SQL Server database was last active. Hover over a section for a record count. Each section lists log reads and file reads for the selected database. Restarting SQLServer will reset these values.

To access this chart in System Administration, select Admin > Resources > SQL Server Health > Database: File Reads in the Navigation pane.

View the Database: File Writes Chart

Use the Database: File Writes page to view the percentage of total file writes being performed to data or log files, broken out by database, since the SQL Server database was last active. Hover over a section for a record count. Each section lists log writes and file writes for the selected database. Restarting SQLServer will reset these values.

To access this chart in System Administration, select Admin > Resources > SQL Server Health > Database: File Writes in the Navigation pane.

View the Database: Memory Overview Chart

Use the Database: Memory Overview page to view a breakdown of memory usage (in megabytes) on the database server by available RAM and Total RAM, page and available page. Since a lack of available memory will cause locking and slowdown in performance, this data can be used to monitor system performance and assist in performance tuning and troubleshooting.

To access this chart in System Administration, select Admin > Resources > SQL Server Health > Database: Memory Overview in the Navigation pane.

Page Memory Usage

The page memory information is derived from the field total_page_file_kb from the following view:

https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-os-sys-memory-transact-sql?view=sql-server-ver15 .

For more information, refer to Microsoft's SQL Server documentation.

RAM Usage

Assuming the database server is only running SQL Server and a Windows operating system (OS), there must be at least 32GB of Total RAM and 5-10GB of Available RAM.

SQL Server runs best when consuming all available RAM on the database server, leaving just enough for the Windows OS to run comfortably (I consider "just enough" to be 5-10GB). Each instance of SQL Server has both a lower limit and upper limit that can be specified for memory usage. If no upper limit is specified, then it will eventually consume all the RAM on the database server. This is not usually a problem, but according to Microsoft, it can slightly slow the Windows OS.

For more information, refer to the Syniti Solutions Software Requirements and Hardware Sizing Guide.