none
background process create index RRS feed

  • Question

  • I see background process create index from sp_who2 command but there is no maintenance jobs are any create index operations,still I see background connection says create index and it use cpu high some times, i see connection always. please let me know what is this process
    Thursday, March 21, 2019 4:23 PM

All replies

  • That's really to less on information; what is the output of sp_who2

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Thursday, March 21, 2019 5:43 PM
    Moderator
  • I'm seeing the same thing.  Essentially I think what is being asked is why would a system process (any below 50) run Create Index.  For example, in my case output of sp_who2 is:

    Spid 31

    status:  Background

    DBName:  SomeUserDB

    Command: CREATE INDEX

    Thursday, March 21, 2019 5:54 PM
  • Hi lbala012,

     

    As mentioned by Olaf, would you please display the create index line in the execution result of sp_who2? I suggest you use DBCC INPUTBUFFER(SPID) to get eventinfo.

     

    Hope this could help you .

    Best regards,

    Dedmon Dai


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Friday, March 22, 2019 7:42 AM