That makes sense. One article/blog I read yesterday said to look at Scandensity and Page Splits. The Scandensity part makes sense, but it was the page splits...

I read through it yesterday and it is very good, but it does not explain what values indicate a problem. I agree there are many counters where a specific...

Here are some good links. For the Microsoft links you can click on the second one and then following the window that opens to your left for additional steps....

Do you recommend it with DBCC CHECKDB?

2005 Enterprise Edition - 64bit

You mentioned using MAXDOP = 1 for reindexing, what's your thought on using it for DBCC DBREINDEX? I'm seeing more CXPACKETs and PAGEIOLATCH_SH then with reindexing so I figured...

We don't use maintenance plans for backups, rather we code our own backup routines in SQL jobs. I assume you are referring to the CHECKSUM option, which is not...

I really appreciate this. Thanks. It's good to learn how other people approach maintenance.

Dave

I don't want to waste your time by asking you to re-write it in SQL, although I do appreciate the offer. I can figure it out, but was just...

We also have a large Oracle environment here as well. One thing we do in the multi-TB data warehouses is track index rebuilds/reorganizations in a table in the DBA...

I'll give the MAXDOP 1 option a try. We log all activity every 10 minutes so I checked the logs for the time period when the reindex job last...

I appreciate the script, but we are already performing defragmentation based upon different fragmentation levels.

I'm working on an Online defragmentation script, but unfortunately you can't run online defragmentation on tables...

So it sounds like I can't speed up the reindexing. I consider this application on the fast track to becoming large. It is projected to be over one...

I also suspect Double-Take and have been lowering the max memory, but I'm still hopeful to find some memory counters that I can look at on a regular basis to...

Thanks Paresh, but what values are considered bad and point to a memory bottleneck.

Dave