<div>
I would advise to use using&nbsp;AzureSQLMaintenance&nbsp;stored procedure instead which is a custom stored procedure developed by Microsoft’s&nbsp;<a href="https://blogs.msdn.microsoft.com/azuresqldbsupport/2016/07/03/how-to-maintain-azure-sql-indexes-and-statistics/" style=" text-align: start;" rel="ugc nofollow">Yochanan Rachamim</a> from Ola's as noted here <a href="https://techcommunity.microsoft.com/t5/azure-database-support-blog/how-to-maintain-azure-sql-indexes-and-statistics/ba-p/368787" id="isPasted" rel="ugc">https://techcommunity.microsoft.com/t5/azure-database-support-blog/how-to-maintain-azure-sql-indexes-and-statistics/ba-p/368787</a> as it is suitable for Azure SQL and compatible with its supported features comparing to Ola's code which is best suited for on-prem SQL Servers.<a href="https://www.sqlshack.com/automate-azure-sql-database-indexes-and-statistics-maintenance/" id="isPasted" rel="ugc">https://www.sqlshack.com/automate-azure-sql-database-indexes-and-statistics-maintenance/</a>
</div>

<div>
Hello I know that thank you but it takes more 4 hours.I search another solution Thank you&nbsp;
</div>

bibi92

<div>
&nbsp;AzureSQLMaintenance&nbsp;is not Ola hallengren's procedure&nbsp;Thank youBest regards&nbsp;
</div>

<div>
<div class="content wysiwyg-content fr-view">
Hello, Below query from Ola hallengren's procedure IndexOptimize doesn't finish on Azure VLDB database :&nbsp;SELECT @ParamFragmentationLevel = MAX(avg_fragmentation_in_percent), @ParamPageCount = SUM(page_count) FROM sys.dm_db_index_physical_stats(DB_ID(@ParamDatabaseName), @ParamObjectID, @ParamIndexID, @ParamPartitionNumber, 'LIMITED') WHERE alloc_unit_type_desc = 'IN_ROW_DATA' AND index_level = 0 How to resolve ? Thank you&nbsp; Best regards&nbsp; 
</div>
</div>


Hello,
Below query from Ola hallengren's procedure IndexOptimize doesn't finish on Azure VLDB database : 
SELECT @ParamFragmentationLevel = MAX(avg_fragmentation_in_percent), @ParamPageCount = SUM(page_count) FROM sys.dm_db_index_physical_stats(DB_ID(@ParamDatabaseName), @ParamObjectID, @ParamIndexID, @ParamPartitionNumber, 'LIMITED') WHERE alloc_unit_type_desc = 'IN_ROW_DATA' AND index_level = 0
How to resolve ?
Thank you 
Best regards 


I would advise to use
using 
AzureSQLMaintenance
 stored procedure instead which is a custom stored procedure developed by Microsoft’s 
Yochanan Rachamim
from Ola&#39;s as noted here
https://techcommunity.microsoft.com/t5/azure-database-support-blog/how-to-maintain-azure-sql-indexes-and-statistics/ba-p/368787
as it
is suitable for Azure SQL and compatible with its supported features comparing to Ola&#39;s code which is best suited for on-prem SQL Servers.
https://www.sqlshack.com/automate-azure-sql-database-indexes-and-statistics-maintenance/


Hello
I know that thank you but it takes more 4 hours.
I search another solution
Thank you 


 
AzureSQLMaintenance
 is not
Ola hallengren&#39;s procedure
 
Thank you
Best regards 

IndexOptimize takes long time on azure VLDB database


Hello,
Below query from Ola hallengren&#39;s procedure IndexOptimize doesn&#39;t finish on Azure VLDB database : 
SELECT @ParamFragmentationLevel = MAX(avg_fragmentation_in_percent), @ParamPageCount = SUM(page_count) FROM sys.dm_db_index_physical_stats(DB_ID(@ParamDatabaseName), @ParamObjectID, @ParamIndexID, @ParamPartitionNumber, &#39;LIMITED&#39;) WHERE alloc_unit_type_desc = &#39;IN_ROW_DATA&#39; AND index_level = 0
How to resolve ?
Thank you 
Best regards 

Microsoft Azure is a cloud computing platform and infrastructure for building, deploying and managing applications and services through datacenters. It provides both platform-as-a-service (PaaS) and infrastructure-as-a-service (IaaS) services and supports many different programming languages, tools and frameworks, including both Microsoft-specific and third-party software and systems. Cloud Services is a PaaS environment and can be used to create scalable applications and services; there are specific software development kits (SDKs) provided by Microsoft for Python, Java, Node.js and .NET. Azure also has file and storage services, data management, analytics and DNS services.

Azure

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.