Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

  The PAGELATCH_EX and PAGELATCH_SH wait types are errors that occur when writing to the same page in memory at the same time. These errors …

  If you are beginner then this post will help you to monitor the mysql server. Here I am listing some most commonly used MySQL …

  We can use Backup Restore for many operations. Below you can find the most common reasons for using it. 1. To get a regular …

Error: When creating an Oracle database in Windows operating system: ORA-12546 TNS: permission denied ORA-12560 TNS protocol adpater error ORA-516 Permission denied From SQL * …

  Single Node Architecture: when we talk about Sybase IQ architecture , We should explain about the Three important IQ stores and three main files. which …

  Replication: Replication is a way of copying and distributing data and database objects from master to slave servers. These databases are synchronized to maintain …

  In a Master/Slave replication data consistency is a biggest concern and is very easy  to break your replication with  issues such as duplicate keys, missing …

– Requirements This topic assumes that you have user with sudo privileges and have MySQL installed on both server(Master & Slave). If you do not …

  Fragmentation on MongoDB databases When we removing a large amount of data from the collection and no plan to replace it, we generate a …

It will display current running processes: [crayon-6780d41612c72927568528/]   It will display processes which is running by “dbmaint” user id: [crayon-6780d41612c76477912819/]   It will display databases …