Skip to content

Schelstraete.org

  • Home
  • Home

Post navigation

← Older posts
1707, 2020

T-SQL: Kill all inactive sessions from specific user

Bschelst/ July 17, 2020/ SQL-Server/ 0 comments

1607, 2020

T-SQL: Check status of automatic seeding

Bschelst/ July 16, 2020/ SQL-Server/ 0 comments

2503, 2020

T-SQL: size of replication specific tables

Bschelst/ March 25, 2020/ SQL-Server/ 0 comments

On the distribution database, you can execute the statement below to get the sizes of the internal replication specific tables

2503, 2020

T-SQL: check replication backlog

Bschelst/ March 25, 2020/ SQL-Server/ 0 comments

You can use the code below on your distributor in order to check the backlog of the replication

1702, 2020

T-SQL: Resume or suspend all always on databases

Bschelst/ February 17, 2020/ SQL-Server/ 0 comments

You can use the t-sql code to resume/suspend all databases from the always on group.

2608, 2019

T-SQL: only run job on primary node

Bschelst/ August 26, 2019/ SQL-Server/ 0 comments

2608, 2019

T-SQL: check seeding speed

Bschelst/ August 26, 2019/ SQL-Server/ 0 comments

2107, 2019

Linux – commvault: create systemd file

Bschelst/ July 21, 2019/ Linux/ 0 comments

1407, 2019

Mysql: optimize all tables in all databases

Bschelst/ July 14, 2019/ Linux/ 0 comments

In order to optimize all databases & tables within your mysql instance, you can use the code below. You can also use a more specific script, where only the tables are optimized which have 10MB free space and 10% free space.

2806, 2019

T-SQL: Getting lag for sync always on replication

Bschelst/ June 28, 2019/ SQL-Server/ 0 comments

Post navigation

← Older posts
Search for:

Recent Posts

  • T-SQL: Kill all inactive sessions from specific user
  • T-SQL: Check status of automatic seeding
  • T-SQL: size of replication specific tables
  • T-SQL: check replication backlog
  • T-SQL: Resume or suspend all always on databases

Archives

  • July 2020
  • March 2020
  • February 2020
  • August 2019
  • July 2019
  • June 2019
  • May 2019
  • April 2019
  • February 2019
  • November 2017
  • August 2017
  • July 2017
  • June 2017
  • April 2017
  • March 2017
  • February 2017
  • January 2017
  • December 2016

Categories

  • Avamar
  • General
  • Ispconfig
  • Linux
  • Oracle
  • PowerShell
  • SAP Hana
  • SQL-Server
  • Uncategorized
Schelstraete.org