AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
![]() ![]() NOTE: Both sets accomplish the same change. ![]() Navigate back to Agent Status (Administration | Agents | Agent Status or by clicking the Agent Status link in the top right corner of the page).Increase the query timeout to 300 seconds.Click the number in the row Query timeout for on-demand collections.Scroll down the Collection Details area.Click on the link to modify the private properties for the agent.Click on Edit and then Edit Properties in the menu.Place a checkbox next to the SQL Server agent that has the issue.Navigate to Administration | Agents | Agent Status Command: UPDATE STATISTICS WASys00000006151B244E Msg 50000, Level 16, State 1, Server BIDSSql, Procedure CommandExecute, Line 1, Lock request time out period exceeded.To increase the Query Timeout for On-demand collections using the Agent Status Properties Click the number next to Query timeout for on-demand collections.Click Settings and then Administration in the menu.Navigate to the Global View main databases dashboard.Increase the query timeout for on-demand collections SQL_Server_Reporting_Services_History_General.SQL_Server_Reporting_Services_Reports_by_status.SQL_Server_Reporting_Services_top_active_users. ![]() An error occurred while processing the log for database.
0 Comments
Read More
Leave a Reply. |