March 4, 2013 at 2:00 am
Hi All,
I have been told that I would be given a production profiler trace to figure out the performance issues during application peak time.
Assuming required properties are chosen while producing trace & SqlServer 2008R2 is the version.
I am aware of some tuning methologies if I identify the bad performing query (adding indexes, re-write logic). However, I need to start from trace and narrow down to bad performing queries. please help me with some formal way how to progress once I receive the Trace.
Any steps/docs would help me to kick start pls.
Thank you all.
Regards,
Suresh
Regards,
Suresh Arumugam
March 4, 2013 at 2:18 am
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 4, 2013 at 2:24 am
Thanks Gail.
I had a high level look at your posts and they look very promising. I am going to work on your steps to have a hands on.
Thanks again.
Regards,
Suresh Arumugam
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy