For example, you can exclude a specific SQL statement when it is run by a certain user, or you can exclude all SQL statements coming from a user on a certain computer. With this method, you can exclude statements that come from a certain program, user, host, or a combination of factors. ![]() Modify the WHERE clause of the DPA quickpoll query to prevent DPA from collecting information about SQL statements that meet certain criteria. Option 3: Exclude SQL statements from collection based on criteria in the WHERE clause Charts, tuning advisors, and reports that represent time periods after you ran the SQL statementĬharts, tuning advisors, and reports that represent periods before you ran the statementĭPA charts and advisors for the exclusion period do not show data about the statement because that data is not stored in the DPA repository database.Data about the statement is excluded from: This option for excluding SQL statements requires admin privileges. The excluded SQL statement is identified by its DPA hash value. Run a statement against the DPA repository database that prevents DPA from storing the data that it collects about the specified SQL statement. Option 2: Prevent DPA from storing data about a specific SQL statement With this method, DPA continues to collect and store data about the SQL statement, and so the data is available. Higher wait times would be normal during that period.ĭPA charts and advisors for the exclusion period show data about the excluded statement again. If the statement runs on a regular schedule with a predictable amount of wait time, it would not cause DPA to detect an anomaly during the period when it runs. Charts that represent less than one day.All tuning advisors, including those generated for previous periodsĭata about the statement is still included in:.All DPA Trends charts that represent one or more days, including charts that represent previous periods.When you exclude a statement from tuning advisors, DPA does not generate query advisors for it or consider it when generating table tuning advisors.ĭPA recommends using this method if possible because it is safe (there is no risk of losing data) and easy (it is done through the interface). Use the SQL Properties dialog box to exclude the selected SQL statement from DPA Trends charts, DPA tuning advisors, or both. Option 1: Exclude a specific SQL statement from DPA charts and analysis If the exclusion is reverted, DPA charts and advisors for the exclusion period show data about the excluded statement againĮxcludes SQL statements from all DPA views and analysis, including reports and anomaly detectionĮxclusion criteria is not restricted to the hash value or ID of one SQL statement View All Application Management ProductsĮxcludes the SQL statement from both past and future charts and advisors.View All IT Service Management Products. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |