Thanks for the replies guys.

No CXPACKET waits whatsoever, tiny little IO waits but that is about all. Its not the first time I have come across 'best' practices in...

I guess the DTA is helpful...to a point, ish...kinda.

I know its echoing the above but take what it suggests and evaluate yourself prior to implementing, it certainly has the tendancy...

Hi and thanks for the reply again.

Yes thats my problem, its a base install of SQL 2012 and SP1 and nothing else, but CU9 for example wont go on and...

Hi and thanks for the reply, yes the CU's that I have tried are for SP1 - the latest CU9 for example.

D

Also makes no sense why I put this in the 2008 forum!

Yes I tried previously and no luck - same with rebuilding the clustered index, we're not presently in a...

Hi all and apologies for bringing this post up again.

I've done some more digging and looking into the dm_db_index_physical_stats have found the following:

CLUSTERED INDEX: LOB_DATA

Page Count = 26915075

Record_Count = 1702573

Ghost_Record_Count...

Thanks all, always had the concept but good to read in a little more detail!

Thanks again

D

Many thanks for the response, appreciated.

I have another question leading on from this. If the server is involved in an SSIS package as either a source or destination would...

Right resolved, the account needed to be in the agent operator role, that with the execute rights has been enough to get me by.

D

Thanks Markus, appreciated 🙂

D

http://technet.microsoft.com/en-us/library/bb630354(v=SQL.105).aspx

But if it was non cluster, just stand alone?

Please, tell me to bu@@ar off if you grow tired of my questions!!!!

David

So, and apologies for my many, many question, the likes of this article here

http://technet.microsoft.com/en-us/library/ff878473.aspx

the secondary replica would have to be on the same cluster?

Thanks

D

May I ask another question Perry. With regards to AlwaysOn, is it possible to have a 2 node cluster, availability group configured accordingly and then add a secondary replica...

Yes indeed and at the same time, thats why I need to act on your advice and guide them 🙂

D