Thank you , great help.

Morning, not rude at all 🙂 , thank you for taking the time to reply.

I probably should have explained more clearly sorry. There are 2 x FC HBA cards. When...

Thanks again for the posts, certainly plenty to consider. I think the only think i can validate is the integrity of the data we have stored leaving the hardware aspect...

Thank you for the reply. I honestly have no idea , its my directors that have asked me to sign is as the DBA.

Basically what i would be signing is:

1)...

belucey (3/11/2011)

---

I had a similar issue last year , 15-20 min in recovery ever time there was a fail over or a restart of sql and it was taking longer...

Thank you for the reply. The failover time is down to the large number of transactions i think. 100% sure its configured correctly.

Thank you for the reply Sean , agree its ridiculous to a degree, indeed that has always been my argument , what the heck would a user do with a...

Thank you for the reply. Apologies , i had 2 issues that turned out to be the same problem and two threads crossed. Added an index to a table and...

LATCH_EX appears to be the one. Looking at the SP involved (NOLOCK) was added to...

Seriously cannot believe the difference that one index made.

-The table contained 20 columns (int, bi value, decimals, datetime) and only 30,000 rows.

-PK clustered index only.

-The INSERT SP examined this table...

Yes sorry , the Database Engine Tuning Advisor. The barrier to using it for me has always been the need to amend the SP to DECLARE the parameter and SET...

Hi Gail,

Was in the process of creating the query plan to post , as part of this i had to run the query past the optimiser. As part of this...

Just quick point, my issue is to do with INSERT/UPDATE more than SELECT lock, wont adding an additional index simply mean the INSERT/UPDATE will take longer as there is one...

Thank you again for the reply.

1)"The question is, do you know better than the query optimiser for every and all possible parameter values what index is best?"

The answer is most...

http://www.mssqltips.com/tip.asp?tip=1081

Running:

ALTER DATABASE MyDB SET READ_COMMITTED_SNAPSHOT ON

so far on R&D has taken 60mins.

Database in question use CLR and functions, added NOLOCK to select queries a while back but bottleneck...