SQL Server Monitoring

SysGauge Ultimate allows one to monitor one or more Microsoft SQL Servers locally of via the network. In order to add an SQL Server monitor press the 'Add' button located in the top-left corner of the window and select the 'SQL Server Monitor' menu item. The SQL Server monitor provides the ability to monitor the SQL index search rate, SQL transaction rate, SQL cache hit ratio, SQL full scan rate, SQL probe scan rate, SQL range scan rate, SQL page lookup rate, SQL page read rate, SQL page write rate, SQL total memory, SQL database page count and the amount of used SQL log space.

SysGauge SQL Server Monitor

The user is provided with the ability to save SQL server monitoring reports into a number of standard formats including HTML, PDF, Excel, CSV, text and XML. In order to save an SQL server monitoring report, press the 'Save' button located on the main toolbar, select an appropriate report format, enter a report title and press the 'Save' button.

SysGauge SQL Server Monitor Report

For example, a PDF report includes the list of SQL server monitoring counters showing the average, minimum and maximum values for each counter and a number of line charts showing how the performance of the monitored SQL server was changing over time.

SQL Server Monitoring Counters

In addition to the dedicated SQL Server monitor, the user can use the customizable 'System Monitor' module to configure user-custom SQL Server monitoring profiles. In order to add an SQL Server monitoring counter, press the 'Monitor' button located on the main toolbar, selected the 'SQL Server' counters category in the left-side view and then select an appropriate SQL Server monitoring counter in the middle view. By default, SysGauge will monitor all SQL databases in the target SQL Server, but if required, the user can select a specific SQL database to monitor in the right-side view. In addition, in order to monitor a remote SQL Server via the network, press the 'Connect' button located in the bottom-left corner and specify the host name or an IP address of the remote computer to monitor.

SysGauge SQL Server Monitoring Counters
  • SQL Server Logical Connections - this counter monitors the number of currently active logical SQL server connections.
  • SQL Server User Connections - this counter monitors the number of currently active SQL Server user connections.
  • SQL Server Login Rate - this counter monitors the SQL Server login rate, which is displayed in logins per second.
  • SQL Server Logout Rate - this counter monitors the SQL Server logout rate, which is displayed in logouts per second.
  • SQL Server Full Scan Rate - this counter monitors the rate of SQL Server scan operations, which is displayed in scans per second.
  • SQL Server Probe Scan Rate - this counter monitors the rate of SQL Server probe scan operations, which is displayed in scans per second.
  • SQL Server Range Scan Rate - this counter monitors the rate of SQL Server range scan operations, which is displayed in scans per second.
  • SQL Server Index Search Rate - this counter monitors the rate of SQL Server index search operations, which is displayed in searches per second.
  • SQL Server Page Allocation Rate - this counter monitors the rate of SQL Server database page allocations, which is displayed in pages per second.
  • SQL Server Page Split Rate - this counter monitors the rate of SQL Server database page split operations, which is displayed in pages per second.
  • SQL Server Page Deallocation Rate - this counter monitors the rate of SQL Server database page deallocations, which is displayed in pages per second.
  • SQL Server Connection Memory - this counter monitors the amount of SQL Server connection memory, which is displayed in MB.
  • SQL Server Database Cache Memory - this counter monitors the amount of SQL Server database cache memory, which is displayed in MB.
  • SQL Server SQL Cache Memory - this counter monitors the amount of SQL Server SQL cache memory, which is displayed in MB.
  • SQL Server Lock Memory - this counter monitors the amount of SQL Server lock memory, which is displayed in MB.
  • SQL Server Log Pool Memory - this counter monitors the amount of SQL Server log pool memory, which is displayed in MB.
  • SQL Server Max Workspace Memory - this counter monitors the amount of SQL Server max workspace memory, which is displayed in MB.
  • SQL Server Optimizer Memory - this counter monitors the amount of SQL Server optimizer memory, which is displayed in MB.
  • SQL Server Free Memory - this counter monitors the amount of SQL Server free memory, which is displayed in MB.
  • SQL Server Stolen Memory - this counter monitors the amount of SQL Server stolen memory, which is displayed in MB.
  • SQL Server Target Memory - this counter monitors the amount of SQL Server target memory, which is displayed in MB.
  • SQL Server Total Memory - this counter monitors the amount of SQL Server total memory, which is displayed in MB.
  • SQL Server Background Write Rate - this counter monitors the SQL Server background write rate, which is displayed in pages per second.
  • SQL Server Cache Hit Ratio - this counter monitors the SQL Server database cache hit ratio, which is displayed in percents.
  • SQL Server Database Pages - this counter monitors the number of SQL Server database pages.
  • SQL Server Page Lookup Rate - this counter monitors the rate of SQL Server database page lookup operations, which is displayed in pages per second.
  • SQL Server Page Read Rate - this counter monitors the rate of SQL Server database page read operations, which is displayed in pages per second.
  • SQL Server Page Write Rate - this counter monitors the rate of SQL Server database page write operations, which is displayed in pages per second.
  • SQL Server Target Pages - this counter monitors the number of SQL Server target database pages.
  • SQL Server Active Transactions - this counter monitors the number of currently active SQL Server transactions.
  • SQL Server Data Files Size - this counter monitors the size of SQL Server data files, which is displayed in MB.
  • SQL Server Log Space Used - this counter monitors the amount of used SQL Server log space, which is displayed in percents.
  • SQL Server Transactions Rate - this counter monitors the rate of SQL Server transactions, which is displayed in transactions per second.
  • SQL Server Write Transactions Rate - this counter monitors the rate of SQL Server write transactions, which is displayed in transactions per second.