April 2, 2008 at 12:02 am
We are working in sqlserver 2005 database. Each stored procedure having more than 10 tables. Each tables having more than 10 lakhs to 2 crore rows. If we run stored procedures it will take more than 60 min for execution. Please give me suggestion how to improve the performance..
April 2, 2008 at 12:57 am
[font="Verdana"]Hopes, the below URL might help you.
http://www.mssqltips.com/category.asp?catid=9
Even I am blank in this area. Let me know the solution you get.
Thanks in adavace,
Mahesh[/font]
MH-09-AM-8694
April 2, 2008 at 3:15 am
- Did you provide the needed indexes to process your tables ?
- Bol has nice info regarding partitioning.http://msdn2.microsoft.com/en-us/library/ms191174.aspx
- and off course there is still Kimberlys must read WP http://www.sqlskills.com/resources/Whitepapers/Partitioning%20in%20SQL%20Server%202005%20Beta%20II.htm
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply