Hi,
Our production server has 48GB of memory.  The test servers only have 16GB of memory and this has a named instance that has 3GB allotted to it.  The...

Hi Gail,
The compatibility level of the test server that completes is SQL Server 2008(100).  On the new 2016 and 2012 production server where it never completes, it is 110.

Hi,
I agree on the comments that MAXDOP is not the solution or that CXPACKETS is the problem.  I'm trying to figure out why it's behaving this way on my...

Hi,
This query is coming from an application that I cannot modify.  I am manually running it just to try and see what the problem is but I can't modify...

Also, this 2016 test server has nothing else running on it. It is a newly built server and I restored the same database from the test server where the query...

Hi,
I posted the query above.  Here is the sqlplan for the query that is still currently executing.  I will read the suggested articles and see if I can pinpoint...

Hi,
You mean setting the MAXDOP to 1? I'm going to eventually kill the query and test out some MAXDOP settings but it just doesn't make sense why it would...

Hi,
Here is the insert query that it is stuck on

Hi,

We used HammerDB to test our new SAN...it will simulate a load on the system and it consistently brought our CPU up above 90%. 😀

Awesome! That did it. 😀

Thank you Lowell.

- Isabelle

Hi,

We have a whole set of issues of trying to modify the table structure for this ERP system by adding primary keys so I don't believe that is the way...

Yes, that is correct Scott. The tables have unique clustered indexes that was all added when the ERP system was installed to maintain its referential integrity. I don't...

Hi,

Well, from what I have read about snapshot replication, it may not work for us. We have an OLTP system that does a lot of frequent updates to a...

Hi,

This database was created automatically when they installed a new ERP system before I got here. I agree and was shocked that there are no primary keys in any...

Hi,

Thank you for that information. I will look into specific tables that have a high I/O hit on the database and consider that option as well.

Thanks agin....