We have 256 GB RAM. We archive 50 % of Rows. Still Same Issues.We have SSD disk. So I don;t think any hardware issues.

Another USe case.

I have multiple parameterized SP for our Application.

When I Executes those SP individual it will returns output within 1 Sec. But when we are running Test Load with...

• This reply was modified 4 years, 4 months ago by  6pravin9@gmail.com.

Hi I Did not mentioned earlier, This is my Live OLTP Database/Tables. So On top of the adhoc Queries  there are some another maintenance jobs as well as some scheduled...

Table : FinalTAble Which has around 1 billlion rows with 50 columns.

I have to update 600 millions of rows in columnC ('xyz' to 'ABC')

Here Is my Update Statements

Copied 600 millions...