other » Page 137 » Developer Team - The Best Site for Developers | Developer's Paradise

SQL Sentry Plan Explorer Pro 2.6

SQL Sentry Plan Explorer Pro 2.6
SQL Sentry Plan Explorer 2.6 | 13 Mb


SQL Sentry Plan Explorer builds upon the graphical plan view in SQL Server Management Studio (SSMS) to make query plan analysis more efficient. It is a lightweight standalone app that contains many of the plan analysis features introduced in SQL Sentry v6, and does not require a collector service or database. Features include color-coding that highlights potential trouble areas, multiple grids and other views to allow for sorting and deeper analysis, and collection of real runtime metrics with the generation of actual plans from within the tool.
Read more

SQL Deadlock Detector

SQL Deadlock Detector
SQL Deadlock Detector | 3.5 Mb


Deadlocks can adversely influence server performance. A deadlock occurs when two or more SQL Server processes each have locks on distinct database objects. While holding on to their existing locks, each process is trying to acquire a lock on the database object that one of the other processes have locked. Because two processes cannot exclusively lock the same object simultaneously, we get a deadlock situation, where both processes are entangled and neither process is able to move forward. SQL Server recognizes this situation and tries to rectify it by killing one of the processes in order to allow the other process to continue. The terminated process is rolled back and then an error is flagged.
Read more