Do you have a store procedure which is running longer duration than expected? Do you have a database with performance issues? Are you not sure whether script written is in line with Microsoft best practices ?
Here is the answer , SQL Analyzer tool from HappiestMinds will analyze the sql script for Microsoft best practices and also identifies queries which will have performance issues and provide you the recommendation. The tool can be launched from the mutliple channels such as Visual studio, console, web, windows application.
Tool has 65 rules built in based on Microsoft best practices and also from experience of team. Rules are spread across performance, design and naming convention.
Tool is extremely helpful if you are DBA and managing Production database, it will do review of the script against the rules and provide you the report to deciede for production release. As a DBA you can also define custom rules which needs to be validated for every script release or you can choose to run only required rules for every script release.
Here is the answer , SQL Analyzer tool from HappiestMinds will analyze the sql script for Microsoft best practices and also identifies queries which will have performance issues and provide you the recommendation. The tool can be launched from the mutliple channels such as Visual studio, console, web, windows application.
Tool has 65 rules built in based on Microsoft best practices and also from experience of team. Rules are spread across performance, design and naming convention.
Tool is extremely helpful if you are DBA and managing Production database, it will do review of the script against the rules and provide you the report to deciede for production release. As a DBA you can also define custom rules which needs to be validated for every script release or you can choose to run only required rules for every script release.
No comments:
Post a Comment