Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Queries Performance and DB Maintenance Plan

Author  Topic 

hnomani
Starting Member

35 Posts

Posted - 2001-10-19 : 10:37:56
Hello,

We are using SQL 2000 on Windows 2000. As the time goes by we have seen the system starts getting slower and the queries which use to run in 2-3 minutes before now takes around 6-7 min.
Is there any kind of maintenance plan we should follow? What frequency? Any books or websites that gives any tips or documentation about keeping the system running stable?

Thanks
Haseeb

   

- Advertisement -