MSSQL – See status of running jobs
admin If you ever need to see the status of a running jobs, this TSQL can be very helpfull
mssql
MSSQL – Always On availability group – Get sync status
If you wan to know the sync status of a always On availability group database replication, this command can be used:
MSSQL Backup History Query
To see MSSQL history Query, run this SQL query. It will show all backups between the 1 january 2021 and 1 february 2021, order by Database and then Last backup…
SQL – Check with statements that are blocked
You can check which statements are blocked by running this
MSSQL SP_WHO2 order by db / databases
Order sp_who2, after database with this commands:
MSSQL – check that the Agent Job have been run as Schedule
I have this problems, that if a schedule inside a Agent job, have not been started for some reason, there will be no errors about this problem. So Í have…
Implement SQL Server Agent Jobs with AlwaysOn Availability Groups
The function I use fn_hadr_group_is_primary from this post is a UDF (User Defined Function) that we create in the master database. The function gets an Availability Group name as an…
Monitoring a Automatic Seeding in msSQL Always on Availability Groups
This command, can be run on both the primary and secondary node.
msSQL Session running on database
To see witch session id, that run command against a database, you can run this:
MSSQL: Whitch database used most memory
With this query, you can see whitch database that is using most memory