Geek Dashboard

How-To's, Smartphones, News and Reviews

  • Home
  • News
  • Smartphones
    • Android
    • iOS
  • Computers
    • Windows
    • macOS
  • Internet
  • Reviews
You are at Home » Computer

How Can You Run Database Tuning Through The Workload Process?

Last Updated on March 27, 2020 by jennyrichards 4 Comments

Tuning the database signifies that particular cluster of activities where the optimization can take place regarding the performance of the database. The Workloads can be used for database tuning by the Database Engine Tuning Advisor or by the DTA Utility. The transact-SQL statements oppose the database that needs to be tuned. You need to follow some simple steps to create the workload process for the database tuning.

Workloads

 

Image Credit : www.novell.com

Creating The Workloads:

When you are using the SQL Server profiler, you can easily generate the trace file and also the trace workloads.

  • You can go to the START menu , from there All Programs > MS SQL Server > Performance Tools and then finally select the SQL Server profiler
  • You can also go to the Tools menu and then to the SQL Server Profiler from the SQL Server Management Studio

After launching the SQL Server profiler, you can easily create the trace table or the file using the tuning template.

Tuning The Database:

As mentioned earlier, the database can be tuned in both ways, by the graphical user interface Database Engine Tuning Advisor or by the DTA Utility.

2db

Image Credit : www.quazoo.com

By Database Engine Tuning Advisor:

Step 1:

You need to settle on the database features in the initial stage. You may decide whether you need the advisor to modify or remove your scrutiny.

Step 2:

After that you have to create the workloads.

Step 3:

Then introduce the Database Engine Tuning Advisor and sign into the MS SQL Server.

Step 4:

For creating the new session, you can just type a name in the section of Session name of the General tab.

Step 5:

You can select either a file or a table for your workload as required.

Step 6:

In this stage you can select the database table by clicking on the arrow of Selected Tables.

Step 7:

You can save a copy of the tuning log for future references.

Step 8:

You can select the best tuning options from the available list.

Step 9:

Finally you may start the analysis by selecting the Start Analysis from the toolbar.

If you want to resume the action of the analysis you can immediately select the Stop Analysis or Stop Analysis (With Recommendations).

3start_mysql_utilities1

Image Credit : scriptingmysql.wordpress.com

By Using The DTA Utility:

When you are using the default settings of the DTA Utility, you need to determine the database feature, and then create the workload. After that the command can be provided with the database name, ID and password. Tuning can also be done within a specified duration and a name for a remote database. XML input file can also be essential if you are tuning with the DTA Utility function.

Viewing The Tuning Output :

For the purpose of viewing, the Session Monitor Window can be selected. If the existing session has been introduced or the new sessions of tuning are complete, the page of Recommendations will appear in front of you. You may either select the Partition Recommendations or the Index Recommendations. You can also save all the recommendations for your future reference from the Action menu. You can have a look on all the analysis and the reports of the GUI Database Engine Tuning Advisor.

Therefore, you can create the exclusive reports and analysis by implementing all the tuning recommendations. Regardless of the user interface you are using, you can definitely go forward for database tuning if you are aware of the process of tracing tables, files, and SQL statement through the workload process. If you are satisfied with your SQL server, you are all set for the process of database tuning.

#Database#Database Tuning#MS SQL#Workloads
Posted inComputer

Spread the Word!

Avatar for jennyrichards

jennyrichards

Jenny Richards is working as a DBA for the last 5 years. In her career she is worked mostly on Oracle 9i, Oracle 10G, DB2.

Comments

  1. Avatar for David WicksDavid Wicks says

    February 7, 2015 at 7:14 AM

    Database Tuning? Wow Nice topic to read. I have gone through the post carefully found it really helpful as it describes about the database and database tuning very clearly and fluently. I feel that this post helpful to persons like remote dba experts even though they have better knowledge of database tuning. Thanks for the post.

    Reply
  2. Avatar for Sujain ThomasSujain Thomas says

    January 20, 2015 at 6:37 AM

    Perfect write and thumps up for the article on running the database. I have a team of friends who look to hire dba experts and I was recently looking for an article which can help me when it is workload. Thank you for such useful article I hope that you will keep sharing such useful information.

    Reply
  3. Avatar for MathewMathew says

    January 14, 2015 at 12:40 PM

    Thank you very much Jenny for sharing such a nice article on database and workload process. I really found it very interesting. I like the way you have mention the 10 steps. I have read many such blogs on and found some interesting information on remote dba experts. Great article by the way. Keep sharing.

    Reply
    • Avatar for Amar IlindraAmar Ilindra says

      January 16, 2015 at 1:30 PM

      Most Welcome. Keep visiting.

      Reply

Comment Policy:

The comments section is aimed to help our readers in case of any questions or you can even appreciate us for our hard work. Every comment is strictly moderated before approving it.

Your name and comment will be visible to the public. Never share your personal information in the comments section.

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Over 1,30,286+ Followers

Join to get latest updates from Geek Dashboard

Facebook Twitter Telegram Pinterest YouTube Instagram

Recently Published

  1. Tecno Spark Go (2023) Launched with MediaTek Helio A22 SoC and Dual Cameras in India

  2. Creating Social Media Visuals: 9 Tips, Tricks, and Tools

  3. Hum to Search: 5 Best Music Recognition Apps to Find a Song by Humming

  4. Fire-Boltt Talk Ultra With Bluetooth Calling and 123 Sport Modes Launched in India

  5. Wikolo Super App: Bringing Countless Benefits for Students

Geek Dashboard Placeholder

Download the apps and never miss a story from us

We put a lot effort and resources in writing our articles and we believe it is our responsibility to satisfy your tech hunger. We will keep you filled forever!

  • Get Geek Dashboard App from Google Play
  • Get Geek Dashboard App from Chrome Web Store
Geek Dashboard Logo

At Geek Dashboard, we are dedicated to bringing you the latest and greatest in technology news, reviews, and how-to guides. From smartphones to laptops, and everything in between, we've got you covered.

Got a Tip? Write In tip@geekdashboard.com

© 2012 - 2023 · Geek Dashboard, product of ikva eSolutions

Blog Advertise About Jobs Contact Privacy Policy Write For Us T&C Office Setup

No dogs were injured while working on this website because we love them