April 15, 2004 at 3:24 am
I need to know how to do a performance tuning on the database structure and stored procedures. So far I had used the Diagram in the SQL SERVER and set the neccessary primary key and foreign key. Sometime when I execute the stored procedures it may give me the timeout issue. Thanks for the advance.
lss
April 15, 2004 at 4:29 am
You should provide more information as for DDL, DML, sample data or any advise will be a shot in the dark.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
April 15, 2004 at 9:32 am
Also, run the queries in Query Anayzer with the execution plan (CTRL-K) set. This can help pinpoint how the query is running and any hot spots.
Brian Kelley has a great book on performance tuning as well:
April 17, 2004 at 4:15 am
In addition to the last post, you can also use ctrl + shft + T (Trace), this gives you a quick indication of which parts of the sp's are taking the longest, then you can isolate the bad part of code and optimise it.
Mark S
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply