Before installing MySQL instance, we must evaluate the CPU, Memory, Disk IO performance, Disk size, network of the server, also the maximal QPS(Query Per Second), concurrent …
Read More »POSTGRESQL DATABASE PERFORMANCE – 2
This article is the second article of the performance series. You can find the first articles link “POSTGRESQL DATABASE PERFORMANCE – 1” In the …
Read More »POSTGRESQL DATABASE PERFORMANCE – 1
If we examine some performance parameters in postgresql, I will mention a few parameters that will be quite useful for performance. You can configure …
Read More »Priority Settings in db2
Hi DBAs, how are you? Let’s talk about how to reserve resources for the db2 utilities so they do not compete (directly) with user …
Read More »How To Cancel Concurrent Request from Back End
There are 2 Steps for Cancelling Concurrent Request from Back End : Step 1 :- 1. Run the below SQL query. Give the …
Read More »Script to Reduce the tablespace size and reduce the free pages
Most of the cases we need to monitor the space of the FileSystem while data is growing in the database. And if there are …
Read More »Exadata cell server ORA-700 ORA-600
For disk errors such as ORA-700 or ORA-600 on the cell server, first check whether there is a physical fault. If there is a …
Read More »SQL Server Service Account’s Permissions on Windows
Most DBA usually define the SQL Server Service Account as the Administrator on the server. Actually, this authority is not necessary. You must not …
Read More »Configuration of RMAN using Oracle 10g
There are many ways to setup the RMAN. Here i am using the separete database to store backup catalog information with windows Server 2008 …
Read More »MySQL/MemSQL/SAP sqlanywhere/SAP IQ – 3 migration issues, isnull & any subquery
Numeric data type SAP IQ – supports up to (126, 38) MySQL/memSQL – support up to 65 digits; https://docs.memsql.com/sql-reference/v6.5/datatypes/ ISNULL vs IFNULL SAP IQ …
Read More »