Post reply

Know read and write ratio before you tune database performance

  • December 14, 2015 at 10:48 am

    #306155

    Comments posted to this topic are about the item Know read and write ratio before you tune database performance

  • December 21, 2015 at 8:36 am

    #1847156

    Good script, thank you.

  • December 21, 2015 at 8:43 am

    #1847161

    Yes, good script. But what its practical usage ? Yes, I found that for most of my tables read ratio is 95%, and what next?

  • December 21, 2015 at 12:04 pm

    #1847231

    I find it useful for tuning. Such as indexing, use of compression on the tables.

    I do have a question though, would it be more useful if this data was collected overtime? For instance, in my environment we are reloading tables every morning and then through the day it is nothing but reads. Would this query still give me a good picture of the read/write ratio?

  • December 21, 2015 at 1:10 pm

    #1847254

    You also need to keep in mind that index usage stats count the number of times an operation occurs, not the quantity of rows affected. That is, "10 scans", say, means ten different times SQL did a scan operation on that table, but each of those scans could have been for 1 row, 100 rows, or 1M+ rows. Thus, the quantity of rows is indeterminate.

    You'd need to use the operational stats view to get individual counts. But, very unfortunately, that view can get paged out and lose existing totals.

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

  • April 26, 2016 at 6:54 am

    #1874562

    NatalyaM (12/21/2015)

    I find it useful for tuning. Such as indexing, use of compression on the tables.

    I do have a question though, would it be more useful if this data was collected overtime? For instance, in my environment we are reloading tables every morning and then through the day it is nothing but reads. Would this query still give me a good picture of the read/write ratio?

    That makes sense to me too. Thanks for that insight.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply