help with locks on tempdb

• Question

• 

  

  0

  Sign in to vote

   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