Thanks Vinod, running an extended event trace may get me some more data on the problem, I am going to look into setting one up.

Thanks for the suggestions guys. The problem with the ETL is that it is a combination of stored procedures (which I can control and add maxdop hints to) and also...

Confirmed same HBA driver version on all nodes (QLogic 9.1.8.25)

Thanks John, I am having our sysadmins check the HBA drivers and settings. It is active-active but during these tests we are running a single instance per node to eliminate...

Ah, thanks Gail. That may be an option. I will see if I can make some progress with this approach and if I run into any issues I will jump...

Gail, I was reading about the different OPTIONS today related OPTION (OPTIMIZE FOR (@Var = xxx)), and in this case I do know the variable that I need to optimize...

Thanks Gail, its Siebel so everything is wrapped up in a nice cursor for execution using sp_cursorprepare. If it were stored procedures I could at least force a recompile every...

Thanks for the response SSCrazy but this article does not really address our issue. We are not suffering from cache plan bloat because of many single use adhoc plans. We...

Your welcome John, I have not seen this as it related to a named instance using the default port number before so this is new to me too. Let me...

Did you try entering the server portion of the instance name instead of the IP address of the server?

Agreed Gail, but assuming non clustered index on the partitioned column, partition elimination does provide a performance improvement. Obviously in your example, the clustered index is going to be the...

I did see a post online that was related to a similar problem, not exactly the same but similar related to the instance status not showing green. That person disabled...

Yea, the browser service is not even referenced when you use the default port number so it sounds like this is just a case where the port number that you...

Yes, I agree more information is required with regards to the indexes on the table. I was just saying that when it comes to partitioning and trying to get the...

You mentioned that the browser service is running on the server where the instance is located? When you log into that server and open SSMS do you see the same...