help with locks on tempdb RRS feed

  • Question

  •  hello

    [i was unable to post images sorry]

    there is some issues on my tempdb

    i was trying to look at the property but it failed

    looked up at the reason and got some locks

    i looked up those locks and got waitresources

    and found that i have got locks on sys.sysschobjs

    is there a way to enhance tempdb??

    our database always get lock on tempdb 

    need some exports guidence

    thanks for reading

    • Edited by nanocube193 Thursday, December 17, 2020 1:08 AM
    • Moved by Dave PatrickMVP Thursday, December 17, 2020 1:40 AM looking for forum
    Thursday, December 17, 2020 1:05 AM


  • I'd try asking for help over here.

    sql-server-general - Microsoft Q&A



    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows Server] Datacenter Management

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.

    • Proposed as answer by KHURRAM RAHIM Thursday, December 17, 2020 6:41 AM
    • Marked as answer by Guido Franzke Wednesday, December 23, 2020 6:56 AM
    Thursday, December 17, 2020 1:40 AM