by Ken Haff | Sep 13, 2022 | Blog, SQL Server
Multi-GHz processors need maximum memory bandwidth to reach their full potential.SQL Server needs maximum memory bandwidth to reach its full potential. They need to access memory as fast and with as much throughput as possible. A bottleneck develops when processors...
by Ken Haff | Sep 6, 2022 | Blog, SQL Server
A properly designed virtualized SQL Server instance running in a VM with Windows Server (or Linux), using vSphere is crucial to the successful implementation of enterprise applications. One main difference between designing for performance of critical databases and...
by Ken Haff | Jun 23, 2022 | Blog, SQL Server
You can also check out the Recorded Webinar. You may see events in your error logs reporting transient connection failures between cluster nodes or AlwayOn. You may observe high Asynch_Network_IO in [sys].[dm_os_wait_stats]. And you may have even brought it to the...
