Post reply

Database Optimization Tools

  • June 4, 2002 at 9:48 am

    #157733

    Our company runs SQLServer 7.0 with a compatibility level of 65.

    I was looking for the tool on the market to optimize my database performance.

    I came across "Coefficient" tool of Intrinsic Design, Inc. I downloaded the trial version of their software but couldn't run it because unfortunately it does not support a compatibility level of 65.

    Can anybody recommend me any other good analyses tool which supports different levels of compatibility.

    Thank you in advance.

    Alex

  • July 4, 2023 at 4:07 am

    #4226366

    This reply has been reported for inappropriate content.

    Here are a few suggestions:

    • SQL Profiler: SQL Profiler is a built-in tool in SQL Server that allows you to capture and analyze SQL Server events, including query execution, stored procedure calls, and other database activities in bloxd io. It can help you identify performance bottlenecks and optimize your queries and database design.
    • SQL Trace: SQL Trace is another built-in tool in SQL Server that allows you to capture and analyze SQL Server events. It is similar to SQL Profiler but provides a lower overhead and may be more suitable for your older database platform.
    • Microsoft Performance Monitor: Microsoft Performance Monitor is a built-in tool in Windows that allows you to monitor and analyze system and application performance metrics, including SQL Server performance metrics such as CPU usage, disk activity, and memory usage.

  • September 19, 2024 at 8:53 am

    This was removed by the editor as SPAM

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply