Thanks both,

That makes perfect sense.

Nic

Hi,

thanks for the additional info, yeah the 'lock pages' did come up but got that one sorted, it all seems to be functioning as expected now.

Thanks,

Nic

Thanks John, i owe you one.

Had a look round the performance monitor seems to confirm that the full 7gb of memory is being used.

Thanks again, much appreciated.

Nic

thanks for the quick response John.

Yes it only has SQL on it, at present it's a sandpit, hence the 4gb, i was thinking of allocating 7gb of the 8gb...

One other thing tho, i have now configured all the switches, if i set the min memory to 2gb, should i see this reflected in task manager or will sql...

Thought as much, just wanted someone to confirm, thanks John.

Regards,

Nic

Thanks Deepak, and everyone else who posted.

So I am right in saying for msdb and model i can either move via an alter statement or by detaching the database.

Thanks again,...

Thanks for that, that makes sense, however why do does the Microsoft article http://support.microsoft.com/kb/224071 do it using a detach and reattach, is this just another method?

Sorry, i realise i can move tempdb by using the alter database code, it's the msdb i want to move using the above method.

Thanks Frank.

Thanks Steve,

Nic

Thats an interesting question, as far as i was aware transaction where managed at the session id, db and object id level.

All this information should be in syslocks, or you...

Thanks Gail,

Thats answered the question, and given me some additional learning material.

Greatly appreciated,

Nic

Hi thanks for the response.

1. Tempdb is located on a different physical disk, which i think like you say maybe the reason for the difference.

2. I am the...

That makes sense, many thanks for you help.