SQL Performance Queries - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

SQL Performance Queries

Author

Topic

sanjay5219
Posting Yak Master

240 Posts

Posted - 2014-06-10 : 04:23:30

Hi All,

Do we have any pre defined queries from Microsoft which gives the idea to check SQL Performance. My application is running slow now days and wanted to check if any queries/functions/data/indexes creating these problems.

Please suggest

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2014-06-10 : 05:02:10

Performance tuning is a BIG topic :)

maybe you will find something helpful here:
https://www.google.de/?gws_rd=ssl#q=sql+server+2005+performance+tuning

Too old to Rock'n'Roll too young to die.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-06-10 : 12:16:58

Here's where I would start:
1. Blocking
2. PerfMon - any hardware bottlenecks
3. Profiler/Server side trace - identify long running queries, high reads, high CPU
4. Wait stats
5. Missing indexes
6. Code refactoring and fine tuning index based on #3

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources