do we need to have quorum for using always on feature??

It happens when the log reader agent /distribution agent are running slow. They will not get lost. They will get applied to the subscriber database in order. If they don't...

Actual and estimated execution plan details are same in both environments.

Can any one please provide what should i be looking next.

The tables are very small not more than 10,000 rows.

I am not finding the actual rows in the execution plan. So if they are not present then what does that mean?

@vultar

Was the proc in live taking 7 mins repeatedly or was it just the one occurrence ?

-- it was taking repeatedly more than 7mins to execute and...

Its a View- and view is created with 4 tables joins.

@andrew:

The query is running from .net application. But when the application running in staging it is fetching the data immediately but in production it is giving us the...

check for the query which is taking longer time to execute and do the performance tuning.

Or check for wait type of the query-

DO some performance tuning -if required do...

Steve,

Can you help me to find that article or elaborate on that technique which you are referrring to?

current size of the database is 2.36 TB. Monthly around 100 GB of data will be added to this partitioned table. We can increase the drive size by adding more...

Perry,

I was wrong. I can see the difference in the file property window. Do you suggest to go for such process? What's your opinion on compressing files ?

I used the command COMPACT /C /S source destination to compress all the read file groups. It worked fine. But I need...

replication

All the websites work when we do manual failover- so i can confirm that there is no issue with logins or orphan users.

1. Are the connection strings for each server dependent on the primary configured to use the failover server?

Yes each web application has its own Connection string mentioned as below

Initial Catalog=Northwind;server=Primarysql;Failover...