After you have updated the index. try the following

did you check the Density of the col?

Sounds like the index might not be using the Density is to large, therefore the...

sounds like you just want to finish setting up the cluster?

http://www.sql-server-performance.com/articles/clustering/cluster_sql_server_2005_p1.aspx

well..yes and no..Just started a new job and its a MESS

The cxpacket I know are caused by no indexes....I have 145 heap tables....not my design!!

I had I/O issues one...

Thanks again....I misspoke...

the article that you referred me to is the one that made since, I saw how they were broken up into the 3 areas and then it all...

Gail....THANKS a BUNCH!

I reread Bob Article and there I see IO latches and NON IO latches.... which is what a EX_Latch is (NON).

🙂

Thanks Gail!

after looking around for a while this was the best example I could find, but this seems to say it could be related to IO...the article you pointed out...

Please follow Gail's recommendations and then we dont have to guess...

with the above requested info we can give you an answer very quickly

Little tough trying to break it down since I dont know what each col does. this would be my best guess on table one....the sec table I am just leaving...

Peter,

Maybe a better way to handle this would be to normalize the design a little further?

If you think this could be a hot spot then maybe BCNF if not...

sounds like you are heading the right directions.

In order to keep the dev at bay heres what we do..

set up Cluster 99.999% uptime.....

set up log shipping for DR to...

One last thought...maybe you need to look at Database mirroring.

You can this will allow you both high availability and the log shipping that you are looking for.

How to: Configure...

Is it possible to create a 2 node (active / passive) cluster where the SQL databases are not using shared storage. I have read a bit about using Node and...

On the Temp Db more then likely you will not need a spindle for each core. my guess is the SAN admin already has an array created and he will...

On the Temp Db more then likely you will not need a spindle for each core. my guess is the SAN admin already has an array created and he will...

One more reason I failed to mention, If you set up Log shipping after you set up the DR you have a place to fail over to when you need...