Thanks Gail.

But I heard different opinion from Microsoft support engineer that having default value for MAXDOP and setting it 4 is not same.

If we keep...

4 cores

thanks for your valuable inputs

For INS1 reduced the Max memory to 6gb from 8 gb and now ins1 is using 3 GB out of 6 GB

For INS2 reduced the Max memory to...

which counters should we monitor to troubleshoot memory pressure in SQL Server?

Have you looked in task manager?

Btw

Max Memory for INS1 = 8 GB

Min Memory for INS1 = 1 GB

Max Memory for INS2 = 4 GB

Min Memory for INS2 = 1 GB

Makes...

Thanks Gail.

INS1 is taking only 3 GB out of 8 GB max memroy and INS2 is taking only 1 GB out of 4 GB max memory

So total 4...

No, We are using x64.

Hi Gail, I looked at Memory counter for AvailbelMBytes and its value is 198. Is that...

8 GB Max Memory is configured for INS1 but it is taking only 3 GB. That means it has 5 GB available...

thanks SQLGuru,

I got my answers by reading the article http://www.sqlservercentral.com/articles/FCI/92196/

Excellent article..

We have 12 GB RAM on the node.

8 GB Max Memory

1 GB Min Memory

4 GB left for OS

No other applications are installed other than SQL Server

we do not have a separate drive for Page file on any sql server box from years.

Do we really need to have a separate drive for page file? Having separate...

When I goto DTS package and right click and open, then SSMS is crashing in sql server 2008.

Please see the attachment.

Thank you

Sean,

I executed the below code as you suggested and I'm getting the below results in SSMS

declare @Delete int, @Update int, @Insert int

DELETE FROM [dbo].[DATA_EWT]

...

below is the pl-sql code.

It, displays the number of total records inserted/updated/deleted.

If the count matches, will issue COMMIT otherwise rollback.

SET SERVEROUTPUT ON;

DECLARE

v_update number := 0;

v_delete number := 0;

v_insert number...