SQL Enlight provides a fast, automated way to ensure that your T-SQL source code fits to your predefined design and style guidelines as well as best coding practices. With its help, you can easily analyze, identify and quickly resolve potential design and performance pitfalls in your SQL Server databases.
SQL Enlight is an advanced,but simple to use software development tool, designed to facilitate, improve and accelerate the database development with T-SQL.
SQL Enlight database analysis features are very similar to performing static analysis to detect and correct defects in managed code. The advantage is that SQL Enlight can make use of the dynamic management information provided by SQL Server in order to provide more detail and accurate analysis results, and to be used to monitor the health of a server instance, diagnose problems, and tune performance.
Database developers and administrators can easily implement define and develop custom rules with just using XPath and XSLT. The analysis rules can utilize the following information to identify query performance pitfalls, index fragmentation issues, missing or not used index cases, and missing column and index statistics: dynamic management views and functions, existing indexes, statistics and query plans.
System Requirements:
- Microsoft SQL Server 2005/2008/2008R2 Management Studio or Microsoft Visual Studio 2005/2008/2010
- Windows 2000, Windows XP, Windows 2003/2008 Server,Windows Vista or Windows 7
- Microsoft .NET Framework 2.0
- 1024MB RAM
- 15 MB hard disk space
Comments