Hi,
can I have your ideas about which database structural and physical elements
I would review in order to optimize some query performance?
Thank you,
ManuTop wrote:
> Hi,
> can I have your ideas about which database structural and physical
> elements I would review in order to optimize some query performance?
> Thank you,
Start by looking at the SQL that's running on the server. You can do
this from Profiler using the SQL:BatchCompleted and RPC:Completed
events. Have a look at the CPU, Duration, and Reads columns. Once you
have a good idea what's not running efficiently, you'll know what
objects to look at for tuning.
Imceda offers Coefficient, a SQL performance analysis tool. You can
download a trial from our web site.
David Gugick
Imceda Software
www.imceda.com
sql
Friday, March 30, 2012
optimizing query performance
Labels:
database,
elementsi,
ideas,
microsoft,
mysql,
optimize,
optimizing,
oracle,
order,
performance,
performancethank,
physical,
query,
server,
sql,
structural
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment