ManageEngine® SQLDBManager Plus


Database Details

<< Prev

Home

Next >>

 

SQL Server - Database and Mirroring Details

 

Click to know the metrics monitored for:

SQL Server - Database Mirroring Details

SQLDBManagerPlus provides the option to monitor mirroring details of SQL databases. You can monitor attributes like Mirroring role, Status, Mirroring partner details,Witness details, Unsent log available in Send Queue, Current send rate, Time to restore log and more.

 

Parameters

Description

Mirroring Details

  • Mirroring Role - Displays the role of the mirroring database. The possible values are:
    • Principal
    • Mirror.
  • Mirroring Status - Displays the status of mirroring process. The possible values are Synchronized, Synchronizing, Suspended, Pending failover, Disconnected.
  • Transaction Safety - Displays whether the mirroring operates in synchronous or asynchronous mode.
  • Mirroring Partner - Displays the server name of the mirroring partner.
  • Mirroring Partner Connection - Displays the connection string of the mirroring partner server.
  • Witness Status - Displays the status of witness connection. The possible values are Connected, Unknown, Disconnected.
  • Witness Connection - Displays the connection string of the witness server.
  • Witness Address - Displays the name of the witness server
Principal Log
  • Unsent Log (in KB) - Displays the unsent logs that are in the Send Queue.
  • Oldest Unsent Transaction (DD:HH:mm:ss) - Displays the estimated time of transaction pending in the Send Queue.
  • Time to send log (DD:HH:mm:ss) - Displays the estimated time that takes to send the log to the mirror server.
  • Current Send Rate - Displays the current send rate in KB/Sec.
  • Current Rate of new transactions - Displays the rate of new transactions entered in the principal server in KB/Sec.

Mirror Log

  • Unrestored log - Displays the amount of log waiting in the redo queue in KB/Sec.
  • Time to restore log (DD:HH:mm:ss) - Displays the estimated amount of time that takes to restore the log to the mirroring database.
  • Current restore rate - Displays the current restore rate in KB/Sec

Mirroring session

  • Mirror Commit Overhead - Displays the amount of overhead incurred in milliseconds while the principal server instance waits for the mirror server instance to write the transaction's log record into the redo queue.
  • Time to send and restore log (DD:HH:mm:ss) - Displays the time needed to send and restore the transactions committed in the principal database.
Mirroring Performance Counters For Principal database :
  • Logs Sent KB/Min - The number of logs sent per minute.
  • Log Send Queue KB - Total kilobytes of log that have not yet been sent to the mirror server.
  • Average Delay/Transaction (ms) - The delay (in milliseconds) in waiting for commit acknowledgement from the mirror. This reports the approximate delay for a single transaction in process at that time.

For Mirror database :

  • Logs Redo KB/Min - The amount of transaction log applied on the mirror database per minute.
  • Redo Queue KB - Total kilobytes of hardened log that remain to be applied to the mirror database to roll it forward.

 

SQL Server - Database Details

Parameters

Description

Database Disk Utilization
  • Total MB - Displays the total the total disk space of all available data files(in MB).

  • Used % - Displays the percentage of used disk space.

  • Used MB - Displays the total disk space used by all data files (in MB).

  • Free % - Displays the percentage of free/unused disk space.

  • Free MB - Displays the free/unused disk space (in MB).

  • Growth % - Displays the percentage at which all data files grow.

Data File Details

  • File Name - Name of the data file.

  • Total MB - Displays the total disk space of all available data files(in MB).

  • Used % - Displays the percentage of used disk space.

  • Used MB - Displays the total disk space used by all data files (in MB).

  • Free % - Displays the percentage of free/unused disk space.

  • Free MB - Displays the free/unused disk space (in MB).

  • Growth % - Displays the percentage at which all data files grow.

  • Growth Rate - Displays the rate at which the data files grow.

  • Maximum size - The maximum size (in MB) up to which the data file can grow.
Log File Details
  • File Name - Name of the log file

  • Total MB - Displays the total the total disk space of all available log files(in MB).

  • Used % - Displays the percentage of used disk space.

  • Used MB - Displays the total disk space used by all log files (in MB).

  • Free % - Displays the percentage of free/unused disk space.

  • Free MB - Displays the free/unused disk space (in MB).

  • Growth % - Displays the percentage at which all log files grow.

  • Growth Rate - Displays the rate at which the log files grow

  • Maximum size - The maximum size (in MB) up to which the log file can grow

  • Log Cache Hit Ratio - Displays the log cache hit ratio file size.

  • Number of VLFs – Displays the number of VLFs (Virtual Log Files) created. A transaction log is split internally into smaller chunks called virtual log files. A large number of VLFs can cause degradation in performance when transaction log backups occur or in any transaction log related activities.

