by David | Jun 24, 2019 | Performance, Testing
unsplash-logoMartin Adams In my current team, we happen to have Azure Test Plan included in our enterprise subscription. This naturally leads down an investigation to see how this compares to the many other tools and platforms out there. It’s not in the scope...
by David | Dec 16, 2015 | Development, Performance
I’ve spent the day profiling trying to figure out why our RemoteWebDriver usage of Winium.Desktop is so much slower than just running the tests straight through Winium.Cruciatus. The profile yielded that TCPSocket#initialize was the culprit, strange, opening a...
by David | Sep 18, 2013 | Database, Debugging, Performance, Statistics
This is no work of mine but I wanted to highlight it since it´s such a good thing to utilise when optimizing your database and queries. SELECT SUBSTRING(qt.text, (qs.statement_start_offset/2)+1, ((CASE qs.statement_end_offset WHEN -1 THEN DATALENGTH(qt.text) ELSE...
by David | Mar 8, 2013 | Database, Performance
In our environment we´ve got a heavily loaded SQL Server as a trunk in the system. Most systems look like this and sooner or later you will probably want to troubleshoot bottlenecks in this database. From a nice fellow at Microsoft we got handed the scripts from Jimmy...
by David | Dec 7, 2012 | Database, Performance
Stuck without writing rights in a big database? Only allowed to dbo_reader?Then this baby is for you: DECLARE @myTable AS TABLE (rowid int, name varchar) This neat little row can be used instead of temp-tables to store subsets of data to increase the performance of...
by David | Dec 7, 2012 | Database, Performance, Statistics
When using large databases it might be interesting to keep an eye out on what of your tables that actually consumes all that disk. There´s a lot of resources on this out there but I thought I´d repeat it anyways since its such a neat little thing: EXEC...
