Since you are on SQL 2012 I would look into Extended Events to capture stuff affecting this table.

Leonard, let me start by saying this response is going to be very blunt and direct. It is not a personal condemnation. I have seen multiple companies struggle and even...

Profiler can connect to SQL Server from off of the server itself, although this can have some performance effect.

The most likely thing here is a "cleanup job" running in SQL...

alex.sqldba (6/1/2016)

---

Evening All,

I am using some of the DMV's to identify missing indices on tables and their potential impact.

It spits out 3 columns of interest:

inequality columns

equality columns

included columns

The latter I...

Has anyone asked for an estimated execution plan yet? What about table create scripts (complete with all keys and indexes)? Perhaps there is an unintended cartesian to be found, or...

$3K is a lot of money for a 128GB SSD. I suppose you could have burned it out with writes, but a few months really isn't very long.

Please ALWAYS include create table statements and all relevant sample data and your expected output from said data. That way we can be sure to write a query that covers...

Igor Micev (5/31/2016)

---

Grant Fritchey (5/31/2016)

---

TheSQLGuru (5/31/2016)

---

What SSDs did you have? What...

Sean Lange (5/31/2016)

---

Maybe a bit off topic but nobody else mentioned all those NOLOCK hints. That hint may make your queries a little bit faster but they do come with...

vijay.vesanekar (5/31/2016)

---

Thanks Kevin for reply

3) Most importantly what is the hardware configuration?

-- Which are the particular hardware configuration parameters you require for further suggestion

4) Have you done...

Roust_m (5/31/2016)

---

TheSQLGuru (5/30/2016)

---

Replicas being offline will NOT cause a transaction on the primary to fail. They will simply queue up on the primary and catch-up when the secondary that was...

1) GUIDS

2) probably unnecessary SORT/DISTINCT for the UNION

3) Most importantly what is the hardware configuration?

4) Have you done file IO stall and wait stats analysis during these hours-long runs?

What SSDs did you have? What was very bad about the...

I wasn't aware there was such a document. What is great for one environment could be poor for another environment. Is your environment 3 low-end SSDs in a low-end SAN...

Replicas being offline will NOT cause a transaction on the primary to fail. They will simply queue up on the primary and catch-up when the secondary that was offline become...