What is meaning of cputime and diskio in sp_who2?

  • What is meaning of cputime and diskio in sp_who2?

    Do they tell me processing time?

  • DiskIO is number of reads and writes.

    CPUTIme is duration of the spid. Sometimes a spid will be sleeping (or orphaned) and this counter will continue to grow.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

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

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