SQL Server – Wait Stats – “BackupThread”

Background

Once our database file has been covered from Prod to QA.

We restore it unto QA.

 

Wait Stats

PREEMPTIVE_OS_PIPEOPS

BTW, the wait noticed for copying, PREMPTIVE_OS_PIPEOPS, is documented here.

 

BackupThread

Images

Image #01

Image #02

Image #03

Explanation

  1. Image#01
    • Time Taken
      • Thus far 6 minutes
    • SQL Text
      • Restore database…
    • Login Name
      • NT AUTHORITY\NETWORK SERVICE
  2. Image #02
    • wait info
      • BACKUPTHREAD
    • CPU/Reads/Writes/Physical Reads/Used Memory
      • Indicated
    • Status
      • suspended
        • A lot of suspension as we are waiting on disk
  3. Image #03
    • Percent Complete
      • Captured
        • At time of capture for us we were at 15%
    • Program Name
      • SQLAgent
        • Process scheduled via MS SQL Server Agent
    • Start Time
      • 5 AM

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s