Course Hero Logo

The following are some of the tools available in ms

Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e.g., in search results, to enrich docs, and more. This preview shows page 88 - 94 out of 121 pages.

The following are some of the tools available in MS SQL server that aid in system monitoring andperformance optimization: -Extended EventsThe extended events structure in SQL Server allows users to gather as much or as little data as theyneed to debug or detect a performance issue. Extended Events is very flexible and scalable. It's asimple performance monitoring tool that consumes very little processing power. The new sessionwizard and new session provide two graphical user interfaces for creating, modifying, displaying,and analyzing your session data. I've put together a report on how to use extended events in anLibrary management system, which you can find below: -Step 1: Firstly, open the Sql server. After the Sql server has been opened, expand management of theobject explorer which have extended event. Finally, as illustrated in the figure below, open theextended events options to find another option, Sessions.
Database Management Systems2021Anusha Kunwar (HND / Fourth Semester)89Step 2: Right click on the sessions to add new session wizard as shown in the figureStep 3: Following the selection of the new session wizard option, a dialog box similar to the onebelow will display, allowing us to create events for troubleshooting and performance analysis. Toproceed to the next choice, set session properties, select the next option.Step 4: In this dialog box, we must enter the event's session name. For this instance, I've given it thename of the system, i.e., Library System, and then click Next.
Database Management Systems2021Anusha Kunwar (HND / Fourth Semester)90Step 5: Since we won't be using a session template for this event, pick the don't use template optionand the next button.
Database Management Systems2021Anusha Kunwar (HND / Fourth Semester)91Step 6: Now we can choose the type of event we wish to monitor, such as a database being dropped,a database being created or a database file being modified. If the specified events occur, we will benotified, and if they are undesirable, we will be able to take the necessary action immediately.Step 7: Then we can gather global fields that are identical to every event in the capture global fields
Database Management Systems2021Anusha Kunwar (HND / Fourth Semester)92section. We can pick and choose the global fields we want to gather throughout this event session.Step 8: Whenever we wish to analyze the events later or take action after seeing them, we may usethis functionality to save data to a file for later analysis.Step 9: If we're to check if our selections for this event session are right during setting up the eventwizard, we can do so in this dialog box. By choosing the finish option, we can make the event if all
Database Management Systems2021Anusha Kunwar (HND / Fourth Semester)93of the steps are valid.

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 121 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Fall
Professor
N/A
Tags
Wind, Relational model, Database management system, Database model

Newly uploaded documents

Show More

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture