Spatial Index Stored Procedures (Transact-SQL)
SQL Server supports the following system stored procedures that are used to analyze and improve the indexing performance of spatial indexes.
SQL Server supports the following system stored procedures to help pick the correct spatial index parameters.
sp_help_spatial_geography_histogram (Transact-SQL)
sp_help_spatial_geometry_histogram (Transact-SQL)