performance drop on SQL server

[blom0344]

I am in no way familiar with SQL server (DB2/ORACLE background), but since we have a bought application running on this RDBMS and performance is dropping off, I would like to do a little investigation into this new field.
Main problem is query time-outs and swapping during query execution. What can be done with the standard administration tools SQL server provides? I am used to such fancy tools as TOAD for ORACLE, but in this case I have no special tools at hand. Can someone suggest a strategy on how to handle such an investigation?

Example : I run a simple command line statement in DB2 to check whether reorganization is needed. What is the equivalent in SQL server? T. Blom
Information analyst
tbl@shimano-eu.com

 

[JNC73]

Use the query executionplan option. That will give you an indication of how the statement is run and where optimilisation is necessary.

JNC73