i like Idera the best. however, it is very expensive.

i would settle for SQL Response, BUT, not the current version 1.3. the new beta version 2 is looking to be...

LCK_M_SCH_M means schema modification.....

yes. there is a performance hit.

SSIS running a package every x minutes will do this very well and we have used this in OLA 1 production enviroments for some time.

we use the following tasks from...

It will do it either way. You can let SQL handle it or you can manually adjust. If you go over 2 instances, you will absolutely need to set max...

no. not that i am aware of.

that is another reason to spin off another instance i suppose. ease of management. i have had to do this in cases where an...

use this instead;

EXEC master.dbo.xp_readerrorlog

scroll towards the bottom and look for

Deadlock encountered .... Printing deadlock information

that is not usually needed since each database can be controlled indvidually.

Normally, i would only spin off another instance for a business or app IF that business or app needed...

idera sql diagnostics manager (if you can afford it) 😉

if you want to see the statement causing the block, you have to set your instance to do so;

DBCC TRACEON (3605,1204,1222,-1)

or alter the startup parameter with the same values 😉

the short answer is 'maybe'.

the other question is; will my app be able to access the 2008 database?

i have found upgrading the DB is the easy part. getting the app...

here are 3 things i know about replication that make it "fun" to Administator

1. all tables to be replicated must have a primary key.

2. any schema change to a table...

your right about AS and isolation. running multiple instances is an absolute requirement if you are to have multiple customers or businesses using it. Each instance will get its own...

i do not think it is possible. i know there are some new SPOC in msdb in 2008 that would go missing if you could restore it from 2005.

you will...

probably over kill , but it will work.

tempdb on it own fast LUN is a must.

model, master and msdb can go together but there is no real need to seperate...