Database Solutions

How to Monitor SQL Server Database Growth using TSQL and Excel

Monitoring database growth is a key factor in planning a server's resource. Use this script and create easy to understand database growth report Why You Need to Monitor Database Growth If you are a SQL Database administrator and if you are not having "SQL Server database capacity planning" in your key task list, then you can be sure that databases on your server will fill up your disk space pretty soon. Tracking the size and growth of SQL databases is one of the primary task of Capacity...

Read more »

How to Auto Backup and Restore Databases with TSQL during Server Migration

During migration, backup and restoring databases might be a hectic task. However with this Automated Backup and Restoration script you do not have to worry about it anymore. During migration, taking a backup and restore for databases might be a hectic task. Now is it easy with this Automated Backup and Restoration script which enables the user to have a stress free migration activity. This script has to be executed on the server from which you are taking the database backup. The script...

Read more »

How to Log and Monitor Your Server’s Memory Usage without Using Third Party Tools

Stop buying third party tools to monitor Memory usage on SQL Servers. Using this TSQL Script, you can log server's Memory usage. You can also set email alerts accordingly. Why DBA should Monitor Memory Usage? Generally a DBA’s mailbox will be flooded with emails whenever end users are unable to work on a server or if all the task are taking too much time. With a quick check at the Server’s resource usage, you can determine that the reason for this problem is the server’s Memory. The CPU...

Read more »