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 droptable.com
http://www.droptable.com/Uwe/Forums.aspx/sql-server/200703/1
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)
"cbrichards via droptable.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 droptable.com
> http://www.droptable.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:[vbcol=seagreen]
>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)
>[quoted text clipped - 3 lines]
Message posted via droptable.com
http://www.droptable.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 droptable.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:
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums.aspx/sql-server/200703/1
>

No comments:

Post a Comment