January 28, 2008 at 9:22 am
Hi, was wondering whether someone could advise? We have just migrated to a sql2005 server and am finding the more labour intensive jobs going into a suspense mode, we use sp2 which is what i have seen people recommend but still the same issue.
Any ideas?
January 28, 2008 at 9:46 am
Make sure you have updated your statistics since your upgrade.
SUSPENDED is usually the process waiting for a non-SQL process to complete. Typically this is your query waiting for the disk sub-system to return information so it can be processed, but it could be waiting on memory, processor, network bandwidth, etc.
This is not necessarily a problem. It should be looked at as a possible point for performance imrpovement. If you are finding your processes are taking too long, you should do some work to make sure you are not getting a lot of table scans or very large hash tables in joins. If you are not, then this could be simply indicating that you have optimized your query to the point that the disk drives are the slowest part and there is little else you can do.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply