Without being able to see the entire SQL statement, it is difficult or impossible to make appropriate index changes or to refer it to developers for refactoring.
LINQ / Entity Framework frequently generates queries that are much longer than this.
We too are using Entity Framework (sigh) and have this issue.
So far my only work-around has been to copy part of the query from DPA, and then run a profiler trace looking for this part of the query until I find the full query in profiler.
If anyone has any better solutions please provide.
This is really troublesome...many of our queries are longer than DPA can handle which is rendering DPA almost useless.
This feature would be really useful when trying to troubleshooting slow running queries as we also suffer from many complex stored procedures which end up longer than the DPA limit.
Please vote up this request.....
Cheers
Entity framework can be a beast! It's really hard to figure out what's up with a query without seeing the full thing.
For example, tell me which table in the following query might need some index tweaking:
/* (inserted by DPA)
Text truncated due to excessive length
*/
SELECT [Project1].[id] AS [id], [Project1]
.[doh] AS [doh], [Project1]
.[C1] AS [C1], [Project1]
.[version] AS [version], [Project1]
.[date_created] AS [date_created], [Project1]
.[has_vn_date] AS [has_vn_date], [Project1]
.[last_updated] AS [last_updated], [Project1]
.[md30] AS [md30], [Project1]
.[name] AS [name], [Project1]
.[on_order] AS [on_order], [Project1]
.[qoh] AS [qoh], [Project1]
.[rf_comment] AS [rf_comment], [Project1]
.[rf_priority] AS [rf_priority], [Project1]
.[rf_qty_wanted] AS [rf_qty_wanted], [Project1]
.[sku] AS [sku], [Project1]
.[supplier_id] AS [supplier_id], [Project1]
.[vn_comment] AS [vn_comment], [Project1]
.[vn_date] AS [vn_date], [Project1]
.[vn_qty] AS [vn_qty], [Project1]
.[qty_backordered] AS [qty_backordered], [Project1]
.[weight] AS [weight], [Project1]
.[assemblyonhand] AS [assemblyonhand], [Project1]
.[laborseconds] AS [laborseconds], [Project1]
.[extrabuildquantity] AS [extrabuildquantity], [Project1]
.[metalsku] AS [metalsku], [Project1]
.[paintsku] AS [paintsku], [Project1]
.[monday_count] AS [monday_count], [Project1]
.[tuesday_count] AS [tuesday_count], [Project1]
.[wednesday_count] AS [wednesday_count], [Project1]
.[thursday_count] AS [thursday_count], [Project1]
.[friday_count] AS [friday_count], [Project1]
.[saturday_count] AS [saturday_count], [Project1]
.[pickup_from_paint] AS [pickup_from_paint], [Project1]
.[received] AS [received], [Project1]
.[can_build] AS [can_build], [Project1]
.[skutype] AS [skutype], [Project1]
.[hasSharedMetal] AS [hasSharedMetal], [Project1]
.[is_Serialized] AS [is_Serialized], [Project1]
.[m12] AS [m12], [Project1]
.[m11] AS [m11], [Project1]
.[m10] AS [m10], [Project1]
.[m9] AS [m9], [Project1]
.[m8] AS [m8], [Project1]
.[m7] AS [m7], [Project1]
.[m6] AS [m6], [Project1]
.[m5] AS [m5], [Project1]
.[m4] AS [m4], [Project1]
.[m3] AS [m3], [Project1]
.[m2] AS [m2], [Project1]
.[m1] AS [m1], [Project1]
.[partqtyshort] AS [partqtyshort], [Project1]
.[partisblocking] AS [partisblocking], [Project1]
.[formed] AS [formed], [Project1]
.[thickness] AS [thickness], [Project1]
.[lasorlaborseconds] AS [lasorlaborseconds], [Project1]
.[adjmd30] AS [adjmd30], [Project1]
.[aeOnOrder] AS [aeOnOrder], [Project1]
.[plOnOrder] AS [plOnOrder], [Project1]
.[lcOnOrder] AS [lcOnOrder], [Project1]
.[bfAdjMd30] AS [bfAdjMd30], [Project1]
.[needsBuilt] AS [needsBuilt], [Project1]
.[shouldBuild] AS [shouldBuild], [Project1]
.[minimumDOH] AS [minimumDOH], [Project1]
.[safetyDOH] AS [safetyDOH], [Project1]
.[leadTime] AS [leadTime], [Project1]
.[minimumOrderQuantity] AS [minimumOrderQuantity], [Project1]
.[needsBuiltAdjustment] AS [needsBuiltAdjustment], [Project1]
.[isDropship] AS [isDropship], [Project1]
.[isDiscontinued] AS [isDiscontinued], [Project1]
.[AdjR7] AS [AdjR7], [Project1]
.[AdjR14] AS [AdjR14], [Project1]
.[AdjR60] AS [AdjR60], [Project1]
.[AdjR90] AS [AdjR90], [Project1]
.[BatchSize] AS [BatchSize], [Project1]
.[AssemblyTimeCategory] AS [AssemblyTimeCategory], [Project1]
.[OrphanBuildLimit] AS [OrphanBuildLimit], [Project1]
.[CycleStock] AS [CycleStock], [Project1]
.[SafetyStock] AS [SafetyStock], [Project1]
.[TotalPartQuantityBackordered] AS [TotalPartQuantityBackordered], [Project1]
.[PaintDensity] AS [PaintDensity], [Project1]
.[ReorderPointBasedOnLimit] AS [ReorderPointBasedOnLimit], [Project1]
.[SystemOfRecord] AS [SystemOfRecord], [Project1]
.[TemporaryAsemblyLaborTimeInSeconds] AS [TemporaryAsemblyLaborTimeInSeconds], [Project1]
.[ShouldBuildLimitingSku] AS [ShouldBuildLimitingSku], [Project1]
.[CanBuildLimitingSku] AS [CanBuildLimitingSku], [Project1]
.[QuantityOnHandStoneEdge] AS [QuantityOnHandStoneEdge], [Project1]
.[ForecastedMonthlyDemand] AS [ForecastedMonthlyDemand], [Project1]
.[BatchSizeForPurchasing] AS [BatchSizeForPurchasing], [Project1]
.[CalculatedPush] AS [CalculatedPush], [Project1]
.[MetalQuantityOnHand] AS [MetalQuantityOnHand], [Project1]
.[PaintDensityMax] AS [PaintDensityMax], [Project1]
.[ReorderPointShort] AS [ReorderPointShort], [Project1]
.[SafetyStockShort] AS [SafetyStockShort], [Project1]
.[OverbuiltShort] AS [OverbuiltShort], [Project1]
.[MinimumRootDaysOnHand] AS [MinimumRootDaysOnHand], [Project1]
.[IsPaintedMetal] AS [IsPaintedMetal], [Project1]
.[OldestBackorderDate] AS [OldestBackorderDate], [Project1]
.[IsBuiltToOrder] AS [IsBuiltToOrder], [Project1]
.[AllocationShort] AS [AllocationShort], [Project1]
.[LeadTimeNeedsBuilt] AS [LeadTimeNeedsBuilt], [Project1]
.[DefaultWarehouseId] AS [DefaultWarehouseId], [Project1]
.[DefaultResourceGroup] AS [DefaultResourceGroup], [Project1]
.[ForecastedMonthlyDemandEvents] AS [ForecastedMonthlyDemandEvents], [Project1]
.[C2] AS [C2], [Project1]
.[LocalSku] AS [LocalSku], [Project1]
.[WarehouseId] AS [WarehouseId], [Project1]
.[ItemName] AS [ItemName], [Project1]
.[QuantityOnHand] AS [QuantityOnHand], [Project1]
.[MetalQuantityOnHand1] AS [MetalQuantityOnHand1], [Project1]
.[CanBuild] AS [CanBuild]
FROM
(
SELECT [Extent1].[id] AS [id], [Extent1]
.[version] AS [version], [Extent1]
.[date_created] AS [date_created], [Extent1]
.[doh] AS [doh], [Extent1]
.[has_vn_date] AS [has_vn_date], [Extent1]
.[last_updated] AS [last_updated], [Extent1]
.[md30] AS [md30], [Extent1]
.[name] AS [name], [Extent1]
.[on_order] AS [on_order], [Extent1]
.[qoh] AS [qoh], [Extent1]
.[rf_comment] AS [rf_comment], [Extent1]
.[rf_priority] AS [rf_priority], [Extent1]
.[rf_qty_wanted] AS [rf_qty_wanted], [Extent1]
.[sku] AS [sku], [Extent1]
.[supplier_id] AS [supplier_id], [Extent1]
.[vn_comment] AS [vn_comment], [Extent1]
.[vn_date] AS [vn_date], [Extent1]
.[vn_qty] AS [vn_qty], [Extent1]
.[qty_backordered] AS [qty_backordered], [Extent1]
.[weight] AS [weight], [Extent1]
.[assemblyonhand] AS [assemblyonhand], [Extent1]
.[laborseconds] AS [laborseconds], [Extent1]
.[extrabuildquantity] AS [extrabuildquantity], [Extent1]
.[metalsku] AS [metalsku], [Extent1]
.[paintsku] AS [paintsku], [Extent1]
.[monday_count] AS [monday_count], [Extent1]
.[tuesday_count] AS [tuesday_count], [Extent1]
.[wednesday_count] AS [wednesday_count], [Extent1]
.[thursday_count] AS [thursday_count], [Extent1]
.[friday_count] AS [friday_count], [Extent1]
.[saturday_count] AS [saturday_count], [Extent1]
.[pickup_from_paint] AS [pickup_from_paint], [Extent1]
.[received] AS [received], [Extent1]
.[can_build] AS [can_build], [Extent1]
.[skutype] AS [skutype], [Extent1]
.[hasSharedMetal] AS [hasSharedMetal], [Extent1]
.[is_Serialized] AS [is_Serialized], [Extent1]
.[m12] AS [m12], [Extent1]
.[m11] AS [m11], [Extent1]
.[m10] AS [m10], [Extent1]
.[m9] AS [m9], [Extent1]
.[m8] AS [m8], [Extent1]
.[m7] AS [m7], [Extent1]
.[m6] AS [m6], [Extent1]
.[m5] AS [m5], [Extent1]
.[m4] AS [m4], [Extent1]
.[m3] AS [m3], [Extent1]
.[m2] AS [m2], [Extent1]
.[m1] AS [m1], [Extent1]
.[partqtyshort] AS [partqtyshort], [Extent1]
.[partisblocking] AS [partisblocking], [Extent1]
.[formed] AS [formed], [Extent1]
.[thickness] AS [thickness], [Extent1]
.[lasorlaborseconds] AS
Disappointed it cuts off before the FROM clause that lists any actual tables (not to mention the WHERE clause)? Me too!
This should be a no brainer! Allow the customer to adjust this variable as needed to accommodate their environment.
So it looks like something has been changed here, and it is allowing values up to 49,999.
Unfortuantely
1) I can't seem to get it to work. Even after setting 49999 and restarting the monitor, I am not getting 49,999 characters
2) I fear this is still not a high enough maximum for us.
Any clarification?
Hi,
This was fixed in DPA 11.0 issue 876043 .
if you are still having this issue, please open a support ticket.
Brian
