http://ayende.comAyende @ RahienCopyright (C) Ayende Rahien 2004 - 2021 (c) 202660Yes, you are right, in dev environment we can have indicators, just to find if some queries are really really bad, and then refinement should be made on QA or Production machine. In my opinion the problem is in the hardware: some devs have machine with 2 gb ram and they test on local sql server, but numbers are really really different when you run the same set of queries on a 2xXeon, 12 GB ram and a bunch of SAS 15k iSCSI disks :). alk. http://ayende.com/4554/nhprof-new-feature-expensive-queries-report#comment5http://ayende.com/4554/nhprof-new-feature-expensive-queries-report#comment5Fri, 23 Jul 2010 12:29:29 GMTGian, I agree with you that only on production (or at least QA) you can find the real numbers. But even on non prod systems, that can give you very strong indications about how things are going http://ayende.com/4554/nhprof-new-feature-expensive-queries-report#comment4http://ayende.com/4554/nhprof-new-feature-expensive-queries-report#comment4Thu, 22 Jul 2010 14:47:48 GMTThis tend to be a really really nice feature, but I think that query optimization is best done using a profiler in production environment and finding what is happening during real database usage and in real production machine. Execution time tends to be different from local sql server, or dev machine respect to production one, but surely this is a nice feature to have. NHProfiler really rocks. Alk. http://ayende.com/4554/nhprof-new-feature-expensive-queries-report#comment3http://ayende.com/4554/nhprof-new-feature-expensive-queries-report#comment3Thu, 22 Jul 2010 13:56:35 GMTExpensive means took the longest time. This is calculated on a single query basis, not across all similar queries. http://ayende.com/4554/nhprof-new-feature-expensive-queries-report#comment2http://ayende.com/4554/nhprof-new-feature-expensive-queries-report#comment2Sun, 18 Jul 2010 08:11:43 GMTWhat is the definition of expensive query? Long execution time? CPU utilization? IO utilization? Heavy locking? Also, the total cost of query (TCQ for CIOs) is calculated by multiplying single query cost by number of query executions / unit of time http://ayende.com/4554/nhprof-new-feature-expensive-queries-report#comment1http://ayende.com/4554/nhprof-new-feature-expensive-queries-report#comment1Fri, 16 Jul 2010 10:38:22 GMT