Checkpoints aren't the time when SQL Server writes dirty pages to disk. There is also a lazy write process that helps with writing dirty pages to disk whenever the...

I know the hardware limitations are an issue but until I can get a request through approvals, appropriations, and budgeting... I have to work with what I got.... Sorry..

Again questions...

1....

What do you want to now about the system?

The DB server is live. it has 2 SATA II hardrives which is set up with mirroring. Disk 1 is mirrored to...