deep details about the server and it’s version
Month: July 2021
envusersssisdb
no description at this time.
envroutes
specific for compass, but a good model. assumes specific linked servers, compares each brokerid and
block
produces a tree like structure of current blocking tree with the main blockers marked as HEAD:
envplan
get the query plan if you know the plan_id
envdirty
no description at this time.
sepcp
review extended event for specific client
runjobs
list of running jobs
mysschema
linked server best practices settings
failmail
list of recent failed emails in database mail