i would start a profiler trace and capture the 'Tuning' template. dump it into a database and sort by 'Duration'

the text data for the highest duration numbers can be sent...

here is what i do within maintenance jobs. basically, what it does is pauses the mirror before whatever you want to do. in your case, a reindex.

I would create a...

some things can be done to help.

one thing i look at is how many indexes there are and if they set to auto-update stats. I have found some systems that...

does table TeamManHours have some sort of relationship with table Darhead?

only static reports are available (unless you created your own interface)

http://msdn.microsoft.com/en-us/library/ms181149.aspx

but creating a VB form to do this would be very simple because SQL gives us;

sp_help_log_shipping_monitor_primary and sp_help_log_shipping_monitor_secondary

you...

http://msdn.microsoft.com/en-us/library/dd239406.aspx

yes, you can take the app code out of mirroring by using virtual DNS entries. But, there is not a way to "automate" it.

we use a Global Site Selector from...

well, you might be killing yourself for no reason.

here is what we do in my shop...

we san mirror everything but C: (the boot device)

upon failover, we issue this command

sp_dropserver 'old_server_name'...

im going to post this because google brought me here and there was no answer. Now, i have an answer so i will share....

my agent also disappeared from an install...

yes.

the removing happens there. the Endpoints would be at both instances.

no, its not the same.

you want to remove. you shouldn't have to stop since it is not running anyways.

after you remove, browse to the objects called EndPoints in Management Studio...

in the lab i have setup a Metro Mirror on and IBM SAN. failover is not automatic. you have have to 'break' the mirror. Once the mirror is broken, the...

because by design, you cannot connect to a SQL 7.0 database through sql 2005 management studio

it looks like it was failing and recovering alot before the reboot.....

however, it seems to have always recovered.

You should be able to just stop mirroring and delete all references to...