What is the table definition?? Even for 1M rows 175GB means incredibly fat rows!! Got blobs by chance?!?

I would look at tuning the ETL process. And first thing...

SSMS Options-Scripting. Scroll down and triggers is one of the options that is OFF by default. I ALWAYS turn this on, along with indexes and a few others.

After you...

Since you are wanting to put 1/4 rows in each of 4 different tables you MUST ensure your "sequence generator", whatever you use, is REPEATABLY RIGOROUS, or you run the...

Brandie Tarvin (4/7/2016)

---

Grant Fritchey (4/7/2016)

---

Since you're on SQL Server 2012, have you tried using extended events to capture query metrics? They're not free (nothing is, TANSTAAFL always applies), but they...

SSIS and Conditional Split on a computed 1-4 sequence. 4 outputs from the conditional split, one into each of your 4 tables. Easy-peasy, lemon-squeezy!! 😀

https://www.simple-talk.com/sql/ssis/ssis-basics-using-the-conditional-split/

https://technet.microsoft.com/en-us/library/hh231256%28v=sql.110%29.aspx

Please provide a create table statement, insert statements to set up the data, then expected output for what you are asking. We can't write a query without that.

I have done log shipping like this for clients many times over the years. Easy-peasy and works-fine-lasts-a-long-time. 😎

Huh - I thought based on those crazy-long namings that these were multi-field indexes. 😀

Look at the lock requests again in your diagram. This really does appears to be the...

You should not WANT to do this unless you have identified PFS/SGAM allocation issues (and haven't done numerous other things first to address that). This is ESPECIALLY true if you...

vincenzo_capelli (4/6/2016)

---

On primary replica, the Log driver is well size, I think this shouldn't be a big issue.

Summarizing, into the D.R. server room I'll power off Sql Server (secondary replica),...

If you are async my understanding is you don't need to do anything for taking the secondary offline. Do note that you may throw errors that monitoring systems will catch...

I am sorry that I don't have time to really dig into this, but it seems a contributing factor here may be the inclusion of updated fields in the index...

Siten0308 (4/5/2016)

---

Hello,

I have a sql job that runs an ETL process pumping and transforming data from one database into another in the same instance.

it will pump almost about 500k rows...

You didn't give us anything at all to go on to advise you. In particular what edition of SQL Server are you on now and are you (or could you)...