VLF Details


Clicking on the Number of VLFs will pop up and show the details of about virtual log files within the physical transaction log.

  • FileID - Physical log file identifier from sysfiles


  • FileSize - Virtual log file size ( in bytes )


  • StartOffset - Beginning point of the virtual log file


  • FSeqNo - Virtual log file's sequence number


  • Status - Whether the virtual file contains the active part of the transaction log. 0 means that virtual file does not contain the active portion of the log and it is available for log use ; 2 means that VLF is active


  • Parity - Parity information for virtual log file


  • CreateLSN - Log sequence number that began the virtual log file. (click here for more info)

Database Details
  • Creation Date - Date in which the Database was created


  • Database Mode - The recovery model for the database which shows how transactions are logged.

Transaction Details
  • Transactions/Min - Number of transactions started for the database per minute


  • Replication Transactions/Min - Number of replication transactions per minute


  • Bulk Copy Rows/Min - Number of rows bulk copied


  • Bulk Copy Throughput/Min - Amount of KiloBytes bulk copied


  • Backup/Restore Throughput/Min - Read/write throughput for backup/restore of a database


  • Log Cache Reads/Min - Reads performed through the log manager cache


Log Flush Details
  • Log Flush/Min - Number of log flushes


  • Log Flush Waits/Min - Number of commits waiting on log flush


  • Log Flush Wait Time - Total wait time (milliseconds)

 

In addition, SQLDBManager Plus displays the more in-depth performance metrics such as System Tables, Table Relationship, User Tables etc of the selected database in a pop-up window.

 

Parameters

Description

System Tables

  • System Table Name - Name of the System Table.

  • Total Rows - Total number of rows present in that table.

  • Total Space Used in MB - Size of the table (MB).
Table Relationship
  • Parent Table – Table which contains the primary / parent column for the foreign key.

  • Parent Column – The primary column for which a foreign exists.

  • Foreign Table – Table name of foreign key column.

  • Foreign Column – The foreign key column name.
User Tables
  • System Table Name - Name of the User Table.

  • Total Rows - Total number of rows present in that table.

  • Total Space Used in MB - Size of the table (MB).
View Details
  • View Name - Name of the View.

  • Schema Name - Schema Name to which this view is associated.

  • IsIndexed - Shows if there is an index for the view ( 1 = Index Present, 0 = No Index ).

  • IsIndexable - Shows whether an index can be created ( 1 = Index can be created, 0 = No Index can be created ).

  • Create Date - Date on which the view was created.

  • Modify Date - Date on which the view was last modified.
Index Details
  • Table Name - Name of the Table.

  • Index Name - Name of Index present in the table.

  • Maximum Size Row - Maximum size for a row in that table (in bytes).

  • Max Noleafindex Row - Maximum size of a nonleaf index row (in bytes).

  • File Group Name - Name of the filegroup (Primary or User-defined).

  • Column Name - Name of the column for which index is present.

  • Type - Data type of the Column.

  • Clustered Index - Shows if the index is a Clustered Index or not (Yes or No). A clustered index determines the physical order of data in a table.
Indexes that have not been used
  • Object Name – Name of the table in which the index is present.

  • Index Name – Name of the index which is not used.

  • Type – Type of the Index.
Fragementation Details
  • Table Name - Name of the table in which the index is present

  • Index Name - Name of Index present in the table

  • Fragmentation Percent - Percentage of Logical fragmentation present in the Index. This is the percentage of out-of-order pages in the leaf pages of an index. The Percentage of Fragmentation should be as close to zero as possible for maximum performance. However, values from 0% through 10% may be acceptable
Indexes that have been used
  • Object Name – Name of the table in which the index is present.

  • Schema Name – Schema Name to which this table is associated.

  • Index Name – Name of the index which is not used.

  • Type – Type of the Index.

  • User Seeks - The number of seeks in this index by user queries.

  • User Scans - The number of scans in this index by user queries.

  • User Lookups - The number of bookmark lookups in this index by user queries.

  • User Updates - The number of updates in this index by user queries.

Note: The data file details of the database are updated once in an hour. You can also manually update each data file of the database by clicking on the 'Update Data File'.

 


<< Prev

Home

Next >>

Database

Replication Details