RE: sql performance

From: John Bell (JohnBell_at_discussions.microsoft.com)
Date: 09/23/04 

Date: Thu, 23 Sep 2004 00:27:02 -0700

Hi

You should look at the query execution plan, details about these can be
found in books online and in "Inside SQL Server 2000" by Kalen Delaney ISBN
0-7356-0998-5.

If you have your query in Query Analyser, use CTRL+L to display the
estimated execution plan or CTRL+K to display the used plan. This should
indicate where the query is being costly. It could be that the statistic are
out of date.

You may also want to look at using SQL Profiler to check for blocking and to
view what other activity is being processed. If you run Profiler for a period
of time, you may want to use it as input to the Index Tuning wizard to see
what suggestions it may give.

Overall performance tuning information can be found in the "SQL Server 2000
Performance Tuning Technical Reference Manual" ISBN 0-7356-1270-6

John
"anand" wrote:

> In the firm which i am working there is no dba as such
> so we are facing a big problem with the performance with sql server
>
> we have a table which contains lacs of records but when retrieving it takes
> too much time
>
> also ther are 4 to 5 indexes on that tables
> again adding a new index is a great task
>
>
> pls help me with this with how it's possible to make it out
>
>
>

Relevant Pages

  • Re: Whats the deal with PAGEIOLATCH_SH?
    ... Does SQL Server have trouble when a single table is this size? ... About 20 minutes into the query everything goes bad. ... >> go over some threshold, which seems to vary, the disk queue length ... >> I'll work on getting the real execution plan, ...
    (microsoft.public.sqlserver.programming)
  • Re: Database Engine Tuning Advisor suggestion to replace syntax.
    ... query in my query 2 example. ... Tibor Karaszi, SQL Server MVP ... Actually, what I said was "IF this code is running in a stored procedure", not "BECAUSE this ... statement in the second execution with the execution plan generated for the first execution. ...
    (microsoft.public.sqlserver.tools)
  • Re: Database Engine Tuning Advisor suggestion to replace syntax.
    ... What you said was what I first planned to say, but then I read the Books Online which implies that the batch is indeed reused, so I held back from saying that. ... the query optimizer will probably match the Transact-SQL statement in the second execution with the execution plan generated for the first execution. ... SQL Server does not have to compile the second statement." ...
    (microsoft.public.sqlserver.tools)
  • Re: Database Engine Tuning Advisor suggestion to replace syntax.
    ... Actually, what I said was "IF this code is running in a stored procedure", ... execution with the execution plan generated for the first execution. ... SQL Server does not have to compile the second statement." ... replace query 1 below with the syntax in query 2 below. ...
    (microsoft.public.sqlserver.tools)
  • Re: CONTAINS performance
    ... That said, and with the query plan, I can start to give you more ... relational join in the context of the free-text optimization, ... SQL Server tables. ...
    (microsoft.public.sqlserver.fulltext)
Loading