Friday, March 9, 2012

Negative Stolen buffers value

If I run DBCC MemoryStatus and I get a negative value for Stolen in the
Buffer Distributions section, what does a negative value indicate? For
example:
Buffer Distribution Buffers
-- --
Stolen -228001
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200703/1I'm not sure of it, because you did'nt explain you current "platform", but
meybe the following article could be useful:
http://support.microsoft.com/kb/907877/en-us
(look at NUMA exceptions)
"cbrichards via SQLMonster.com" wrote:
> If I run DBCC MemoryStatus and I get a negative value for Stolen in the
> Buffer Distributions section, what does a negative value indicate? For
> example:
> Buffer Distribution Buffers
> -- --
> Stolen -228001
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200703/1
>|||Thanks Gilberto, but the link you sent did not address a negative value.
We are running SQL Server 2005, SP2 on Win 2K3
Gilberto Zampatti wrote:
>I'm not sure of it, because you did'nt explain you current "platform", but
>meybe the following article could be useful:
>http://support.microsoft.com/kb/907877/en-us
>(look at NUMA exceptions)
>> If I run DBCC MemoryStatus and I get a negative value for Stolen in the
>> Buffer Distributions section, what does a negative value indicate? For
>[quoted text clipped - 3 lines]
>> -- --
>> Stolen -228001
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200703/1|||The link i've suggested is interestinf just because it mention possible wrong
values in NUMA environments. I think a negative value could be interpreted as
wrong, because i don't find documentation explaining otherwise such a value.
Effectively, the article speculates about AWE counters and not Stolen
buffers counter...
Gilberto
"cbrichards via SQLMonster.com" wrote:
> Thanks Gilberto, but the link you sent did not address a negative value.
> We are running SQL Server 2005, SP2 on Win 2K3
> Gilberto Zampatti wrote:
> >I'm not sure of it, because you did'nt explain you current "platform", but
> >meybe the following article could be useful:
> >http://support.microsoft.com/kb/907877/en-us
> >
> >(look at NUMA exceptions)
> >
> >> If I run DBCC MemoryStatus and I get a negative value for Stolen in the
> >> Buffer Distributions section, what does a negative value indicate? For
> >[quoted text clipped - 3 lines]
> >> -- --
> >> Stolen -228001
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200703/1
>

No comments:

Post a Comment