In this video, learn about how to limit analysis to particular databases, applications, and performance categories with SQL Doctor.

Transcript

Expand

With SQL Doctor, you can identify problems and misconfigurations on a SQL instance. And provide recommendations and options for fixing those problems. Today we will talk about how to limit analysis to specific databases and performance categories. Before we start an analysis, we can select the settings that will allow you to block recommendations you do not want to see in the report. This is also a great way to see all of the recommendations that SQL Doctor offers. Sort by categories to see all of the recommendations in that category. Moving to the next tab. Blocking databases. We can now block those databases that you do not need recommendations. Once you have selected your options, you can run the analysis. Once you view an analysis, you have another opportunity to block recommendations. Let us say you do not want to see recommendations about backups that are on the same volume. Simply select the recommendation. Click block. Select whether you want to block the recommendation completely or just a recommendation for that specific database. You can also limit your analysis to specific applications. Filter by wildcard in all the target-specific databases. This option is called filters. And it is presented to you in the analysis wizard. Filter by application here. And limit the analysis to the database here. SQL Doctor can be downloaded from the IDERA web site at www.idera.com. In our community at community.idera.com, there is a lot of different users that are ready to answer some of your questions. Thank you, and have a great day.

Topics : Database Performance,Database Security,

Products : SQL Doctor,

How To Limit Analysis to Particular Databases and Applications with SQL Doctor

SQL Doctor diagnoses and provides the cure for what ails your SQL Server on-premise, in the cloud, and as a managed cloud database.SQL Server administrators, developers, and analysts are under intense pressure to maintain high levels of database and application performance. Diagnosing and resolving performance issues can be an overwhelming and time-consuming task. SQL Doctor retrieves all of the necessary information, analyzes the results, pinpoints potential problems, and provides ranked recommendations that help you to resolve those issues on your instances. Whether you are a novice or expert at performance tuning, SQL Doctor makes your daily tasks easier. In this video, learn about how to limit analysis to particular databases, applications, and performance categories with SQL Doctor. Learn   More →

facebook  
Contact IDERA: