Calculate Client wait time with sql server process time

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • justsam
    New Member
    • Feb 2008
    • 1

    Calculate Client wait time with sql server process time

    Hi Guys, can anybody help me to figure out how much sql server takes to process a query and in case application server is busy and due to that sql server is waiting to send the rsult to Application server even thougth sql server has finished to process query and how much that wait time is, in short here is what i'm looking
    total query time = sql server time + application time (or wait time)

    Thanks in Advance.
  • ck9663
    Recognized Expert Specialist
    • Jun 2007
    • 2878

    #2
    On your apps, can you get the datetime before and after the query and get the difference?

    -- CK

    Comment

    Working...