All SQL Server data modifications (updates, inserts, and deletes) are initially recorded in the database log file. Depending on the frequency of modification and your backup and recovery model, the size of the database log file can grow to large proportions in a short amount of time.
Use sp_helpdb to determine, among other things, the size of both data and log files separately. The stored procedure returns two separate recordsets so you need to use the Recordset pane in Teratrax Database Manager to navigate between the two recordsets.
Syntax
EXECUTE sp_helpdb MyDatabase
Beekeeper Studio Is A Free & Open Source Database GUI
Best SQL query & editor tool I have ever used. It provides everything I need to manage my database. - ⭐⭐⭐⭐⭐ Mit
Beekeeper Studio is fast, intuitive, and easy to use. Beekeeper supports loads of databases, and works great on Windows, Mac and Linux.
What Users Say About Beekeeper Studio
★★★★★
"Beekeeper Studio completely replaced my old SQL workflow. It's fast, intuitive, and makes database work enjoyable again."
★★★★★
"I've tried many database GUIs, but Beekeeper strikes the perfect balance between features and simplicity. It just works."