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 Development (2000)
 Database maintenance.

Author  Topic 

niranjankumark
Posting Yak Master

164 Posts

Posted - 2007-10-13 : 05:43:20
In my server query execution process is very slow.For that i did index tuning,defragmentation, statistics updation and query changes.But the performance not improved dramatically.
After doing this changes 2 minutes only reduced from 10 minutes.
What are daily task for DBA to improve this DB performance.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-10-13 : 21:46:08
Why you generated 5 posts for same issue? How faster do you think should be? Don't know how people can help you without knowing your query, table schema and data involved.
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2007-10-14 : 01:06:03
Very diplomatic rmiao
Go to Top of Page
   

- Advertisement -