May 1, 2007 at 1:10 pm
Hi friends,
I am new in this MS SQL SERVER plz help me
Current my task is
Improve the performance of T-sql query, stored procedures only
What are the basic steps we have follow to imporve the performance
plz tell me some steps and tips.
Thanku
shiv
May 2, 2007 at 4:04 am
this is just far too general a question - read some of the other threads for pointers.
I'd suggest appropriate training, buy some books, and look through the articles written on this site about tuning, there's been a lot ( some not so good ) but each will probably have a discussion thread which will give further insights.
You just can't post a question as you have.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
May 2, 2007 at 9:45 am
You can look at the graphical execution plan in Query Analyzer (select SQL statement or statements and press Ctrl-L) to get some idea of what part of a query is the most time-consuming. You might be able to rewrite the query to improve performance, or modify index structures.
The Index Tuning Wizard can help, although you need to understand the effect of the recommendations it gives you to decide whether to implement them. It can recommend a lot of compound indexes that may do more harm than good.
May 6, 2007 at 12:09 am
Hi Friend,
Give some suggestions which sites i can search for this question plz help
tell me ARTICLES sites plz
thanku
May 6, 2007 at 8:18 am
This website is a good place to start. There are other websites, like http://www.sql-server-performance.com/
Microsoft has a lot of information and blogs. Books Online has a lot of good information. But you'll have to do your own research and experimentation, it's not like we can just give you the secret handshake and magic incantation and you're suddenly an expert.
May 8, 2007 at 6:22 am
Unfortunately, performance tuning can be very dependent on your environment so it's very hard for us to say, do it this way and it'll always be better. Sure there are some absolutes, but for the most part everything is prefaced with IT DEPENDS or Appended with "Try it and find out how it works for you". Something that will work really well in my environment may actually cause yours to respond more slowly.
As a starting point take a look at some of the articles on this site... you can find a list of performance related ones for SQL 7.0/2000here... http://www.sqlservercentral.com/articles/articleList.asp?categoryid=30
And for 2005 here...
http://www.sqlservercentral.com/articles/articleList.asp?categoryid=142
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply