Page History
...
Microsoft 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.
IDERA SQL Inventory Manager provides a Health Check to let you know if the Auto Shrink option is enabled or disabled.
...
Capacity data refers to the storage capacity of your drives and databases in your environment. IDERA SQL Inventory Manager lets you know if your drives or databases are at risk of being full soon.
...
Refers to the server that hosts a SQL Server, this maybe a physical or virtual server. IDERA SQL Inventory Manager gathers configuration, capacity, and performance data for SQL Server instance host servers, also known as "Servers.".
Configuration data
IDERA SQL Inventory Manager performs the following configuration data checks:
...
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. IDERA 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.
...
The location refers to the physical or geographical location of an instance, such as Houston for example. IDERA SQL Inventory Manager allows you to add this information to the instance that you are registering so you can later filter and get details or graph views for the instances belonging to this location.
...
The owner refers to the user whom the instance belongs to. When you register an instance, IDERA recommends that you register the instance owner, so later you can easily get information from this owner and his/her respective instances.
Performance data
IDERA SQL Inventory Manager measures performance data such as CPU% usage, Memory % usage, Disk IO, and Network IO.
...
It is important to configure the tempdb files with the same initial size and with the same growth settings so that Microsoft 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 workload for 24 hours. This configuration helps SQL Server distribute the work evenly across the tempdb data files.
IDERA SQL Inventory Manager provides a Health Check to let you know if tempdb files are the same size or not.
...
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.
IDERA SQL Inventory Manager provides a Health Check to let you know if the xp_cmdshell is enabled or disabled in an instance.
...