SQL Server Analyzer
Website: https://sg-soft.eu/sql-analyzer/
The tool scans all SQL Servers and collects important information and metrics that are analyzed and displayed in a user-friendly interface. The recommendations are based on best practices. Suitable for consultancy services and entire database environment analytics.
OVER ALL RESULTS
Top 10 CPU Utilization
Top 10 Memory Utilization
Top 10 – Disk Latency
Top 10 – Performance Counters
Top 10 – Waits and Queues
Security
Startup Parameters
Instance Level Configuration
File(s) Growth Configuration
Offline Databases
Database Page Verify
Database Compatibility Level
Database Recovery Model
Auto Create Statistics OFF
Databases without Recent Backups
Databases without Recent Integrity Checks
Virtual Log Files
Missing Alerts
Services and Features with Keys
Check for Product Updates
Server Inventory
Machine overview
Database Options
Database Files Options
Configuration
Check ‘sa’ accounts enabled or not
Check ‘sa’ account active connections
Number of Sysadmins
SQL Server Agent Status
SQL Server Agent Operators
Cycle Error Log
SQL Server Startup Parameters
Instance-Level System Configuration
Automatic soft-NUMA disabled
Backup Checksum Default
Backup Compression enabled
Clr enabled
Cost Threshold of parallelism
Database Mail XPs
Default Trace enabled
Max Degree of Parallelism
Max Server Memory
Min Server Memory
Optimized for ad hoc Queries
Remote Admin Connections
xp_cmdshell
Default SQL Server File Path
Database File Size and Growth
Database Options
Trace Flags
Alerts
Recent Backups
Recent Integrity Checks
Performance
Service Status
Start Time SQL Server
Any Blocked Processes
Any Free Disk Space Issues
Any File Growth in Progress
Any Restricted Files and/or Fully Filled
CPU Utilization
CPU Visibility
Memory Utilization
Currently Active Sessions
Performance Counters
Waits and Queues
Disk Latency per Drive
Disk Latency per Database
Disk IO Throughput per Database
CPU Utilization per Database
Memory Utilization per Database
Top 5 Costliest Queries
Virtual Log Files
Index Fragmentation
Missing Indexes
Unused Indexes
Duplicated or Similar Indexes
Statistics
Licensing
Features
Analysis Services
Reporting Services
Integration Services
Cpu
Memory
Max Database Size
Log Shipping
Database Mirroring
Backup Compression
Failover Cluster
AlwaysOn Availability Groups
Online Indexing
Online Schema Change
Fast Recovery
Hot add Memory and Cpu
Encrypted Backup
Hybrid Backup Azure
Resource Governor
Partitioned Tables
Buffer Pool Extension
Read Ahead
Transparent Data Encryption
Extensible Key Management
Transactional Replication
SQL Profiler
SQL Agent
Tuning Advisor
Policy Automation
Performance and Collector
Auto Indexed Views Maintenance
Distributed Indexed Views
Parallel Indexed Operations
Parallel Consistency Checks
SQL Server Data Tools
MDX Tools
External Scripts Enabled
Service Broker
T-SQL Endpoints
Proposal by Grouping Features
Proposal by Features
In questa pagina del sito puoi guardare il video online SQL Server Analyzer della durata di ore minuti seconda in buona qualità , che l'utente ha caricato SG-Soft ltd 29 ottobre 2020, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 421 volte e gli è piaciuto 5 spettatori. Buona visione!
