performance Tuning

Question

performance Tuning

subha.msc2007

Mr or Mrs. 500

Points: 519
More actions
May 22, 2010 at 5:04 am

#219198

hi,
my application is running very slow on past one hour?
basically what should i do?
plz help me immediately....
Subha
Jr DBA

Viewing 6 posts - 1 through 5 (of 5 total)

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

If you want immediate help, consider hiring someone.

Your question is very wide, there could be any number of things wrong. Have you checked for blocking? Is there anything unusual running?

These articles may be worth reading

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/

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Grant Fritchey SSC Guru Points: 398707 More actions · Answer 2

The best way to deal with sudden issues on the database is to prepare beforehand. Know how to look for contention. Know how to look at the processses that are currently running. Know how to identify blocking processes. Know how to observe waits. Know how to get into the execution plans for queries on the server. Study all this stuff so you know how to do it before it's an emergency. Think about it like CPR. You don't want to be standing in front of someone having a heart attack and then shout out to the internet, "Hey, how do you do CPR?" It's too late at that point. Same thing with your database.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

ashish 10950 SSC-Addicted Points: 422 More actions · Answer 3

Hi ,

I faced the same problem with one of database when i joined new company, first think if its real urgent , figure out the process(Sp's ) which are taking lot of time , through that sp's or process figure out what are the indexes you can built and what are the indexes you can drop , for these purpose you can use DTA tool , or Actual execution plan which come free with Sql server . I did that and found it real good as for that time period i was not having time and it was impacting business a lot , once the system boots up , i took my time to figure out the problem and solve the futher issues.

Hope it Helps

regards

ashish 10950 SSC-Addicted Points: 422 More actions · Answer 4

Just Execute SP_WHO2 Active and figure out if something is blocking your process, if blocking process is there the check for it using DBCC inputBUFFER(SPID) .

Check for CPU and RAM Utilization too

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 5

Your signature says you are a Junior DBA. I would have the Senior DBA investigate. 😀

Gail actually gave the best advice for this scenario - hire a professional. With remote access to your system it would take a qualified tuning expert (there are several independent consultants on this site that would qualify) could likely figure out one or more reasons within minutes.

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service