Re: Performance problem...

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

There are some tools, but they're not really better than what you can do
yourself.

A) Get to know your application. Review the architecture. Have someone
else review the architecture. Most performance problems are the result of
poorly thought-out architecture (for instance, a part of the app that needs
to call back to the database 100 or 1000 times to fill a page, instead of
doing just a single query to get all of the data at once).

B) If you determine it's a database problem, start by profiling for
SQL:BatchCompleted and RPC:Completed events and look at the duration column.
Which stored procedures are taking the longest? Those are your easiest
targets. Start tuning them. Look at the execution plans, look at what
indexes exist, and start making things better.

If you need help with that second step, start by reading everything at
http://www.sql-server-performance.com .


--
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--


"Marco Pais" <mpaisIGNORE@xxxxxxxxxxxxxxxxxxx> wrote in message
news:e$s3iFiNFHA.3328@xxxxxxxxxxxxxxxxxxxxxxx
> 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

  • Looking for consultants for the following direct client positions
    ... information architecture, which maps to the enterprise architecture ... Focuses on enterprisewide data modeling and database design. ... Currently using and 2-4 years experience in Database platform: SQL ...
    (comp.software.testing)
  • Re: Comparing DataSets
    ... This is not our architecture. ... data via stored procedures. ... Yes, the database is SQL ...
    (microsoft.public.dotnet.framework.adonet)
  • Fixed
    ... I also found this article that gives the proper way to move system dbs in sql 2008: ... The model exists where the master states it exists. ... This is the error log prior to detaching the model database. ...
    (microsoft.public.sqlserver.server)
  • Re: CREATE AGGREGATE failed because type Concatenate does not conform to UDAGG specification due to
    ... Go to the Database tab and click on the browse button next to the connection string. ... In the New Database Reference dialog, enter the details for the database where you want to deploy the assembly and create the user defined aggregate. ... I'm trying to do some CLR integration with sql server 2005. ...
    (microsoft.public.sqlserver.programming)
  • CREATE AGGREGATE failed because type Concatenate does not conform to UDAGG specification due to meth
    ... Now register the assembly and the aggregate in the SQL Server database you want ... I'm trying to do some CLR integration with sql server 2005. ...
    (microsoft.public.sqlserver.programming)