Viewing 15 posts - 9,301 through 9,315 (of 49,552 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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 14, 2014 at 5:00 pm
Hmmm... http://www.sqlservercentral.com/Forums/Topic1561455-146-1.aspx
Edit: Fixed link
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 14, 2014 at 12:04 pm
Please note: 5 year old thread.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 14, 2014 at 7:23 am
Viewing 15 posts - 9,301 through 9,315 (of 49,552 total)