Poor Performance

Question

Post reply

Poor Performance

OnlyOneRJ

Hall of Fame

Points: 3894
More actions
September 10, 2012 at 1:28 am

#267378

Steps to see which procedure is slowing the performance in sql server 2008?
As there are many stored procedure which gets executed on one server & also their are times where the reports are been fetched from the server..
As i have access to SQL SERVER Standard Edition.
I am asked to give details of which Stored procedure is slowing the preformance...Can anyone provide me how should i do it 🙁
************************************
Every Dog has a Tail !!!!! :-D

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

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

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

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

OnlyOneRJ Hall of Fame Points: 3894 More actions · Answer 2

Thanks Gila 🙂

But one more question..

Will the EXEC sp_updatestats; & EXEC sp_recompile 'sp_name';

help to fatser the performance?????

How should i go ahead and use it .. i mean whne thier is no user working on database at that time should i run this commands on all the databases?

And also tell me in how many days should i run this command

************************************
Every Dog has a Tail !!!!! :-D

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

Maybe, maybe not. Depends if the cause of the problem is stale stats. If not, they'll do nothing or slow things down.

Don't try 'shotgun' tuning. Find the problem, fix the problem. Doing random stuff is most likely to just waste your time.

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

OnlyOneRJ Hall of Fame Points: 3894 More actions · Answer 4

Sure Gila, thanks that was a million tons ausome Advise for a fresher like me 🙂

************************************
Every Dog has a Tail !!!!! :-D