Slow Queries

[Jai]

Hi,
Some of my queries are running too slow.It's taking as long as 30secs .Earlier the same query was taking less than 5 secs.
I understand the db has grown BUT I do not know to look at this query where should i start from and what should I look into.
It is on production server.
the db size is 15GB and unallocated is 9GB.
log space used is 4%.
TIA.

[Dale Shaw]

Hi

SQL 6.5 or 7 / 2000?

If 6.5, check that you have the correct indexes and do a DBCC UPDATESTATS (excuse me if the syntax aint 100%) on the tables. Easiest way is just to use Maintenance Wizard.

For 7.0 and 2000, update stats is automatic unless you have disabled it (common on larger databases). Once again, try updating stats. In addition, 7 and 2000 allow you to do an Index Analysis within SQL Query Analyser. Give this a try. It's not perfect but may point to an index you might need.


Dale