>OK, let's start here - let's get the fragmentation level of your tables/indexes.
>
>Go ahead and run this code.....
>
>Note at the bottom I put a where condition on - to get the frag levels for a single table. So you can filter on a table, or just omit the where clause and get the frag level for all tables.
>
>Let me know the column values for the table(s) in question. Anything over about 30% means the table should be reindexed, and anything well over 50% can definitely be an indicator of sluggish performance. If all the numbers on your major tables are under 30% then the problem is likely elsewhere.
>
>

>SELECT OBJECT_NAME([OBJECT_ID])  AS TableName,   
>       avg_fragmentation_in_percent AS Fragmentation,
>       fragment_count, page_count
>       FROM sys.dm_db_index_physical_stats
>            (DB_ID(), null, null, null, null)
>            where OBJECT_NAME([OBJECT_ID]) = 'PurchaseOrderHeader' 
>

Thanks, I have enormous numbers on the percentage column on pretty much all big tables.

I will have to perform some indexing and see how it goes.