sql server memory

5 common Problems to Troubleshoot with sp_WhoIsActive in SQL Server

by

Fix blocking, full logs, tempdb bloat, memory waits, and “what’s running now” in minutes with these five sp_WhoIsActive commands. Use this tool today to solve your own SQL Server issues. Need more help? We can help with our SQL Server Consulting services or our DBA services. 5 Common SQL Server Problems to Fix with sp_WhoIsActive … Read more

Memory Prices Changed – Have Your SQL Servers?

by

Psst – My services are likely more expensive than the memory your SQL Server needs and wants. Your CIOs and Directors need to stop thinking they are buying servers and components in 2004, or even 2010. I do all sorts of consulting gigs for all different reasons, but a lot of tuning gigs and wellness … Read more