george sibbald (7/20/2012)

---

You have SQL2008R2 so you get database backup compression with the product

run commands

sp_configure 'backup compression',1

reconfigure

to enable it.

the just set up a maintenance plan to do your backups,...

If its a job linked to a Maintenance Plan are yountrying to delete the job from SQL Agent directly, or within the Maintenance Plan in the 'scheduling' section?

Fragmentation over time.

Scalar-valued User-defined Functions (sUDF) in SQL Server are known to cause performance problems, especially when they are used in a way in which it sounds like they are being used...

Page splits/sec, at least the server metric, not sure how you calculated it using fn_dblog, counts a new page allocation at the end of the index as a page split...

Is the hardware equivalent? To Richard's point this one instance may simply not be keeping up.

Another slightly related train of thought, do you have index maintenenace running on all the...

GilaMonster (7/20/2012)

---

That just tells you whether data purity checks have ever been run and return clean, not if CheckDB has....

Stamey (7/20/2012)

---

The waits I have are PageIOLatch_SH and CXPacket, on multiple instances of the command "DBCC Table Check". DM_Exec_Requests show the extact query is being: "DECLARE @BlobEater VARBINARY(8000) SELECT...

Please confirm you are on build 9.0.5266 on all instances.

Are the results of this the same on all instances?

DBCC TRACESTATUS(-1);

I think that particular doc is wrong. Too hard to believe they would take that away from that edition/bitness only so I looked it up. There are conflicts all over...

Steve is right about backups from the source being your primary line of HA. Copying the fulls and any tran log backups somewhere as they are taken is critical no...

What options are you running CHECKDB with? Can you provide the actual command issued?

I am not sure I agree with that. What if your fixed-width...

pooyan_pdm (7/18/2012)

---

You're not the only one here with some years of experience here!! I've been doing this for 7 years . can just instead of repeating your claim give a...

Certs are a weed-out qualification. It takes a bit of time working with SQL Server and studying the material to get to a place where you can write one and...