Post reply

SYS.DM_EXEC_REQUESTS gives different information

  • September 10, 2014 at 8:20 pm

    #290710

    Hello,

    To analyze the performance data I am inserting SYS.DM_EXEC_REQUESTS DMV result into table. Under the Command column, it shows CREATE INDEX entries, under Text column it shows insert [dbo].[tblName1] select * from [dbo].[tblName2] for the same process.

    My question is, for insert (which is under text column) why it is showing as CREATE INDEX under Command Column. I am not able to relate. Please help.

    Regards,

    Paul

  • September 10, 2014 at 9:03 pm

    #1744627

    pawana.paul (9/10/2014)

    Hello,

    To analyze the performance data I am inserting SYS.DM_EXEC_REQUESTS DMV result into table. Under the Command column, it shows CREATE INDEX entries, under Text column it shows insert [dbo].[tblName1] select * from [dbo].[tblName2] for the same process.

    My question is, for insert (which is under text column) why it is showing as CREATE INDEX under Command Column. I am not able to relate. Please help.

    Regards,

    Paul

    Was this creating a clustered index?

    --------------------------------------------------
    ...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply