I.T. minded
It is possible that sql jobs are “hanging” in a suspended state. The SQL statements below will give you an indication on what the job is waiting.The first SQL statement will create a small stored procedure in the master database, which can be called by “exec sp_check_state”.The second sql satement…
I was building a new system for hosting, and that system is a virtualised system with Ubuntu. The OS was built by the provider. After installing everything, I wanted to activate the quota on the filesystem. The quota check failed with the following message: After a small check, I noticed that…
If you are using SSMS 17 or 18, you have maybe noticed that the SSMS startup can be very very very very slow, which is annoying for everyone. There are 2 workaround, which could resolve this issue: Open Internet Explorer: Options Then scroll to the bottom of the list and uncheck…
The T-SQL code below lists the currently running SQL Agent jobs.
In case you have a screen with high resolutions, a 4k screen for example, it is possible that GRUB is incredibly slow. If that is the case, the workaround is to edit the /etc/default/grub file, and add/replace the following line Then run “update-grub” to update the GRUB.This will run GRUB…
You can monitoring TEMPDB usage by using the following SQL statement.
The code below can be used to query the linked servers & the user assigned to it.
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)#…
With this command you can check the amount of transactions in the distribution database
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.
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…
On the distribution database, you can execute the statement below to get the sizes of the internal replication specific tables
You can use the code below on your distributor in order to check the backlog of the replication
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:
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…
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.
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.