Indexes play a critical role in enhancing your database performance by facilitating faster query execution. Having the right indexes in place can speed up the process of fetching data from your underlying tables whereas having redundant indexes can hurt the performance negatively.
We bumped into a Performance issue last week for one of our web application in Production. After doing some research and looking at Logic Monitor reports for web servers and database servers, we figured out that the Deadlocks and Lock Timeouts in the Database have increased considerably.
Your application is bound to grow over a period of time. Sometimes it is critical to test your changes with a bigger workload than your current table size to identify any performance bottlenecks, well ahead of time. Leveraging automated tools to generate a workload for you to test your application makes your lives much easier.
Blocking in SQL Server occurs when a transaction in a database session locks resources that another transaction requires to read or modify. If your application has long term blocking, then you have a problem in your hands to resolve.
SQL Server Management Studio provides a cool feature called ‘Code Snippets’ which can help you to considerably increase your coding speed. Code Snippets are ready made snippets of code, which you can insert into your T-SQL code. As a result, you can type less and generate more code.
How many times have you come across a scenario when you execute a TSQL Query and it just runs and runs, without displaying any results and you wonder what’s going on – and finally end up cancelling the executing query?
In this blog, we will look at a very cool Visual Studio 2015 extension called ‘CodeLens Code Health Indicator’ and its features. This extension shows the current value of the Maintainability Index for our code and provides us insight into… Read More ›
In this blog, we will try to understand the importance of code reviews, classify types of design flaws and identify the code smells using Visual Studio Code Metrics. Why is Code Review important? In a development life cycle, Code Reviews… Read More ›
Are you worried about ‘Technical Debt’ in your project? In this blog, we will try to understand what Technical Debt is, what causes it, how to measure it and ultimately bring it down. What is Technical Debt? Everybody wants to write… Read More ›
What is a Covering Index? An index that contains all required information to resolve the query is known as a “Covering Index” – it completely covers the query. Covering Index includes all the columns, the query refers to in the… Read More ›
Code Snippets are one of the coolest features of Visual Studio, which can help us to increase our coding speed multi-fold times. Good Developers generally use shortcuts and tricks to type less and generate more code in less time. Code… Read More ›
Troubleshooting Performance issues has always been a topic of discussion. As and when a performance problem is highlighted, developers tend to run a profiling tool, at their disposal, to diagnose the issue. Not having access or license for a profiling… Read More ›
samirbehara 