I have to say I thought I’d seen it all but this last week brought an event of such magnitude I may be contacting the Guinness Book of Records. OK that’s not true, but I’d like to!
One of our production systems has to support a certain element of real time reporting, now OLTP applications don’t really go hand in hand with Reporting but to be honest not all applications clearly fall into one camp or another; for instance how do you place a financial system – well it certainly supports transactions, but you can’t put all the data in without looking at it – anyway this system difficult to classify.
As part of my monitoring I capture slow running queries as this helps in all sorts of ways, I record cpu, io and duration. Well today to my utmost delight one of our stored procs made an entry on my list with a stunning 1,292,836,673 page reads – impressive eh?
Now a page read is 8kb so I did a bit of rough maths, yup it isn’t very accurate I know, but if you work out the kbx the page reads this proc did the equivalent of reading the entire database 104 times over.
Now I think this is pretty remarkable for a piece of production code, this wasn’t a bug or a new release gone wrong either.
So is this a record or do you have procs which can beat this? Please let me know.