You should have Performance Monitor on your machine. You would open that and remove the counters that are currently running. Then in the drop down you will want to put...

You should really watch the Checkpoint Pages / Sec performance monitor counter and see if it drops off. If it is running all the time or for really long periods...

I use FaceBook but overall don't find it profitable. More than anything I find it concerning for the next generation that don't know how to communicate in any verbal form...

It's not that virtualizing is a bad idea or that people on the forum don't support it. 🙂 The post is indeed long and the questions are probably something that...

dajonx (12/22/2010)

---

David:

Yes, I am using the native SQL Server backup and restore. I am testing out LiteSpeed and I really like it. 😀 Now... To just...

This is new to me. I've got to get out more....

You could try this (pulled from HERE);

select

database_id,

file_id,

io_stall,

io_pending_ms_ticks,

...

Is it potentially trying to do a verify on the backup and the backup to tape is reading it at the same time? Serious guess so take it with that...

dajonx (12/22/2010)

---

I'm just curious if this is the fastest restore I can achieve on this server. I just curious why there's such a huge discrepancy between restoring on this...

You can BUT I would strongly recommend that you use the procedure I pointed out to build them. That will build them to match the publisher (and hopefully the subscriber)....

Yes, differential backups are cumulative in that they hold all the changes since the last full. So, you do...

saidapur_satish (12/21/2010)

---

Hi all,

I have Doubt....

I am taking Full backup every st of month, then taking a differential backup every day & transaction backup going on every...

restore with full backup norecovery, restore differential from the 22nd or 23rd depending on when the differential occurs with no recovery, restore all the log backups following the differential backup...

Not sure that I helped in this case but.... 🙂

If you do think of a reason that you have to reinitialize give a shout - prior to starting the work...

If you have time please update this thread as you have more information. I would be curious to see what you find as you start looking at the counters.

The...