December 27, 2016 at 10:46 am
December 28, 2016 at 2:57 pm
Indianrock (12/27/2016)
I was reading about these but wondered how they would help when 99% of your sql is ORM-generated? We're able to identify our problem queries, it's just slow and difficult for development to do much about it.
From what I recall DBSophic's full product is pretty darn amazing. You are correct in that knowing the code that is bad won't be the most helpful part of their process for you, but it can actually do more than just show where it hurts. Refactorings of code and proper indexing strategies will be offered up. For the latter it will chew through the workload and determine the extra pain of DML from indexing, won't give you duplicate/overlapping indexes like DTA, etc.
Also, I assume you find your bad code via aggregate trace analysis, query plan hash aggregation, etc and not just looking for singular slow queries?
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply