Why SQL Server 2005 querys' suddenly slow on few tables

H

Hung

Hi,

I used to query against Project Server database (running SQLServer 2005) for
some tasks information without problem.

Just recently, the saved queries didn't return as expected. It kepts waiting
for the data to be return.

I tried to identify the reason, by running a SQL Query Analyzer, and execute
a simple SQL command:

select count(*) from MSP_VIEW_PROJ_TASKS_STD;

or something similar on this table.
And the result never came back unless I canceled the query.

I have no clue what the problem is. Is there an index accidentally deleted
by some reasons?
Your advice on how I can proceed is really appreciated
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top