SQL Server Space Monitoring with Python and PowerShell This project provides a comprehensive solution for monitoring the disk space usage of SQL Server instances. Using Python for processing and PowerShell for Email Notifications, the tool collects, analyzes, and reports on storage metrics for efficient database management.
Features Space Usage Tracking: Monitors the space used by SQL Server databases and logs. Automation with PowerShell: Automates data collection and execution of scripts. Python Analysis: Processes collected data to generate insights and formatted reports. Customizable: Adaptable to different SQL Server setups and requirements.
Prerequisites To use this project, ensure the following software and tools are installed:
Python 3.x Libraries: pyodbc, pandas, matplotlib, etc.
PowerShell Compatible with Windows environments for SQL Server automation.
SQL Server Database instances with proper permissions to retrieve metadata.