As I said currently have 10 version I'm looking to install 11

Thank you all for the inputs. Much appreciated!

Is it possible roughly to calculate size of the database based on just the details that I've provided?

If not, then what are criteria that should be considered?

yes, we tried maxdop but didn't help thanks

Thank you everyone.

I can't post the actual query plan because of company policy.

You've been very helpful we've logged a case with MS now

Thank you all for the responses.

I've attached query plan with resrticated and unlimitted memory please have a look.

Thanks

Thanks:)

Thanks Gail.

Client is advising me to increase buffer size but I fail to understand what buffer size to increase when I don’t see any error message in SQL server.

And they...

Thanks Grant.

Transaction logs are growing rapidly during index rebuild transaction log backup is scheduled every 15 minutes still logs are getting big and I have to shrink them all the...

Thanks. I have managed to rebuild indexes and also introducing new indexes helped immensely.

Issue now is with Microsoft ASPSTATE database ‘UPDATE [ASPState].dbo.ASPStateTempSessions’ is blocking every other user process on the...

Thank you all.

How frequently Index rebuild job can be run? every night or weekly?

Thanks. Does updating stats on heap table is of any use?

How to reduce fragmentation <30?

IndexTypeavg_fragmentation_in_percent

CLUSTERED INDEX 97.67442

CLUSTERED INDEX ...

is upadating stats every 15 minutes is a bad practice? I have decided to do that because it has improved perfromance

thanks I updated stats using sp_updatestats and I also used sp_msforeachtable 'UPDATE STATISTICS ? WITH FULLSCAN' but i can still see the fragmenation as below

IndexTypeavg_fragmentation_in_percent

CLUSTERED INDEX ...

Yes I ran the query on physical server where linked server is configured but it keeps running without giving any result once I cancelled it after two hours run. But...