When an Oracle database is heavily used by many connections / sessions, one or some of them may consume a large percentage of memory (RAM). If there is a problem and it is not addressed due to lack of memory it may… read more
How can we see what CPU Usage we had per minute in SQL Server
SQL Server during its installation creates a lightweight Extended Event with a size of up to 5mb in which it records performance information. This Extended Event is called system_health and in this article we will see how we can with… read more
How can we get emails whenever we have high CPU Usage in SQL Server
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 can we get email whenever Tablespace needs Datafile in Oracle database
In Oracle databases tables are stored in logical entities called Tablespaces. Each Tablespace consists of physical files called Datafiles. In Oracle, however, each datafile can have a maximum size of up to 32GB, because of this... read more
How do we find what queries are currently running in SQL Server?
Many times we will need to quickly find out what queries are running in an instance of SQL Server. In this article we will see a query that I have written that can directly extract all the information we need. The query retrieves… read more
How can we get email whenever an error occurs in SQL Server Error Log
In an instance of SQL Server, potential problems that occur are recorded in a place called the Error Log. However, it would be very useful for us if any important error appeared in the Error Log, SQL Server forwarded it to us... read more
How can we get email whenever we have blocking session in Oracle database
In an Oracle database, every time a session updates the elements of a table, it becomes locked to ensure that no other session will be able to modify the same table at the same time. But when… read more
How can we get an email whenever an error occurs in the Oracle database Alert log
In a system based on an Oracle database, that an error occurs is recorded in a log file called the Alert Log. It is very useful to be informed immediately when something happens and the most immediate way is no other… read more