SQL Server Performance Forum – Threads Archive

Help me to improve my database Performance

Dear Experts,
I’m a DBA, Working for a Product based company.
We are implementing our product for a certain client of huge OLTP.
our reports team is facing problem (error: all the reports are timed out).though the queries are written properly, Each query is taking some minutes of time.
I’ve given the command DBCC DROPCLEANBUFFERS.
the time immediately dropped to 10 sec. now my question is :
please suggest me the DBCC commands or any DBA related commands to improve the performance of the application for my reports team. Thanks in advance.
vinod

Do not double post… MohammedU.
Moderator
SQL-Server-Performance.com

]]>