Viewing 4 posts - 1 through 4 (of 4 total)
Thanks mate you are a genius!
Just doing some more testing but it's looking very promising. I've set deny on all add / drop / update procs in the SQLAgentUserRole and...
October 24, 2011 at 7:04 pm
The /3gb switch is enabled for the OS only - it allows applications to use 3GB whilst the OS uses only 1GB.
Without specifying memory settings the two instances will share...
October 19, 2011 at 12:47 am
With the default memory settings each SQL Server instance will grab memory as needed. It will cache whatever data it can and if there is memory pressure each instance will...
October 19, 2011 at 12:18 am
Check this link out:
To lock pages in memory you have to apply the service packs and hotfixes and set a traceflag on SQL engine startup
Will.
July 8, 2010 at 11:44 pm
Viewing 4 posts - 1 through 4 (of 4 total)