Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Info
titleRefresh collection

SQL Inventory Manager allows you to refresh these metrics at any time from the instance view. For more information about this option, please refer to Viewing instance information.

Definitions

Availability Data

Availability Data refers to the instance status (up or down), instance response time, and database status (normal, suspect, offline, inaccessible or emergency mode). 

Capacity data

Capacity data refers to storage capacity of your drivers and databases of your environment. SQL Inventory Manager lets you know if your drives or databases are at risk of being full soon.

CHECKDB  Checks the logical and physical integrity of all the objects in the specified database. If corruption has occurred for any reason, the DBCC CHECKDB command will find it, and tell you exactly where the problem is.

Configuration Data

The following configuration data is collected:

  • Auto Shrink  SQL Server automatically shrinks databases to remove unused space. In some cases shrinking databases may not be the best option for your environment since it may cause fragmentation. This configuration check allows you to know if the Auto Shrink option is enabled or disabled.
  • Xp_cmdshell  Xp_cmdshell is essentially a mechanism to execute arbitrary calls into the system using either the SQL Server context (i.e. the Windows account used to start the service) or a proxy account that can be configured to execute xp_cmdshell using different credentials. When xp_cmdshell is enabled, the user could escalate his/her privileges to sysadmin. It is important to be aware which instances have the xp_cmdshell option enabled for security reasons. This configuration check allows you to know if xp_cmdshell is enabled or disabled in an instance.
  • Tempdb files  It is important to configure the files at the same initial size and with the same growth settings so SQL Server can write the data across the files as evenly as possible. The data files for tempdb should all be the same size and large enough to handle the workload of 24 hours a day. This helps SQL Server distribute the work evenly across the tempdb data files. This configuration check allows you to know if tempdb files are the same size or not.

Disaster recovery

Disaster recovery is a process to help you recover information if disaster occurs. Disaster recovery planning refers to the preparation that must occur in response to a disaster. SQL Inventory Manager provides Health Checks that give you information of your latest backups, alerting you if any of your databases have not been backed up recently.

...