Performance issue

Question

Performance issue

dba_neo

SSCrazy

Points: 2673
More actions
April 12, 2010 at 9:20 am

#142536

Team,in one of my prod server we are facing performance problem for a particular dB as users are complaining of slow response time.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

durai nagarajan SSCoach Points: 15778 More actions · Answer 1

Kindly give more information like front end application, slowness in single page(query) or more, try finding out using profiler in sql stmt completed or SP stmt completed which is taking more time.

hope i try to help you

Regards
Durai Nagarajan

ps. One Orange Chip Points: 29422 More actions · Answer 2

dba_neo (4/12/2010)
Team,in one of my prod server we are facing performance problem for a particular dB as users are complaining of slow response time.

I suggest you go through these 2 great articles written by Gail which will help u in diagnosing the culprit queries.

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

Pradeep Singh