Israeli SQL User Group September 2009

I spoke about Locking and Concurrency in SQL Server.

The session focused on the different lock types available with SQL Server and how they affect database concurrency.

We looked at the available Concurrency Models supported by SQL Server, Isolation Levels, Lock Modes, Conversion Locks, Lock Duration, Key Locks, Lock Starvation, Lock Escalation, Table Hints and how we can resolve Blocking issues and improve Concurrency which in terms improves our applications response time.

The presentation includes many examples in T-SQL that you can try out for your self to see with your own eyes which helps remembering better.

To download the presentation:
http://www.sqlserverutilities.com/download/Locking-Concurency-ppt.zip


-Yaniv
====================================================

SQLScripter version 2.0.0.0 is now available for download

After three years being widely distributed as a free software SQLScripter now requires a license for the fully featured Standard Edition while the Freeware Edition is still available and remains free but gets limited in features.


To go to the Product Details page:
http://www.sqlserverutilities.com/SQL-Server-Utilities-SQLScripter-product-details.htm

For additional details and a comparable table see the ReadMe file

To go to the download page:
http://sqlserverutilities.com/SQL-Server-Utilities-SQLScripter-download.htm


-Yaniv
============================================

BlocksTracer is now available for download

I would like to share with you BlocksTracer - a utility I recently developed.
BlocksTracer is a Monitoring (and diagnostic) tool helping to troubleshoot blocking and concurrency issues.

This tool monitors and captures SQL Server’s blocking locks that occur inside the database engine and provides an insight to this crucial information at real time so that when a blocking event occurs you get to know about it immediately on the spot.

In addition to real time notification all related data such as the blocking statement, the statement blocked, the blocking host, the host being blocked, program, database, duration of the block…. and more, are kept in a database allowing you to further investigate latter on. You can also perform various queries against this important data which will teach you a lot about the concurrency your database(s) provides. Armed with this information you now know what areas/ statements require a modification in order to improve concurrency which in terms will improve applications response time.

Running BlocksTracer on a production environment provides a central repository holding every blocking issue that occurred on any one of the servers being monitored.

To read more go to: http://www.sqlserverutilities.com

To download the Freeware version: http://sqlserverutilities.com/download/BlocksTracer.msi


-Yaniv