Tuning your Sql Server DataBase performance:
1. Using Sql Profiler. Using the "Tunning template" record a trace file. Don't forget that if you trace a long period of time you get better tips, but the processing time of such task is not the same (you could always test for yourself).
2. Save the trace file and run it against the Tunning Advisor( included with in the SQL package).
3. Use other tools in order to take numbers about processing time and total # of uses.
4. Apply your modifications and start over until....
You can also make use of a sql stress tool in order to make better use of the Tunning Advisor: http://www.datamanipulation.net/SQLQueryStress/
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment