Sounds like you came together with previous IT manager, there should've been some collaboration there and possibly compromise, and if you got the ok then what else can you do.  The previous IT...

"Companies will never find this person and instead compromise their choice based on who applies. So, always apply if you meet 50% of the requirements."
This is great advice, it's...

How would SQL Compare help in this instance, when the database was identical on both servers?   (The same database with the same missing index ran fine on one server and...

Ok, I think we've resolved it. After coming full circle with the server, configuration and statistics related things, we went through the stored procedure that was highlighting the performance...

Thanks for all the suggestions guys.  Every bit helps as it kicks me off investigating various avenues.

The SQL Server configuration is the same between the two, basic standard SQL server...

Got the execution plan from the production server.  Turns out quite different, on what are identical databases on both servers.  Took a backup form one and restored to the other.

They...

We've narrowed it down to being a database/server issue.  Not network or front end app related.

While this database runs fine on the development server, it also runs fine at all...

Yes, we have seen this also, in another larger system we develop, but in this instance, the client is not keen on changing the parallelism setting as they're worried how...

Results of the SP_CONFIGURE:

Don't think so, but I'll check anyway.  But if it was indexing or db related, wouldn't we see an even worse performance on the development server (which is lower spec...

Development server has two Xeon processors, and the production server has 4 Xeons.

Database on the two is identical, we re-indexed just to be sure, and did a checkdb which came...

Yes, we've looked at Processor time, Avg. Disk Read Queue Length, Page life Expectancy and User Connections.  Everything we've looked at seems normal.

The production server currently hosts about half a...

I used to ride road bikes...I miss my bike

Traded it in for a pergola...I haven't forgiven myself yet.

Always thought about giving dirt bikes...