April 15, 2007 at 10:37 pm
Hi
i am new to this forum.
please help wher i can find performance tuning query for SQL server 2000
April 17, 2007 at 3:26 pm
Tough question to answer! I think we need some more input from yourself.
What is the problem you are having exactly?
If you are having performance issues, you can determine which query/queries are causing problems by running a profiler trace. You can copy and past these into Query Analyser, turn on the execution plans and run these. You'll need to look at BOL for definitions of the execution plan output.
Additionally, you can also use perfmon counters to determine possible hardware bottlenecks on the server.
Also take a look at locks (sp_lock), active users (sp_who2 'active').
That should get you started. However, if possible, send additional information and the forum may well be able to give you more specific help with the issue.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply