In this article we will see a script that creates a SQL Server Agent Job that will notify us by email whenever the CPU exceeds a threshold. It derives the information not from performance counters of the operating system but... read more
How do we limit the resources that a user can consume in SQL Server
Many times a user in the database can consume all the resources that the SQL Server instance has and no other work can be done by another user. In this article we will see how we can… read more
A disk is full of SQL Server datafiles, what should I do?
Sometimes a disk will suddenly become full. On this disk we may have one base or many, while we may have space on another disk, we must somehow find which datafiles are full. In this… read more
Why can't I shrink the transaction log in SQL Server and why is it full?
In a previous article we saw what the Transaction Log is. This time we'll see how we can empty it and make it shrink, we'll also see what we can do case by case when it won't let us. Suddenly… read more
How we find the performance of existing Indexes and which new Indexes SQL Server recommends
In a previous article we saw what indexes are. In this article we will see how to find the status of their hash, if you are using, when they were created, when they were updated and if they are missing indexes recommended by SQL Server.… read more
Why is restarting the SQL Server instance delayed?
In this article we will look in detail at some of the most common reasons why a SQL Server instance may be slow to restart and what we can do to improve this time on a case-by-case basis. Using a very large… read more
What is the Transaction Log and what is it used for in SQL Server
In this article we will analyze what the Transaction Log is in Microsoft SQL Server, what it is used for and what to watch out for. What is the Transaction Log Every database we create apart from the data files that… read more
How do we automate the index rebuild process in SQL Server without using a maintenance plan
As we have seen in an earlier article for the easiest way to access data in databases we use indexes and statistics. Indexes are essentially an index that helps us find what we are looking for faster. But as... read more
How can we perform backups and other Agent jobs in an Always On Availability Group of SQL Server
In this article we will see how to take backups and run jobs on any server that has the Primary role or is a Preferred Backup Replica in an Always On Availability Group of SQL Server. While installing… read more
