SQL Server Performance Forum – Threads Archive
Help me to improve my database PerformanceDear 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.
Do not double post… MohammedU.