tsai2013
anbahnung
akkusakku
blue
xuyihang
pg4soft
aoedmatadc
abcdee
yasmine1101
sunnylovey
xiaohai
dellsony
jacobsebastian
cats
toponscom
pinaldave
shuming
akkushaus
gangbing
anne785
lapss321
mayluobatty
jamesalleniwd
Lenovo13
http://ozziemedessql.blog...
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.