02/06/2018
by Marlon Ribunal
Comments Off on Waiting Tasks Reveal Pain Points
Waiting tasks quickly shows you where to look for the bottlenecks. This is only one of the many times that I didn’t have to go beyond identifying the waiting tasks to quickly troubleshoot a production performance issue. I have encountered a … Continue reading
01/30/2018
by Marlon Ribunal
2 Comments
Performance tuning is one of those things that is hard to get right when you do not have an established methodology of how to approach the problem. Consider this scenario. The application users are complaining about their app being so … Continue reading
01/23/2018
by Marlon Ribunal
1 Comment
SQL Prompt from Redgate Software is one of the tools that I cannot live without. Well, that’s probably an exaggeration but I use it daily in my job. Whether I’m writing stored procedures or crunching TSQL codes to troubleshoot data … Continue reading