Gail is right - address the root cause of the problem, don't try to cover it up.

Uh, if your VM software DOES have that limit, it is time to change...

Jeff Moden (7/19/2016)

---

Can't speak for Gail but my suggestion would be... a small amount of money to at least quadruple memory or spend some...

You can force the secondary to become the primary and accept the data loss that happens due to unaccepted tlog activity from the primary. Or you can shut down everything...

1) If you have HEAP tables deleting data from them does not release the space, even when a page is emptied.

2) Someone was silly and set FILLFACTOR to a very...

Uh, you are adding in new data maybe?? :w00t:

SQLBuzz (7/15/2016)

---

Yeah my bad, I was told the system i identical on both the environment.

But this issues was raised recently and it was working perfectly fine last 6 months...

Database admin(DBA) (7/15/2016)

---

Thank you for quick response.

Can you please provide MSDN links here?

Do you want me to suggest the customer to the following files be excluded from all antivirus scans:

Please...

Googling for sql server antivirus exclusions, the top two results are a Microsoft support page and an msdn blog page. I refer all of my clients to those two pages.

SQLBuzz (7/15/2016)

---

Strange ...I was just looking into the setting and i had found these

LogicalCPUs on Prod is 32

LogicalCPUs on Dev is 40

MAX DOP Setting on Prod...

Do a differential file IO and wait stats analyses to see how overwhelmed your server is. CDC can be an enormous overhead, especially on the IO subsystem. My guess is...

You can use system objects about the table/columns to write a query that will write the comparison query for you. Easy-peasy, lemon-squeezy!

Before I look at the query plans I have several questions:

1) are the sql server versions (and database compatibility levels) EXACTLY the same?

2) are the state of the involved tables...

Steve Jones - SSC Editor (7/14/2016)

---

Nothing happens. I created this proc on SQL 2014:

CREATE PROCEDURE mystarer

AS

SELECT 1/0

EXEC sp_procoption 'mystarer', 'startup', 1

I then restarted the instance. After loading XP DLLs,...

Side note:Even though that page is added to the end of the index, adding that page still raises the 'page split occurred' event for XEvents and some other monitoring endpoints....