Performance problem... again :(

Hi there.

This is not my 1st post related with performance. I am experiencing serious
performance problems with a VB6 application running over a SQL Server 2000
database. I have already used SQL Analyser, SQL Profiler and Performance
Monitor to collect data that might help resolve this problem. However, my
dificulty is to analyze this data. Is there any tool that it helps to it? I
have downloaded from Microsofts site a tool that collects, at the same time,
data from Profiler, Perfmon and SQL Analyser. However, I have the same
problem... I can't interprete it. This tool is called PSSDIAG. There must be
some powerful tools that analyse the database and provides some hypothetical
solutions. Tools that tell us what is wrong. I do not know none :(. I would
appreciate some help... some 'freeware' help :).

Thanks in advance.

Regards,

Marco


.

Relevant Pages

  • Re: dbdebunk Quote of Week comment
    ... > a lot of really bad SQL programmers. ... But SQL does not have a pointer data type or the ... > being told to design a database. ... But why is little Cindy Lou Who employee ...
    (comp.databases.theory)
  • Re: DBMS and lisp, etc.
    ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
    (comp.lang.lisp)
  • Re: dbdebunk Quote of Week comment
    ... > a lot of really bad SQL programmers. ... a surrogate key should support the primary key. ... But SQL does not have a pointer data type or the ... > being told to design a database. ...
    (comp.databases.theory)
  • Re: dbdebunk Quote of Week comment
    ... But SQL does not have a pointer data type or the ... More and more programmers who have absolutely no database training are ... But why is little Cindy Lou Who employee ...
    (comp.databases.theory)
  • Re: Just say no to threads [Was: Software architecture]
    ... they knew there was going to be a database in the app. ... Now my colleague just spent a couple/three weeks designing an SQL ... Turns out they have a flat file of sample information, ...
    (comp.object)