MSSQL – See status of running jobs
If you ever need to see the status of a running jobs, this TSQL can be very helpfull
Kenneth Qvistgaard Dalbjerg, IT Konsulent i århus
If you ever need to see the status of a running jobs, this TSQL can be very helpfull
If you wan to know the sync status of a always On availability group database replication, this command can be used:
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 time. It will also...
You can check which statements are blocked by running this
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 created this script, that...
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 input parameter and returns a Boolean value indicating...
This command, can be run on both the primary and secondary node.
To see witch session id, that run command against a database, you can run this:
With this query, you can see whitch database that is using most memory
Sidste kommentar