Viewing 15 posts - 9,301 through 9,315 (of 49,571 total)
sqlbuddy123 (4/14/2014)
AWE needs LPIM to be enabled but not vice versa (Ex: 64-bit systems).
Not true. Once Locked Pages is enabled, memory allocations can be done via the AWE mechanisms,...
April 15, 2014 at 1:02 am
SQLRNNR (4/14/2014)
GilaMonster (4/14/2014)
Hmmm... http://www.sqlservercentral.com/Forums/Topic1561455-146-1.aspxYeah looks like it was removed.
No, I linked it wrong.
If you're going to be around a bit, could you watch that one and this one please?
http://www.sqlservercentral.com/Forums/Topic1561627-1550-1.aspx
April 14, 2014 at 5:02 pm
Which counter exactly?
If you really do mean the 'log cache hit ratio' then that's got nothing to do with the buffer pool, nothing to do with optimise for ad-hoc usage...
April 14, 2014 at 5:00 pm
Hmmm... http://www.sqlservercentral.com/Forums/Topic1561455-146-1.aspx
Edit: Fixed link
April 14, 2014 at 4:43 pm
EXEC sp_configure 'AWE Enabled',0
RECONFIGURE
It shouldn't be on for a 64-bit process.
Looks like someone's been playing fast and loose with your config settings.
April 14, 2014 at 4:40 pm
sqlbuddy123 (4/14/2014)
My question was Why is this dependency and how can this be justified ?
When the Windows Engineers were working initially on AWE for 32-bit processes they implemented it with...
April 14, 2014 at 4:38 pm
I just explained that
AWE memory is allocated using the AllocPhysicalMemory API call (I'll get you the actual API function name if you want). Only applications with the locked pages in...
April 14, 2014 at 12:19 pm
sqlbuddy123 (4/14/2014)
It's bit weird bcs they both do different functions and still MS interlinks them.
No, they don't do different things. MS interlinks them because they're actually the same thing under...
April 14, 2014 at 12:08 pm
DaveK2014 (4/14/2014)
I Tried running each one separate and all of them together and they give the same errors see attached. Maybe I have something wrong.
Looks like someone has tried to...
April 14, 2014 at 12:04 pm
Please note: 5 year old thread.
April 14, 2014 at 12:02 pm
essue006 (4/14/2014)
No need to learn new features because there aren't many?
There's quite a lot of new features.
April 14, 2014 at 11:58 am
sqlbuddy123 (4/14/2014)
I'm not sure why MS interlinked both of these settings.
Because they're very tightly linked.
AWE memory is allocated using the AllocPhysicalMemory API call (I'll get you the actual API function...
April 14, 2014 at 11:56 am
mlwiller2 (4/14/2014)
So is LPIM not a requirement for AWE to function (just a recommendation)?
It is a requirement.
April 14, 2014 at 11:53 am
cppwiz (12/19/2013)
Why didn't they just name it SQL Server 2012 R2?
Because the R2 naming was incredibly unpopular in SQL 2008 and the marketing team learnt better.
April 14, 2014 at 11:51 am
And you left out the main piece I was interested in.:-)
x86 or x64? Is the OS x86 or x64? If you're not sure, just post the output of SELECT...
April 14, 2014 at 7:23 am
Viewing 15 posts - 9,301 through 9,315 (of 49,571 total)