Posted by Erland Sommarskog on 10/08/26 11:31

ROAN (roan@autograf.pl) writes:
> I need a help in optymalization database. My database is much slower
> than bigger databeses(the same structure, only data is different). The
> porblem is that i can't interfer in the structure - can't change
> procedures, view, select ect..
>
> I dont have any ideas how to speed it up or where can be the problem.
>
> I read some articles I but i still need more information.

The first step is to gather information. Exactly which queries are
running slowly? Which query plans do they have? Could they benefit
from an index? If a certain query runs fine in the other database,
are there any differences in indexing?


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

• Next in forum: Re: Question about Views and sp_refreshviews
• Prev in forum: Re: TCP/UDP ports used for Index server OpenQuery
• Thread view: Re: Database optymalization(??)

[Reply to this message]