In an earlier article we saw how we activate the Query Store to monitor the performance of the queries and the plan they ran. But as we said, the Query Store has quite a performance impact, so we may want some lightweight profiling. In this... read more
How we collect deadlocked queries via Extended Event and how we read its data
In an earlier article we saw how we create an Extended Event to see queries with a long duration. In this article we will build Extended Event that records deadlocks. All we need to do is create it with a T-SQL command. After… read more
How to transfer bulk datafiles online to Oracle database
In this article we will see a script with which we can transfer mass datafiles online that we may have created in the wrong location or we want to change their storage in an Oracle database. THE… read more
How to improve a previously run query on an Oracle database (SQL Tuning Advisor with AWR Snapshots)
In a previous article we analyzed how to improve a query in Oracle using the SQL Tuning Advisor. But in order to run the SQL Tuning Advisor, the query must still be in the Shared Pool, i.e. in memory... 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
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
How to enable Oracle Direct NFS for increased performance between Oracle Database and NFS Shares
In this article we will see how to enable Direct NFS for Oracle Database connectivity with NFS Servers. When we enable it the communication between Oracle Database and NFS Servers is done directly, without involving the kernel of… 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
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
