Work around for SQL server performance issue

Question

Work around for SQL server performance issue

Viewing 3 posts - 31 through 32 (of 32 total)

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

Jeff Moden SSC Guru Points: 1004365 More actions · Answer 1

Gangadhara MS (11/21/2010)
Dear Experts,
We are having performance issues on production server.
The following task i have carried out and i need your suggestion further.
1.I have used profiler to trace the events and found some sp are having higher duration/IO/CPU usage i asked developer to fine tune.
2.There was no maintance plan: i have created with Index rebuild and statistics update task to do the same.
3.I have feeded the Profiler trace output to SQL server tuning adviser(DTA) but ended with "0" recommondations.
Please guide me where and all i need to check further to improve performance.
Thanks,
Gangadhar'

I have to ask, please... how long does procedure #1 take to run?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

grahamc SSCertifiable Points: 6762 More actions · Answer 2

Jeff Moden (11/23/2010)
Gangadhara MS (11/21/2010)
Dear Experts,
We are having performance issues on production server.
The following task i have carried out and i need your suggestion further.
1.I have used profiler to trace the events and found some sp are having higher duration/IO/CPU usage i asked developer to fine tune.
2.There was no maintance plan: i have created with Index rebuild and statistics update task to do the same.
3.I have feeded the Profiler trace output to SQL server tuning adviser(DTA) but ended with "0" recommondations.
Please guide me where and all i need to check further to improve performance.
Thanks,
Gangadhar'
I have to ask, please... how long does procedure #1 take to run?

I also asked 🙂

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 3

Refactoring this stuff is WAY beyond a forum - it simply cannot be effectively done. I agree with the other poster who said it is time to call in a professional tuner.

I also do not believe that memory will help out here but a professional should be able to ensure you have that set up optimally as well. I have to say that if you are not sure you have memory set up on a beefy enterprise edition box you REALLY need a pro to give your entire system and app and database a review. There are likely countless things to be improved!

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