I currently have a query running that typically takes about 5 minutes but it has been running for about 3 hours. I am assuming that the database has run out of space and is growing. We have it set to autogrow. Is there a way to tell if it is growing and how fast?
asked Jun 07, 2011 at 02:37 PM in Default
sp_spaceused will give you the numbers and stats you are looking for. The larger issue is why your query that typically takes 5 minutes has been running for hours. You should run sp_who2 and see if any blocking is going on. If your query is not blocked and is actively running what is it doing? Inserts, updates, deletes? Depending on the action we can direct you in what to look for such as out of date statistics. There are other things too that could be affecting you such as memory and cpu pressure. If you are on a SAN or share the database server with other systems such as a consolidated server or a shared app/sql server. Give us more details please.
answered Jun 07, 2011 at 02:41 PM