I'd be curious how things perform with hyperthreading disabled.

If IO is 2x to...

I would certainly encourage a look at CPU-Z and compare the settings on the old server with the new, hyperthreading being one of them. Additionally, you mentioned faster disk but...

SQLKnowItAll (6/6/2012)

---

I believe it must be, that...

Being that you have 128 GB of memory I am assuming that this is 64-Bit but just to be sure, is it?

Have you run the DBCC against the production database then? Just trying to make sure that I understand the last post correctly.

Do you have a SnapManager backup? If so, you could restore that in another location and see if that is without the error by running DBCC against it. I'm guessing...

...and that would be our job to make sure that the "common sense" principles are upheld. 😛 Not always easy though.

SQL Kiwi (5/22/2012)

---

Jeff Moden (5/22/2012)

---

Then I had idiots write things like a modulo function and a merge in CLR because they didn't know how to do it in SQL and...

A bit intrigued here as well. You are not replicating delete statements. Any chance that you are reusing the primary keys on the publisher and hence getting duplicates at the...

Your boss should really re-read the statement from MS. They definitely recommend letting memory be dynamically managed but I'm sure if you were to contact product support they would tell...

I would recommend enabling logging on the snapshot agent to see what that reveals. I'm pretty sure that will provide some clarity.

http://support.microsoft.com/kb/312292

Let me know what you find.

Remove these from the script and start again. These are all connection events and really aren't necessary for this.

exec sp_trace_setevent @TraceID, 14, 1, @on

exec sp_trace_setevent @TraceID, 14, 9, @on

exec...

dwilliscp (4/27/2012)

---

I found the following on MS site (http://msdn.microsoft.com/en-us/library/ms178067(v=sql.90).aspx)

So my boss is correct.. the recommended state (by MS) is to let SQL Server get what ever memory it can from...

dwilliscp (4/27/2012)

---

My boss states that he has always seen that you have to set the SQL server to Max RAM.. does anyone know of any links from MS (MSDN) that...

opc.three's recommendations definitely need to be applied first and see how things go from there. Once that is done I'm guessing that you will not lock up as "hard" as...