System.Exception: Error "The query processor could not start the necessary thread resources for parallel query execution. Reduce load on the server or use the MAXDOP setting to limit parallelism." creating datatable from "exec spGetPetsListForMating_v10012022 @PetTypeId='1',@BreedId='94',@CityId='226',@Gender=' ',@variety=' ',@AgeFromDays='0',@AgeToDays='0',@sortOrder='desc',@sortColumn='CreateDate',@budget='500000',@flag = '1',@userid = '0'" tagged as "Select pet list". ---> System.Data.SqlClient.SqlException: The query processor could not start the necessary thread resources for parallel query execution. Reduce load on the server or use the MAXDOP setting to limit parallelism.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows)
   at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
   at System.Data.SqlClient.SqlDataReader.Read()
   at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
   at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
   at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at Mmp.DBTool.DBGeneralPurposeDataTable(SqlCommand CommandObj, String TroubleshootingTag, Boolean KeepConnectionOpen) in c:\HostingSpaces\Mrnmrspet\mrnmrspet.com\wwwroot\App_Code\DBTool.cs:line 278
   --- End of inner exception stack trace ---
   at Mmp.DBTool.DBGeneralPurposeDataTable(SqlCommand CommandObj, String TroubleshootingTag, Boolean KeepConnectionOpen) in c:\HostingSpaces\Mrnmrspet\mrnmrspet.com\wwwroot\App_Code\DBTool.cs:line 289
   at Mmp.DBTool.DBDataTable(String CommandText, String TroubleshootingTag) in c:\HostingSpaces\Mrnmrspet\mrnmrspet.com\wwwroot\App_Code\DBTool.cs:line 196
   at pet_breeding_services_pet_type_breeds_city.FillListForPet(Int32 Id, Int32 PetTypeId, Int32 BreedId, String CityId, String Variety, String Gender, Int32 AgeFromDays, Int32 AgeToDays, String OrderBy, String Expression, Int32 flag) in c:\HostingSpaces\Mrnmrspet\mrnmrspet.com\wwwroot\pet-breeding-services-pet-type-breeds-city.aspx.cs:line 392
   at pet_breeding_services_pet_type_breeds_city.BindDataListForPet(Int32 Id, Int32 PetTypeId, Int32 BreedId, String CityId, String Variety, String Gender, Int32 AgeFromDays, Int32 AgeToDays, String OrderBy, String Expression, Int32 flag) in c:\HostingSpaces\Mrnmrspet\mrnmrspet.com\wwwroot\pet-breeding-services-pet-type-breeds-city.aspx.cs:line 330
   at pet_breeding_services_pet_type_breeds_city.Page_Load(Object sender, EventArgs e) in c:\HostingSpaces\Mrnmrspet\mrnmrspet.com\wwwroot\pet-breeding-services-pet-type-breeds-city.aspx.cs:line 149
   at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
   at System.Web.UI.Control.OnLoad(EventArgs e)
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Exception of type 'System.Web.HttpUnhandledException' was thrown.
   at System.Web.UI.Page.HandleError(Exception e)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest()
   at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
   at System.Web.UI.Page.ProcessRequest(HttpContext context)
   at ASP.pet_breeding_services_pet_type_breeds_city_aspx.ProcessRequest(HttpContext context) in c:\Windows\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files\root\c0c82262\3b657ffb\App_Web_dpxzaxlo.20.cs:line 0
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)