Viewing 7 posts - 1 through 8 (of 8 total)
I applied CU7, my mistake on not mentioning that ..
March 10, 2010 at 5:25 pm
I applied CU7, but think it was fixed in CU4.
March 10, 2010 at 5:23 pm
One other note, if you a running SQL Server Std x64, in order to get the 'Lock Pages in Memory' feature to work you must be on SP3.
March 9, 2010 at 11:46 am
Well after applying SP3 again, we made some changes to our setup.
1) Created a Domain User to run SQL Server and Agent services under, and changed the account...
March 9, 2010 at 11:40 am
Regarding the % of usage of the pagefile thru perfmon shows 5% while task manager shows like 95%. Don't understand why there would be a difference.
March 8, 2010 at 11:04 am
Additionally the output from
exec sp_configure 'min server memory (MB)'
min - 0
max - 2147483647
config - 128
runnig - 128
exec sp_configure 'max server memory (MB)'
min - 16
max - 2147483647
config...
March 8, 2010 at 10:19 am
The Windows' pagefile.sys is basically 90% utilized, by having I the buffer pool swapped out to disk. There are 10 users connected to the DB and 20GB of RAM,...
March 8, 2010 at 10:15 am
Viewing 7 posts - 1 through 8 (of 8 total)