|
|
Posted by ROAN on 09/26/18 11:31
Erland Sommarskog napisal(a):
> 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
And there is a problem... all indexes are the same(definition) in every
datatabase, the difference is only in data. So i dont think there is a
problem.
I will be looking slow queries...
But i still waiting for some aditional advices...
Greatings
Navigation:
[Reply to this message]
|