none
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

Answers

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
    Answerer
  • 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.

    Please refer the below link:

    http://www.simple-talk.com/blogs/2009/08/03/stolen-pages-ad-hoc-queries-and-the-sins-of-dynamic-sql-in-the-application/

    (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|

    www.Mssqlwiki.com

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

    Friday, February 15, 2013 5:42 AM
    Moderator
  • 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