performance related question

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Performance Tuning » performance related question

performance related question

Rate Topic

Display Mode

Topic Options

Author

Message

Oracle_91

Posted Wednesday, February 13, 2013 5:56 AM

Say Hey Kid

Group: General Forum Members
Last Login: Friday, May 17, 2013 4:46 PM
Points: 675, Visits: 1,559

Hi All,

I have a question on performance tuning approach and where should i start and what should be my approach on below.

All of sudden, all of my queries started performing very slow. What can i do even before going to profiler tracing..

Looking for more inputs.

Thanks in advance.

Post #1419444

anthony.green

Posted Wednesday, February 13, 2013 6:09 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

Index & Statistics maintenance would be my first port of call then look at tuning the queries.

Ola has a very comprehensive script which will do the index and statistics maintenance for you, there is a link in my signature.

Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1419452

Oracle_91

Posted Wednesday, February 13, 2013 9:12 AM

Say Hey Kid

Group: General Forum Members
Last Login: Friday, May 17, 2013 4:46 PM
Points: 675, Visits: 1,559

Thanks very much for the pointer.

Post #1419601

GilaMonster

Posted Wednesday, February 13, 2013 9:30 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 10:47 AM
Points: 37,729, Visits: 29,990

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 #1419613

Oracle_91

Posted Wednesday, February 13, 2013 9:35 AM

Say Hey Kid

Group: General Forum Members
Last Login: Friday, May 17, 2013 4:46 PM
Points: 675, Visits: 1,559

Thanks Gail for sharing those links. Thank you. Smile

Post #1419619

« Prev Topic | Next Topic »

Permissions