performance tuning
-
hi all,
can any one tell about the performace turning, when we do the performance turning which are the things need to conside and how we are going to tune the database and based on what
Dinesh
-
http://www.sql-server-performance.com
visiting this site on regular basis is a great place for SQL tuning learning...
-
You are asking very large question in a very small place. I can tell you this from experience that that there is no text book answer to this question. Yes, There are some recommended guidelines you can follow. But ultimately tuning will depend on what kind a system you are running and you would have to watch the system intensely over period of time with different setting.
Tajammal Butt -
I agree with Taj.
If you post some details of any performance problems you may be facing, then may be some of our gurus here offer help.
-
If you want to learn performance tuning you need to learn everything SW as well as HW.
Always ask what you want exactly...instead open question...
MohammedU
Microsoft SQL Server MVP -
The below resources might be useful..
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/rdbmspft.mspx
http://www.databasejournal.com/features/mssql/article.php/1439801
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply