BaldingLoopMan (12/15/2009)

---

i personally think this will perform the best. Simply because it is or-less. Or's hurt. Sure it may be a little hard to wrap your mind around which will...

billmcknigh (12/14/2009)

---

Have read the paper SQL Server 2005 Waits and Queues, which I guess is a locus classicus of the waits and queues methodology. The delete statement,...

Assuming good cardinality then there could be 5000 or so PAGES locked if the engine decided that page locks were appropriate (which is likely...

Andrew Gothard-467944 (12/14/2009)

---

Any idea how many rows are normally deleted by your delete process?

If it's more than about 5000, then you're likely to be getting table locks due to lock...

What you need to do is find out WHY things appear to be sluggish at times. Is it due to blocking or is it due to IO stalls or...

Many questions there, among them:

1) what is the provenance of the graph they show. who did the benchmark and tuning of each SAN listed?

2) what the heck is "Real...

Curious. I wonder if that improvement came simply because NetApp was doing something 'dumb' with the RAID 5 setup you had. I have heard horror stories from multiple...

CirquedeSQLeil (12/11/2009)

---

RAID DP is what NETAPP calls RAID-6 for their SAN implementations.

DP stands for double-parity.

From the NetApp docs

The performance of RAID-DP volumes is comparable to that of RAID...

Jason, can you please explain to me how RAID DP will be a step up in performance from RAID 5? I am not too familiar with that type.

BETWEEN includes the endpoints, so you might wind up with an extra day's worth of data using that if your columns don't contain time values.

I bet the CPU usage could be significant here too with all the manipulations done in the select. I would do a waitstats and IO stall analysis to see...

if you want to compare all the data, I would use SSIS to migrate the entire table to a scratch database in sql server and then use an automated tool...

How about you script out the jobs and create them on the server that is the primary and delete them from the secondary. When you do your failover then...

Dean, there are a LOT of variables here. I recommend you get a performance tuning professional in for a day to review your system and make recommendations as well...

I haven't checked for certain Jeff, but I have seen these types of manipulations make proper dates for range queries:

SET @ldtStartDate = ISNULL(@dStartDate,DATEADD(month,-1,DATEADD(mm, DATEDIFF(mm,0,GETDATE()), 0)))

SET @ldtEndDate = ISNULL(@dEndDate,DATEADD(ms, -3, DATEADD(mm,...