"John Bell" <JohnBell@discussions.microsoft.com> wrote in message
news:930109D6-A013-4677-92C9-6AF7C038F4DD@microsoft.com...
> Hi
>
> If you don't have some form of maintainance for these databases then you
> should create one. You could use the maintainance plan although you will
> have
> more control (and possibly a better understanding) if you write your own.
>
> Your statistics could be out of date see http://tinyurl.com/5ahsq, also
> check the query plans to see if your indexing strategy can be improved.
> You
> may also want to profile the system and run the index tuning wizard to see
> if
> it suggests anything.
>
> A good site for information is:
>
> http://www.sql-server-performance.com/articles_performance.asp
>
>
> HTH
>
> John
> "Pohihihi" wrote:
>
>> Hello,
>>
>> I am looking for some tips to tune my SQL server. I have SQL 7 and 2000
>> running on NT and Win 2000 and things are slowing down on SQL servers.
>> Both
>> take many mins to return simple query output.
>>
>> I got some help in this NG before but that was more sort of creating
>> index
>> etc. It was help full but it did not give me much boost to DB. I am sure
>> this might be a solution but what is the right way to apply it and what
>> else
>> I need to take care or do to at least improve 50% performance.
>>
>> --
>> Chang
>>
>>
>>