Reece Walsh on 30 Nov, 2017 04:33 AM
Thanks for getting in touch!
I'm sorry to hear you are experiencing these issues.
I've included a link to our Performance documentation here.
I'd recommend reading through this documentation, in particular, the "Troubleshooting" section to work towards resolving these performance issues. I do understand, however, that you are in a position where you are waiting for your IT Group to review the situation.
In the interim, I'm going to move this case over to our internal team to see if they have any other thoughts that could help here.
Thank you for your patience and understanding in this matter, it is greatly appreciated.
If you require any further assistance or clarification please let me know :)
have there been any developments on this?
We are seeing the same problem (current version 2018.6.5; upgrading to 2018.7.14 later this week).
the problem we're seeing is that the timed-out query has to read all of the data in the table from lob; looking at this direct from SQL Server Management Studio, the query currently takes approximately 95 seconds to complete:
WHERE ([JSON] LIKE @accid)
ORDER BY [Id]
There are just short of 10,000 records in the table, but the JSON data is stored in LOB data blocks external to the table structure. No indexing will relieve this situation.
Being able to alter the default timeout from 60 seconds would get around this temporarily, but ultimately the database needs to be better able to cope with scale as "DeploymentProcess" grows.
This is easy to replicate for us; just clicking on "LOAD ACCOUNT USAGE" for any account in "Infrastructure\Accounts" results in this time out.
(0 rows affected)
Table 'DeploymentProcess'. Scan count 1, logical reads 1726, physical reads 0, read-ahead reads 0, lob logical reads 648799, lob physical reads 0, lob read-ahead reads 62889.
SQL Server Execution Times:
CPU time = 45359 ms, elapsed time = 163391 ms.