I need to begin doing performance tuning on my servers. Nobody has ever done
any on them. Should I start with database and server tuning(AWE, filegroups,
Use NT Fibers, etc.) or start with the queries(Indexes, Hints, look to write
better code, etc.)?
TIA, ChrisRyes.
:-)
perf tuning is a hard question as your perf issues could be cause by a
number of things.
the first thing I would do is investigate bottlenecks and Inventory them.
Then, once you've listed all the potential problems, prioritize them by
Impact and Ease of fix. Use that to start knocking them off one at a time.
also spend some time on this sight.
www.SQL-Server-Performance.com
Cheers
Greg Jackson
PDX, Oregon
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment