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-5bee3762b8b24834414582/]
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-5bee3762b9901326216205/] Results should return within a blink […]
If you’re restoring a large database, you can find an estimate of how long it’s going to take by running the script below. [crayon-5bee3762b9e70499028873/] As a quick alternative, you can also use sp_whoisactive to gain a rough idea of progress by viewing the percent_complete column.