Its a huge huge old system written for sql7. Databases over 200Gb, managment says it does not have the resources to spare to upgrade fully. You would laugh if I...

like Gail said its basically a restart.

instead of doing that next time try

checkpoint

dbcc freeproccache

dbcc dropcleanbuffers

checkpoint

it will have to recompile all the query plans so briefly there might be a performance...

one table take 2.5 hours just to do a 20% update stats, when it runs even though its a quite period we almost always get user complaints aboyt performance.

Does...

Executed as user: aaaa\bbbb. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.

Jeff Moden (5/16/2008)

Edward (5/16/2008)

I am just doing a standard duration trace. I am unable to reboot as it is a live system. I will try flushing the procedure cache ...

I am just doing a standard duration trace. I am unable to reboot as it is a live system. I will try flushing the procedure cache its mainly T-SQL...

how could band width effect my profile trace?

Thats what i thought objects named like that are stats but one I run

SELECT *

FROM SYSINDEXES idx

INNER JOIN SYSOBJECTS tbl ON idx.[id] = tbl.[id]

WHERE indid > 0

and tbl.[name] = 'extracts'

and...

have a look at this

http://ryanfarley.com/blog/archive/2004/03/01/390.aspx

Hope it helps

Thanks for that what is your reasioning to it takeing longer due to disk space?

just look at the clustered indexes. what did this phantom index start with. if it was hind it is a hypothetical index which sql has created. Generaly I delete them,...

I have had a look at my pefmon counters, my system context switches/sec is avg 8800 and my thread context switch/sec is 8500. I have seen them both alot higher...

thanks for that I have done all usual checks and have failed over to a different node and the problem has gone away. The serves are meant to be the...

HI thanks for that I have turned on the trace flags that’s how I found the tables to reindex. I am having problems finding out the tables involved in the...

yes