November 23, 2010 at 7:27 pm
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
Change is inevitable... Change for the better is not.
November 24, 2010 at 1:56 am
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 🙂
November 24, 2010 at 8:00 am
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
Viewing 3 posts - 31 through 32 (of 32 total)
You must be logged in to reply to this topic. Login to reply