#SQLServer2017 – DB Cloud TECH

When we are talking about Performance tuning and Monitoring on Azure SQL Server, we should consider some services provided on azure supporting us in this task

Query performance insight.
Azure SQL Performance Recommendation Services
Azure SQL Analytics
Azure SQL Automatic Tuning Services
Diagnostics settings
Learning Resources

**Azure SQL Database Monitoring Services**

Continue reading →

it Tutorial

Install multiple MySQL instances on a Linux server -use a separate MySQL configuration file March 1, 2021

curl -L -O https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.23-el7-x86_64.tar [root]# rpm -qa|grep mysql [root]# rpm -qa |grep mariadb-libs yum remove mariadb-libs -y tar -xvf mysql-8.0.23-el7-x86_64.tar [root]# groupadd mysql [root]# useradd -r -g mysql -s /bin/false mysql [root]# cd /usr/local/ [root local]# tar xzvf /root/mysql-8.0.23-el7-x86_64.ta […]

Mughees Ahmed

DATA WAREHOUSE – CHANGE DATA CAPTURE (CDC) February 27, 2021

CDC (Change Data Capture) It can be called the process of defining and capturing changes made in the database. It is also referred to as a design pattern to identify and track changes in this type of database. Unlike traditional methods, it finds and updates changes in data instantaneously instead of batch processing. Differences between … The post DATA WARE […]

Onur Cirkin

[INS-06006] Passwordless SSH connectivity not set up between the following node February 26, 2021

I got ” [INS-06006] Passwordless SSH connectivity not set up between the following node ” error in Oracle database creation on Exadata. [INS-06006] Passwordless SSH connectivity not set up between the following node Details of error are in the DBCA LOG as follows. [INS-06006] Passwordless SSH connectivity not set up between the following node(s): … The […]

Mehmet Salih Deveci

No active extraction maps on Goldengate Extract or Replicat Stats February 25, 2021

I got No active extraction maps on Goldengate while running Extract or Replicat Stats. No active extraction maps Details of error are as follows. GGSCI (msdbadm01 as GGS_ADMIN19C@MSDB) 62> stats EMSDB01 Sending STATS request to EXTRACT EMSDB01 ... No active extraction maps. no active replication/extraction maps STATS COMMAND displays … The pos […]

Mehmet Salih Deveci

ORA-25153: Temporary Tablespace is Empty February 25, 2021

I got ” ORA-25153: Temporary Tablespace is Empty ” error in Oracle database during export operation. ORA-25153: Temporary Tablespace is Empty Details of error are in the Alertlog as follows. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production ORA-25153: Temporary Tablespace is Empty ORA-06512: at "SYS.DBMS_LOB" […]

Mehmet Salih Deveci

Tag: #SQLServer2017

Azure Services for Monitoring and tuning Azure SQL Database

Share this:

Like this: