Database Recovery

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 »

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

In this article, we will introduce how to monitor CPU usage on SQL Servers using TSQL Script. With the script, you can log server's CPU usage. You can also set email alerts. Why it is So Important to Monitor CPU Usage as a DBA Checking the resource utilization would be the primary step that a DBA would do when they are called for a Performance trouble shooting. High CPU usage on SQL Server will have a huge impact on the SQL’s performance and on the CPU. A CPU’s lifespan would be reduced...

Read more »