i just tired it seemed fine to me

Try anything above 50 and see if this works.

Maybe not working for < 50 as this is system processes.

DECLARE @Handle binary(20)

SELECT @Handle...

Thats a nice looking page of the

http://www.grumpyolddba.co.uk/monitoring/images/Procedure%20Cache%20Status.mhtml

proceduce cache.

Do you have any more information for this, i.e what do you check

SchemaMgr Store (? IS)

SystemRowsetStore

Looks like it...

So the size in syfiles you have to * by 8 if so i make it

750904 * 8 = 6,007,232 = 6 Gig

But the sysaltfiles is in ?

Can you click on the cluster group your trying to move and see what node it has set in here to move to...lets say you have CL1 and CL2 and...

Use sqlio tools and see what the results are

MEMORYCLERK = SQLBUFFERPOOL

Allocated

1,544

virtual memory reserved 67,190,784

Committed 65,536

AWE 38,469,128

Only thing i see

I have done the lock in pages in memory.

Yes done all the best performance guides.

Brand new server nothing else running on it. No users. Should i do a memory diagnostics

Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.

name ...

Hi there we on SQL 2005 64 Bit, configured the lock in memory pages on windows.

64 GIG

102 Page File

Enterprise Edition of SQL .

AWE is not flagged.

Available Memory 64 G

The Physical...

i created a separate thread so that not to interfere with your thread . Thank you.

oh im not sure if it created it so i continue here.

64 gig sql...

name ...

Hi there, in SQL 2005, SQL Server Memory manager, target and total sever memory.

When first installed and did a few updates etc, the total server memory was 6 gig now...

The physcial memroy, total, available, system cahce,

Commit Charge, total, limit, peak

Under which permon performance object are these.

Thanks

Make sure you did the lock pages with the SQL Server account that runs the sql

and on SQL its self set the Memory and put in the MAX memory...