Prepare for an Upgrade with the SQL Server 2016 Upgrade Advisor When you are planning an upgrade to a new version of SQL Server, it is not always obvious what obstacles you might encounter during the actual upgrade. In previous major releases of SQL Server, the Upgrade Advisor tool has been made available only shortly before, or along with, the release of the new version, making it hard to use this resource to plan an upgrade very far in advance.
Explanation of SQL Server IO and Latches Recently, I noticed this intriguing message in one of my SQL Server 2008 R2 error logs: Warning: Failure to calculate super-latch promotion threshold.
This was new to me. I was aware of the notion and some of the mechanics of locking and latches, particularly with reference to diagnosing blocks and being aware of the different behaviors, i.e. the difference between a shared and an exclusive lock. However, as I began researching this error mes
Performance Monitoring with Uptime Come see the newest addition to the Idera family: up.time - incredible IT monitoring. up.time is a unified and highly scalable IT monitoring solution that enables organizations to gain visibility and control over the performance, availability, and capacity of their IT environment; whether on-premisis, remote, or in the cloud