Recommended reading from mrdenny for February 21, 2014
This week I’ve found some great things for you to read. These are a few of my favorites that I’ve found this week. Troubleshooting Common Performance Problems with Memory-Optimized Hash Indexes Recovering the tail end of the transaction log Wait Statistics in SQL Server SQL Server – Automatic Page Repair in Database Mirroring Japan’s Nuclear […]
Old vSphere, Large VMs, and Some Really “Funky” Problems
Recently a client was having some IO performance problems so they decided that the easiest solution would be to through an SSD under the log files on the VM. Easy and cheap solution. The server in question has about 50 databases on it. In order to speed up the transaction log file transfer I decided […]
Recommended reading from mrdenny for February 14, 2014
This week I’ve found some great things for you to read. These are a few of my favorites that I’ve found this week. What Developers Can Learn From Healthcare.gov 10 Tips to Master the Mysterious Developer Interview Ask Professor Kevin Fu About Medical Device Security Think Before Starting a Community U.S. Olympic bobsledder Johnny Quinn […]
How Much Is That Query Costing?
When we think about the cost of the query we typically think about the cost which SQL Server assigns to execute the query. However when we look at performance tuning queries there is another cost that we need to think about. This additional cost is the cost to the company while the query is running. […]