T-SQL- check TEMPDB usage
You can monitoring TEMPDB usage by using the following SQL statement.
SCHELSTRAETE.ORG
I.T. minded
Read More
T-SQL: Select userids from linked servers
The code below can be used to query the linked servers & the user assigned to it.
Strongswan: Dynamic (BGP) IPsec VPN tunnel with strongSwan
This guide, coming from Google, explains how to use a dynamic IPsec VPN tunnel with strongSwan on Linux Step 1: Configure BIRD # Config example for bird 1.6 #debug protocols all;router id 169.254.2.2;# Watch interface up/down eventsprotocol device { scan time 10;}# Import interface routes (Connected)#…
T-SQL: Check number of messages in distribution
With this command you can check the amount of transactions in the distribution database
T-SQL: Kill all inactive sessions from specific user
The SQL statement below will kill all sessions from a specific user, which wasn’t active the last hour.Of course, change ‘my_user’ with your preferred userid. If you want you can also uncomment the ‘program_name’ if you want to filter on program name.
T-SQL: Check status of automatic seeding
Automatic seeding for SQL Always On it nice, but in case of big databases this can take some time. Of course, it can be annoying if something is running, and you don’t see the status of it. The query below will show you the status of the automatic seeding, and…
T-SQL: size of replication specific tables
On the distribution database, you can execute the statement below to get the sizes of the internal replication specific tables
T-SQL: check replication backlog
You can use the code below on your distributor in order to check the backlog of the replication
T-SQL: Resume or suspend all always on databases
You can use the t-sql code to resume/suspend all databases from the always on group.The code below will resume SQL data movement for all databases: The code below will suspend SQL data movement for all databases:
T-SQL: Only run SQL agent job on primary node
In a SQL Always On setup, the SQL agent jobs are not synced between the different nodes. This means you need to manually create them on the other nodes. For read-write jobs, you can only run them on the active node of course. You should modify the SQL agent job…
Linux – commvault: create systemd file
If you have upgraded your old Commvault agent,or you still use an old Commvault agent on your linux ‘systemd’ system, there won’t be any start/stop script for the agent. You can use the workaround below for creating a systemd file for it.
Mysql: optimize all tables in all databases
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.
T-SQL: Getting lag figures for SQL Always On replication
If your SQL Always On having a delay? Use the T-SQL code below to find out the performance of the SQL Always on.
T-SQL: Getting lag for async always on replication
Read MoreSLES: Search & install specific CVE
In SLES you can search & install specific CVE patches using the commands below.
T-SQL : find schema modifications which occurred the last day
In SSMS you have the “schema changes history” report. You can have the same (or even more) details from T-SQL. You can use the t-sql statement below in order find schema changes the last day, in a particular database.
SSRS: Find out memory used by reporting service.
The T-SQL code below will give you an idea of the memory used by your reporting service. This query should be executed on the “reportserver ” database. Please be aware executing this statement can take some time.