October 21, 2004 at 8:01 am
Hi Friends,
We get frequent complaint from the Users that the application ( 3rd party application, on which we do not have any code accessability). We need to trace the SQL server instance for a day or two to get all the SQLs executed with the execution plan with cost of execution ( like cpu time, io time , buffer/block gets etc), so that we can identify badly performing SQLs and try to tune or ask the vendor to rewrite the SQLs. Any suggestions on how to get this tracing done are more than welcome.
Thanks a lot
Jay
October 21, 2004 at 8:54 am
Jay,
have a look in BOL for 'monitoring server performance, tools'.
The main ones for your purposes will probably be SQL Profiler and Windows Performance Monitor, but the above link will point you towards the comprehensive list out of the box.
There are also 3rd party tools to do this type of analysis (eg Quest software) but for now I'd recommend you start with the standard ones.
Rgds,
Paul Ibison (SQL Server MVP)
>> (recommended sql server 2000 replication book:
>> http://www.nwsu.com/0974973602p.html)
Paul Ibison
Paul.Ibison@replicationanswers.com
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply