MS SQL Server MSEQ - Performance problem... again :(

Author

Performance problem... again :(

Marco Pais

2005-03-31, 8:03 pm

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

Hugo Kornelis

2005-03-31, 8:03 pm

On Thu, 31 Mar 2005 19:42:50 +0100, Marco Pais wrote:

>Hi there.
>
>This is not my 1st post related with performance.
(snip)

Hi Marco,

I've seen your posts, but I'm afraid I can't give much advise - except
the advice to post in another group.

This group (microsoft.public.sqlserver.mseq) is devoted to Microsoft
English Query, an add-on to SQL Server. Your questions would probably
fit better in either microsoft.public.sqlserver.programming (for writing
and tuning Transact-SQL queries, stored procedures, triggers, etc) or in
microsoft.public.sqlserver.server (for general questions related to SQL
Server - I guess your current questions would fit best in that group).

Oh, and for your first question (hundred connections from VB frontend
application), you might wish to search for VB groups as well.

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)

Sponsored Links