DB problem...

[pavan_kashyap]

hello,
my database is getting down slow drastically
i am unable to understand the reason behind it.
A query which usually doesn't take a second to execute is now taking
some min's to execute..
even i have truncated the log ..
and i have even run the DBCC CheckDB.

It runs fine for some time after performing these steps,but suddenly gets down at some point..

help rqd immediately.
thnx & regards
pavan kashyap

[rmiao]

Do you rebuild indexes periodically? Check table frag with 'dbcc showcontig'.

[skhanal]

Did you check if someone has dropped any index?

See the query plan to find out if statistics needs to be updated. Do you have auto updatestatics turned on?