Anyone?

Any input?

PF - 50 GB applied.

So far no 'insufficeint memory issues' noted, but it could be too early to call it a success.

Haven't restarted the SQL Server services, so the 'lock...

Thanks..yeah that is what we came to the conclusion as well (1.5 X RAM = Page File)

However, since we upgraded from 32 to 64, it comes out to 96 GB...

Additional information obtained;

PAGE FILE Was removed by my server counterpart with the good intention that it should help boost performance (given that we upgraded from 32 to 64 GB recently).

looks...

Thanks a lot to all those who responded with their helpful responses and I am also following the other post which although related to 2008 -- but nevertheless is a...

Not much other than SSIS packages which does the ETL.

I will probably go ahead and apply 'lock pages in memory' and check it out how it behaves.

sorry..it was meant to be a joke.

I understand that I am not providing enough information to get proper feedback, but I am looking at general guidelines for using 64 GB...

that's all i can get for free i guess 🙂

Seriously ..nothing has changed with the exception of RAM upgrade

hey don't ask me to beat myself -- I am supposedly the DBA for this 🙂

I was hoping to...

Appreciate your quick and 'free' response.

32 GB was good enough but apparently 64 GB is not 🙂

anyways, as you can tell I am new to asking at forums for help,...

sorry...i thought this would be an appropriate forum, that is why i changed to this forum

Ok ..I will proceed with exact same permissions in Dev and Prod and check it out.

And sorry, I just thought of using 'Table1' as the table name and when I...

From that I would guess that the user is setup differently on Dev than it is on Prod, you might just check that out.

And on the track of what OPC...

Below are my in-line responses:

Please proceed knowing that this is not an SSMS / Query Analyzer issue. ---- Ok, thanks for teh confirmation.

Hopefully you will find the issue by checking...

I appreciate your feedback.

1.) The Same query with the same user connection, works fine in SQL Query Analyzer.

2.) Also, to re-state again, the same query works fine from SSMS with...