cats
jamesalleniwd
shuming
xiaohai
sunnylovey
adrienbrody
normancohn
daniellevan
rerqr
iaiyhadlda
habeb1
addisonjame01
yasmine1101
dellsony
jacobsebastian
toponscom
pinaldave
akkushaus
lapss321
Lenovo13
http://ozziemedessql.blog...
mayluobatty
ashishgilhotra
abcdee
AdaTheDev
lauriesteve
http://ghemant.myopenid.com/
The DMVs are a great way to get a closer look at what is actually going on in your system. In particular, for some operations, SQL Server populates the percentcomplete and estimatedcompletiontime (in milliseconds) in the DMV sys.dmexec_requests. This can be very useful if you want to know how long your BACKUP or RESTORE will take (if you didn't use WITH STATS or are using command-line or a 3rd party tool), or whether you should go to lunch while your ROLLBACK is, well, rolling back...
|
1
kudos |
|
||||
sa
No comments yet, be the first one to post comment.