what are the things we need to concentrate on Database side to improve the performance of projects

Posted by Johnseelan under Sql Server on 10/1/2012 | Points: 10 | Views : 1134 | Status : [Member] | Replies : 1
what are the things we need to do (concentrate) on Database side to improve the performance of projects
and
what are the things we need to do (concentrate) on Application side( UI Layer, Business Logic layer Service Layer And Data Access Layer) side to improve the performance of projects

example :
my application page take so much time to load that means so slow , so to improve the performance
1. How to improve performance,
2. what are the things we need to do (concentrate) on Database side
3.what are the things we need to do (concentrate) on Application side

it is very urgent & impotent for me so please help me any one..




Responses

Posted by: Sqldev on: 12/7/2012 [Member] Starter | Points: 25

Up
0
Down
Hi,

Here is a link for some of the performance tuning tips in database:

http://learnsqltips.blogspot.in/search/label/sql%20server%20performance%20tuning%20tips

Also, if you want you can download a query tuning tips white paper from the below path:

http://surefile.org/file/03KBI

Hope this information helps.


Thanks & Regards,
Sql Expert
http://learnsqltips.blogspot.com/

Johnseelan, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response