I have been running into a problem where my execution package keeps failing due to a deadlock between an index rebuild and a select statement on sys.tables.Â
TimeXtender is running both process' and one eventually gets killed and fails the entire job.Â
in subsequent executions it has always failed on an index rebuild, but not the same index.Â
Has anyone run into this issue or have any solutions?Â
here's the query.Â
SELECT
SCHEMA_NAME(tbl.schema_id) AS )Schema],
tbl.name AS eName],
tbl.object_id AS dID],
CAST(
case
    when tbl.is_ms_shipped = 1 then 1
   when (
       select
            major_id
        from
            sys.extended_properties
        where
            major_id = tbl.object_id and
            minor_id = 0 and
            class = 1 and
            name = N'microsoft_database_tools_support')
        is not null then 1
   else 0
end        Â
             AS bit) AS IsSystemObject]
FROM
sys.tables AS tbl
ORDER BY
pSchema] ASC, Name] ASC
