SQL Server needn't be recycled for changing the MAX Memory.

If using TSQL then the it should look like this

sp_configure 'show advanced options', 1;

GO

RECONFIGURE;

GO

sp_configure 'max server memory', 6144;

GO

RECONFIGURE;

GO

Also if there is...

Please find the attachement. Actually I got the script from the web. I don't remember from where. All credits to tha actual author.

...

Hi Csoloway,

You should use this translator.

...

One Alternative ...

You can Grant Execute Privileges on that Proc to that non sysadmin user so that he can execute it.

...

It would be better to change it in Server properties in SSMS.

...

It doesn't need a restart.

Thank You,

Best regards,

SQLBuddy

I don't think it's a good idea to continue with the installation. It's only an invitation to problems. Please run the CHKDSK utility to possibly fix the problem before you...

Yes. Let's be optimistic. Please try that and we will proceed from there.

...

Lock pages in memory matters a lot... at least for this scenario

1. First try to check for the Page File activity during the Package runtime. You can use Permon to...

Adding a second log file won't help you. SQL Server fills the log file sequentially.

Try to identifty the cause for the blocking and try to reduce or eliminate it.

...

Max Memory only specifies the upper limit for the SQL Server Buffer Pool but not for the Non-Buffer Pool Memory and hence the utilization > 5 GB.

...

Hi Subha,

From what I remember...

...

Also PAGEIOLATCH_SH indicates a possible I/O bottleneck on the server. Often mmeory pressures lead to inreased I/O.

Please check if you are having any memory pressures...

Check the following counters..

1. Buffer Cache...

Update statistics... Check if have outdated ststistics.

No matter how good indexes you have on your tables, if your statistics are outdated, then Query optmizer can't generate optimal execution plans.

Also check...

This would most possibly have occured due to a single large transaction. If you can find the time period during which this happens, you can either use a profiler or...