Database Optimization Tools

• AER

  SSCrazy

  Points: 2763

  More actions

  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

• michellecourts

  Newbie

  Points: 0

  More actions

  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.