This script will give you a quick view of data or log growth events on a SQL Server instance. I occasionally use this to check what's been growing on unmonitored instances. [crayon-5c47f84ee74e3147181094/]
You can quickly check disk space info on a SQL Server host by running the query below. I sometimes find this the quickest way to check available space rather than using PowerShell or the Windows GUI. This SQL Script only work on SQL Server 2008 R2 and above. [crayon-5c47f84ee8b50532061866/] Results should return within a blink […]
If you’re restoring a large database, you can get an estimate of how long it’s going to take by running this script below. [crayon-5c47f84ee923d919190811/] As a quick alternative, you can also use sp_whoisactive to gain a rough idea of progress by viewing the percent_complete column.