Really? Yes, if you have fat varchar columns defined in a table and using columns in your frequent/daily queries it can have some potential performance impact. Most of the geeks say that we are creating large varchar columns because it will only use number of bytes it needs to store data, which is, totally “True” … Continue reading Yes, Fat varchar columns hurt performance!
Being a production or operational DBAs, whomever I know may rely on third party monitoring tools, which is not questionable. There are many good SQL server-monitoring tools help us to keep an eye on our database production infrastructure. What I suggest/prefer is to have native alerts as first line of notification or this option could … Continue reading 5 Native SQL Server Performance Alerts