May want to run sp_blitzindex from Ozar to get a handle on what your indexes are really like, in some cases unused indexes are as much a problem as missing,...

thanks that did it found what you had given me in an old substring sample I found

Found out cant use rule and message with their app, looks like constraint syntax is a little different if I want to allow any numeric values up to 5

ALTER TABLE...

luckily or sadly depending how you look at it we will be lucky to get to 2012 this year, bigger problem with their custom code is to try to get...

brainfreeze over remembered syntax

CREATE RULE phonext_rule

AS

@value LIKE '[0-9]'

terrible getting old

what is the PLE like?

you may try this for starters, your wait times could be the key, over 30 does sound like an issue

http://www.brentozar.com/archive/2012/03/how-fast-your-san-or-how-slow/

look at brent ozar's blitzindex, awesome tool and free. before you do what I did years ago and jump on the add index (unless this goes against sql you...

thanks, this is an internal sql server (hopefully wont be getting restarted on any regular basis other than maintenance)

you are correct, 2nd instance will use dynamic port not sure if changing the port is that essential or not

when I put it back but drop the unique part I save 30% on logical reads.

I used Brent Ozars blitzindex, not sure if he would ever check for a duplicate unique index, if the transaction_id is unique there is no logical record that would...

that i get the issue is it is going to try to force uniqueness when it is not needed, if the transaction_id is unique the engine is forced to look...

the cluster is a standard active/passive cluster, the other node will actually be used for reporting. Forgot to mention will add a stand alone win2012/sql2012 machine for DR

should have elaborated plan is

have a win2008/sql2008r cluster log ships to a stand alone 2012/sql2008r2 server.

Plan on killing log shipping upgrade win2012/sql2008r2 box to win2012/sql2012

Take one node out of win2008/sql2008r2...