You can try checking your DMV's. here is a good link that should get you started..

http://sqlserverperformance.wordpress.com/2008/01/21/five-dmv-queries-that-will-make-you-a-superhero/

Thinking it might lock the t-log file and put a hold on the script.

you could, but it would happen in another session, so it might make things worse. You would have to test it. I would rather you put it into...

Personally i would do this...

RAID 1 = OS

RAID 1+0 = data and log

RAID 1 = tempdb

Test the above for performance. The only other option i can think of, that...

Are you doing some sort of bulk insert or any large amount of data modification? We had to update 46 millions records in a database a while back and...

Technically no you shouldn't have any issues because SQL will give back the memory if the OS needs it. But, i have had some performance issues and when i...

I typically try to keep ALL user data in a file group and only system data in the primary group. We setup file groups for indexes, dynamic data and...

When i look at a server for performance this is usually one of the first things i look at to make sure SQL server AND the system has enough memory....

you need to make sure you have both versions of .Net loaded, 64bit and 32bit. You might be able to load it via features in the server administrator MMC.

If you're wanting to backup all databases except for the system databases then select 'User Databases'. This will backup everything EXCEPT the system DB's. So, you will need...

Thanks Gail, this is the option we are currently coding to use this weekend. It was the by DB option to use if the instance configuration wasn't possible. ...

The restores are scheduled to use a SSIS package on a remote server so that will disconnect the job.

make sure your mirroring is synced and the CheckPoints have finished after the backup. We have had similar issues and it's always been one of those two things holding...

You can right click the DB in SSMS and go to properties. That is how i find it, or are you trying to use T-SQL only? Then you...

thanks for the quick reply. That is what i am currently doing but would rather set something at an instance level instead of a DB level. The problem...