Database Solutions

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 »

In-depth Discussion of In-Memory Online Transaction Processing in SQL Server

In this article, we take an in-depth discussion into online transaction processing features present in latest iterations of SQL Server Latest SQL Server editions come with the much vaunted In-Memory online transaction processing (OLTP) engines. This feature helped users improve SQL Server performance by improving the in-memory capabilities of the system, scaling operations in SQL Server and accelerating applications. To achieve all the following SQL users often opt for redesigning the basic...

Read more »