New answers tagged

6

sys.databases is a complex view. On SQL Server 2016 it is: CREATE VIEW sys.databases AS SELECT d.name, d.id AS database_id, r.indepid AS source_database_id, d.sid AS owner_sid, d.crdate AS create_date, d.cmptlevel AS compatibility_level, -- coll.value = null means that a collation was not specified for ...


0

As a complement to Mark's answer you can check for long running transactions: select x.agent_id, substr(z.corr_TOKEN,1,14) as ip, cast(y.stmt_text as varchar(800)) as stmt, x.locks_held, x.APPL_IDLE_TIME, x.UOW_START_TIME from sysibmadm.SNAPAPPL x join sysibmadm.snapstmt y on x.agent_id = y.agent_id join sysibmadm....


Top 50 recent answers are included