|
|
|
Mr or Mrs. 500
      
Group: General Forum Members
Last Login: Today @ 5:34 AM
Points: 525,
Visits: 997
|
|
Hai to all
Iam deploying a code inthe reporting services which gives the grap of the following I want to Know about these in details ......
1.Lock waits 2.Memory grants queue Waits 3.Thread-safe memory objects Waits 4.Log write waits 5.Log Buffer waits 6.Network IO waits 7.Page IO latch waits 8.Page latch waits 9.Non_page Latch waits 10.Wait for the Worker 11.Workspace synchronization waits 12.Transaction ownership waits
Thanks & Regards NAGA.ROHITKUMAR
|
|
|
|
|
SSCertifiable
       
Group: General Forum Members
Last Login: Today @ 6:31 AM
Points: 6,693,
Visits: 11,706
|
|
Google each one of those phrases and lookup how to capture each bit of info, over time. Then, once you have a process to capture that information over time you can point your report to it and generate those graphs.
__________________________________________________________________________________________________ There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Believe you can and you're halfway there. --Theodore Roosevelt
Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein
The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein
1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy
|
|
|
|