title: Implementing Table partitioning in SQL server having alwayson setup
body: <p>I am working on Table partitioning on selected tables. It is working fine in lower environments as the environments are pretty simple with single SQL server in each environment.
  My production environment is using AlwaysOn setup for High availability with one primary and one secondary node. I stormed my brain to implement table partitioning in such environment and came across below possible implementations and corresponding problems:</p>
  
  <ol>
  <li>Turn off AlwaysOn from Primary-> Implement partitioning on Primary-> (Ask: If I turn on AlwaysOn on primary, will the partitions get reflect in secondary?)</li>
  <li>Without turning off AlwaysOn from Primary apply partitioning on Primary (Ask: Is it possible? If yes, will the partitions get reflect in secondary and what will be the possible impact on performance?)</li>
  </ol>
  
  <p>Thanks in advance.</p>