.::: Test Performance SQL Server, MSSQL, MySQL, MariaDB, Oracle using Apache JMeter :::.

1. Open Jmeter.bat
2. Creating a Thread Group Element

3. Fill Threat Group and save
Name = MSSQL

4. Creating JDBC Connection
Right Click -> Add -> Config Element -> JDBC Connection Configuration
 

.::: How to Flush Clear RAM Memory Cache, Buffer and Swap Space on Linux :::.

1. Clear PageCache only.

# sync; echo 1 > /proc/sys/vm/drop_caches

2. Clear dentries and inodes.

# sync; echo 2 > /proc/sys/vm/drop_caches

3. Clear pagecache, dentries, and inodes.

# sync; echo 3 > /proc/sys/vm/drop_caches

.::: How to enable CDC (Change Data Capture) in SQL Server in Table & Databases SQL Server :::.

1. check table from database
USE teguhth
GO
select @@servername as ServerName, DB_NAME() as DBName,* from pembelian;
select @@servername as ServerName, DB_NAME() as DBName,* from teguhth.dbo.pembelian;

//** command for data cdc become

select @@servername as ServerName, DB_NAME() as DBName,* from cdc.change_tables
select @@servername as ServerName, DB_NAME() as DBName,* from cdc.dbo_pembelian_CT
select @@servername as ServerName, DB_NAME() as DBName,* from cdc.dbo_pembelian_CT ORDER BY __$start_lsn DESC
**//