Forum Post: RE: Difference between logical reads and record reads

  • Thread starter Thread starter Rob Fitzpatrick
  • Start date Start date
Status
Not open for further replies.
R

Rob Fitzpatrick

Guest
Hey James, Do you routinely set the -tablerangesize and -indexrangesize startup params on your databases? I find it's a helpful practice to do so. You don't always know when or where you'll want to look at CRUD stats in the future, and when you do it isn't always convenient to bounce the DB to set these params. If they have been set properly (i.e. above your highest table # and index # respectively, assuming the -basetable and -baseindex params are set to 1), as Tom said you can read the data from _UserTableStat and _UserIndexStat for just the clients you are interested in, which will eliminate the "noise" of CRUD from other clients. You could also use the QryInfo logentrytype and/or -zqil to get some additional info on how your queries are being resolved, which index(es) are selected, and how well you're bracketing on them.

Continue reading...
 
Status
Not open for further replies.
Back
Top