Database Recovery

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 »

How to Get Alert Email on Failover in Your Always On Availability Group in SQL Server

Follow these simple steps along with the script to set up and receive a simple and single email whenever a failover happens in your AlwaysOn Availability Group. AlwaysOn Availability Group in SQL Server AlwaysOn Availability Group was released with SQL Server 2012 and is the successor of database mirroring. You can set it up in your SQL Server environment for high availability or disaster recovery. For High Availability the group has to be set in synchronous mode and for disaster recovery the...

Read more »