You will need to add new cluster disks for any new instances (for data/log/tempdb) as they cannot share with an existing instance. The SqlServer installation binaries\etc will install on the...

For DR purposes we have a 2008R2 (OS) cluster set up with multiple 2008, a 2008R2, and a few 2005 instances configured.

bump, any advice?

Agreed - but this is still easy to add a new file after...

The only time I have ever needed to use updateusage was when I had a negative page allocation. It is possible SqlServer had an incorrect value for that table or...

curious question - how much memory do you have on the machine.

These rebuilds need locks, which can be causing your time to climb. Do you have Enterprise installed?

if it just for a quick look - you could query sys.objects / sys.columns / sys.tables for what you want, then run the same query over linked server and put...

Hopefully you have sourcecode control - that would be one place. you could look for these triggers in your stored backups by restoring the db somewhere else or as a...

Is the table being accessed during this maintenance period?

smcguire (4/10/2013)

---

I recently discovered the original stored procedure that you referenced. The one issue that I have with it is the limitation that it runs on ALL databases! ...

I do what above members have noted in looking at the index updates but add a server side trace for logins as well

take a look at the mail tables

i use these queries

select * from msdb..sysmail_event_log order by log_date desc;

-- all mail sent

select top 100 * from msdb..sysmail_allitems order by sent_date desc;

--...

TheGreenShepherd (10/26/2012)

---

I'm confused - is the query that you killed the query that you were using to do index maintenance? And that was running for 4 days before you killed...

I think your best bet would be to use a conversion tool like http://blogs.msdn.com/b/ssma/archive/2011/04/29/converting-from-mysql-to-sql-server-working-with-data-types.aspx ... That is where I would start