Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Poor Performance Expand / Collapse
Author
Message
Posted Monday, September 10, 2012 1:28 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 12, 2014 12:13 AM
Points: 258, Visits: 690
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 !!!!!
Post #1356581
Posted Monday, September 10, 2012 1:57 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:52 PM
Points: 42,849, Visits: 35,978
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 2008, MVP
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

Post #1356586
Posted Monday, September 10, 2012 3:22 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 12, 2014 12:13 AM
Points: 258, Visits: 690
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 !!!!!
Post #1356607
Posted Monday, September 10, 2012 3:50 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:52 PM
Points: 42,849, Visits: 35,978
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 2008, MVP
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

Post #1356619
Posted Monday, September 10, 2012 3:59 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 12, 2014 12:13 AM
Points: 258, Visits: 690
Sure Gila, thanks that was a million tons ausome Advise for a fresher like me







************************************
Every Dog has a Tail !!!!!
Post #1356624
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse