The problem is that if it is memory the SQL will now use all memory on the machine as soon as you run any processes that is memory intensive 512MB...

I would suggest using perfmon to see what is worst affected. It is most probably your drives as mirroring takes up alot of IO. Please let me know what you...

Just to make sure. Did you check the SQL logs. Also check that you have sufficiant space left on all the databases in the server. Especialy check the log files...

WE had an IO problem on RAID 5. Change to RAID 1 0 if possible. It will improve IO alot. Add more physical drives to the SAN drive. Put the...

I have the same problem. In my case it is not a SQL problem but a script that is run and not commited. One of our processes runs the script...

Thanks that is a great help

So the only way is to restart the SQL service.

Thanks for the quick reply

Hello

Thanks for all the replies. At the end of the day I created a SP on the remote servers that populates a table in the remote mater DB with the...

Hello

Yes these figures I can get from sysfiles. My problem is linking the sysindex table to the sysfiles table so that I can work out the amount of unused space...

Hello

I did us it but it only gives the size of the file not the used space.