Caliculation of Stolen pages

Question

• Hi All,

for example stolen pages values is "x". how can we caliculate this value of GB.

is the following correct:

x*8/1024/1024 = GB value

Thanks,

Satish Kumar.

Thanks, Satish Kumar. Please mark as this post as answered if my anser helps you to resolves your issue :)

Thursday, February 14, 2013 11:38 AM

• Each page is 8KB in SQL Server, So your calculation is correct

Stolen pages*8= Stoeln pages in KB

Stolen pages*8/1024 =Stolen pages in mb

Stolen pages*8/1024/1024 =Stolen pages in GB

Thank you,

Karthick P.K |My blogs|My Scribbles|Twitter|My Facebook Group|

Please click the Mark as answer button and vote as helpful if this reply solves your problem

Friday, February 15, 2013 5:42 AM

All replies

• CAST(1. *io/ (1024 *1024*1024) AS DECIMAL(12, 2))AS io_gb.....

Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

MS SQL optimization: MS SQL Development and Optimization
MS SQL Blog: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance

Thursday, February 14, 2013 11:44 AM
• Hi Uri,

I m collecting the values from Perfmon.... How can we do caliculation part of "stolen pages" convert the value to GB's.

To convert GB, please let me know what are the other counters, i need to collect here....!

Please let me know the caliculation part...

Thanks,

Thursday, February 14, 2013 11:46 AM
• Stolen Pages are the number of Pages. So your calculation look good.

(DBCC MEMORYSTATUS is another option.)

Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

Thursday, February 14, 2013 11:50 AM
• Each page is 8KB in SQL Server, So your calculation is correct

Stolen pages*8= Stoeln pages in KB

Stolen pages*8/1024 =Stolen pages in mb

Stolen pages*8/1024/1024 =Stolen pages in GB

Thank you,

Karthick P.K |My blogs|My Scribbles|Twitter|My Facebook Group|

Please click the Mark as answer button and vote as helpful if this reply solves your problem

Friday, February 15, 2013 5:42 AM
• just sharing the information

see-http://support.microsoft.com/kb/907877

Buffer distribution
The next section shows the distribution of 8-kilobyte (KB) buffers in the buffer pool.

Buffer Distribution            Buffers
------------------------------ -----------
Stolen                         553
Free                           103
Cached                         161
Database (clean)               1353
Database (dirty)               38
I/O                            0
Latched                        0

(7 row(s) affected)

The elements in this section are the following:

Stolen: Stolen memory describes 8-KB buffers that the server uses for miscellaneous purposes. These buffers serve as generic memory store allocations. Different components of the server use these buffers to store internal data structures. The lazywriter process is not permitted to flush Stolen buffers out of the buffer pool.

Thanks, Rama Udaya.K (http://rama38udaya.wordpress.com) ---------------------------------------- Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.

Friday, February 15, 2013 8:06 AM