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.
| Author |
Topic |
|
g2559076
Starting Member
5 Posts |
 Posted - 2011-06-18 : 18:59:29
|
| hi i am the beginner of sql server administration so what is the best way to do performance tuning please provide some exampleNarasimhareddySql Server |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2011-06-20 : 02:24:28
|
| this might answer all your questionshttp://www.codeproject.com/KB/database/SQLServerTipsGuidelines.aspx |
 |
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
Posted - 2011-06-20 : 02:38:30
|
quote:
Originally posted by g2559076
hi i am the beginner of sql server administration so what is the best way to do performance tuning please provide some exampleNarasimhareddySql Server
Perforamnce truning is not a single step process!We can tune the performance of the sql server in various level1. Server Level (os) ->check the amount of memory and cpu allocated for sql server. Use Perfmon2.Check SQL SErver have any blocks or Deadlock. Use Activity monitor.3.DB desing.4.Work on Index fragmentation/ausage and statistics5.Finally u work on your Query.Senthil.C------------------------------------------------------[Microsoft][ODBC SQL Server Driver]Operation canceledhttp://senthilnagore.blogspot.com/ |
|
|
|
g2559076
Starting Member
5 Posts |
Posted - 2011-06-20 : 13:15:04
|
| Thank you very muchNarasimhareddySql Server |
|
|
|
g2559076
Starting Member
5 Posts |
Posted - 2011-06-20 : 13:36:17
|
| Thank you very muchNarasimhareddySql Server |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
|
|
|
|
|
best way to do perfomance tuning