When implementing SQL Server instances, performance is one of the key factors in determining the success or failure of a database and its applications. The database needs to be responsive to user requests and return query results in a reasonable amount of time. If it doesn’t perform up to expectations, the application will not be used as productively as planned and your database team will spend a lot of time searching for the issues that are slowing it down.
A Little Background on Blocking and Locking
In the SQL Server universe, blocking and locking are unwelcome entities that contribute to performance issues. Before we embark on a discussion of how to resolve these problems, let’s define some terms.
Expert Insight Into the Blocking Problem
One of the goals of this post is to direct the reader’s attention to an informative IDERA webcast. Hilary Cotter, an expert on SQL Server, is the presenter for the webcast which is titled How to Detect, Analyze, and Minimize SQL Server Blocking and Locking. Hilary explains the issues of locking and blocking in great detail and provides recommendations that will help you resolve performance problems with your SQL Servers.
Here’s an overview of the information available in the webcast. It may open your eyes to the blocking problem and what a DBA can do to minimize it.
This just scratches the surface of the information presented in this webcast. Hopefully, we have whetted your appetite for the complete presentation. It is an hour well-spent by database professionals working with SQL Server.
Monitoring the Performance of Your SQL Servers
The webcast concludes with a demonstration of how to address the problems of blocking with IDERA’s SQL Diagnostic Manager for SQL Server. This comprehensive monitoring application for SQL Servers monitors and alerts on performance issues for on-premises and cloud instances of the database platform. It is extremely useful in identifying the problems that are leading to degraded response time.
Locks, blocks, and deadlocks are monitored in real-time for immediate troubleshooting. Historical data can be reviewed to help find recurring problems. The tool’s intuitive interface lets you observe SQL Server activity in multiple ways such as a list of events or a timeline calendar. Index fragmentation is also identified, providing DBAs with targets ripe for defragmentation. Users can create customized baselines against which system performance can be measured to assure they meet business requirements.
The combination of the information contained in the webcast and the functionality of SQL Diagnostic Manager for SQL Server sets up a database team with the ability to tackle blocking, locking, and any other types of performance issues. They will be suitably prepared to squeeze optimal performance from their systems and keep mission-critical applications running smoothly.
Powered by IDERA