Is there too much memory for my SQL Server instance? This is definitely an uncommon question I had to deal with of my customers a couple of weeks ago. Usually DBAs complain when they don’t have enough memory for environments they have to manage and the fact is SQL Server (like other SGBDRs) provides a plenty of tools for memory pressure troubleshooting.…
Optimizing Multi-Billion Row Tables in Tabular in 2018 I wanted to attend the session moderated by Marco Russo to see his approach of optimizing performance in Tabular model The first thing to understand is how the data is stored and organized in a Tabular model. It is of course using the xVelocity in-memory capabilities with the Vertipac column storage…
WebLogicServer takes a long time (e.g. over 15 minutes) to startup. Can the performance be improved? Using /dev/urandom option in the Weblogic Java Virtual Machine parameters from startup script, can be the solution. In fact, /dev/random is a blocking device and during times of low entropy (when there is not enough random bits left in it), /dev/random will block any…
