Update or create database

Last updated 11 November 2020.

The V8 Search XE database (also called the data repository) is a SQL Server database that stores data about your SQL Servers. It must be on SQL Server 2017 or 2019.

 General information
Estimating the size of the database

The V8 SQL database uses up to 1000 MB per V8 XE Profiler Session to monitor a Dynamics NAV/BC Server instance that is connceted a SQL Server. For example, monitoring ten Dynamics NAV/BC Server instances for 30 minutes will increase the V8 Search XE database by 10GB.

We recommend you set fixed autogrowth and transaction log size relative to your database size. For more information, see Manage the Size of the Transaction Log File (MSDN).

 Using virtual machines

If you host the V8 SQL database on a virtual machine, make sure the V8 SQL database is installed on a physical disk mapped to that virtual machine.

We don't recommend you store the V8 Search XE database on a virtual disk, as this will affect performance. Instead, store it on a physical disk.


 Connection details

For the V8 Search XE database, you can either:

The account you specify details for must have administrator privileges (db_owner database role) on the V8 Search XE database. 

You can connect using Windows authentication or SQL Server authentication.

 Connecting with Windows authentication
  • V8 Search XE assumes the account is in the current domain. To use a different domain account, enter credentials in the format username@domain-name or domain-name\username

  • If the Windows account doesn't have Log on as Service permissions, V8 Search XE will automatically attempt to grant them to the account.

  • The Windows account you select will also be used to run the V8 service. If the account doesn't have permissions to run a Windows service, it will be granted these permissions.

 Connecting with SQL Server authentication
  • The V8 Job service will run under the Local Service account. For more information, see the MSDN documentation.

 Using an existing database
  1. Connect with your V8 Search XE. If the installed V8 database is older than required for the new client, the following message appears:


     

  2. Click Yes.

  3. A dialog with all release information opens. Click on the "update" button in the upper left corner. The existing V8 SQL database will then be updated.


     


    Note that you need to choose either an empty database or a database that was created during a previous V8 Search XE installation.

  4. After successful update the following message appears:


     


 Using a database created by V8 Search XE client

Permissions

To create the V8 Search XE database, you need an account with Create Database permissions on the specified server. This account is only used to create this database; V8 Search XE doesn't save the credentials.

If you don't have a login for the SQL Server with the right permissions, use the sp_addsrvrolemember stored procedure to assign a login to the dbcreator role. For more information about this stored procedure, see the MSDN documentation.

If you don't have a login for the SQL Server with the right permissions, use the sp_addsrvrolemember stored procedure to assign a login to the dbcreator role. For more information about this stored procedure, see the MSDN documentation.

If the error is about permissions, make sure you have Create Database permissions on the specified SQL Server.

Connect to the SQL Server
Summary: in this tutorial, you will learn how to connect to SQL Server from the V8 Search XE Client and create a new SQL server database for V8.

  1. First, launch the V8 Search XE from the Start menu:

  2. Next, from the Connect menu, choose "Data" …


     

  3. When you click the File tab (far left), the V8 Search XE Backstage view is displayed. It is used to manage files and file-specific data, such as creating, saving, checking for hidden metadata or personal information, and setting options.

  4. Next, from the Backstage view, choose "Recent SQL Connections" (1) and press the "Add+" button (2) to create a new SQL Server connection.


     


     

    1. Please select "Microsoft SQL Server (SqlClient)".
    2. Enter the name of the SQL server instance where you want to install the V8 Search XE database.
      • To use the Windows account that you're currently logged into, select Use current credentials.
      • To use a different account, select Specify an account. If you select Windows authentication, V8 Search XE assumes the account is in the current domain. To use a different domain account, enter credentials in the format username@domain-name or domain-name\username.
      • You can select a SQL Server from the drop-down menu, or type the instance name or IP address directly into the server box.
    3. Select the "master" database from the drop-down list.
    Then, enter the information for the Server name (localhost), Authentication.

    Check the Checkbox "incl. System-database".

    Select the "master" database from the drop-down list.

  5. An error message appears the first time you run it. Click "OK".
    This error message means that the client is not connected to the V8 database.
    It is not yet available!


     

  6. Use the steps below to create a database called  "V8SearchXE" :

  7. If the connection is established successfully, then you will see the following:


     

  8. Select SQL Server > Creat Database:

    In the Backstage View select SQL Server Panel and click the button "New SQL DB".


     

  9. Under New database, do not enter a database name (default V8SearchXE).


     

    To change the default values of primary data and transaction log files, click the appropriate cell in the Database Files pane and type the new value.


     


     

  10. Create now. Click OK.

  11. After successful update the following message appears:


     

  12. Click OK. Then click on Close.

  13. V8 Search XE Client needs to save some connection details to connect to the V8 SQL database.

  14. From the Connect menu, choose the Close (Disconnect to Server)…

  15. Next, from the Connect menu, choose the Open (Connect to Server)…

    Select the "V8SearchXE" database from the drop-down list.

    After you complete all the fields, click Connect.


     

  16. An error message appears the first time you run it. Click "OK".
    This error message means that the client is not connected to the V8 database.
    It is not yet available!


     

  17. Use the steps below to create a database called  "V8SearchXE" :

  18. If the connection is established successfully, then you will see the following:


     

  19. Select File > Setting:

    Select the new database "V8SearchXE" from the drop-down list, as shown here.


     

    Select the new database "V8SearchXE" from the drop-down list, as shown here.

    Then click on ok first (this will change the current connection of the client. Then click on the button with the exclamation mark.


     

  20. This saves the SQL connection of the V8 client with the V8 database. This connection is now used every time the client is started to save analysed data in the V8 database.
    Now restart the v8 client to use the new SQL connection.

V8 Search XE. Designed and built by Olav Treffurt IT Consulting. Copyright © 2021 DynamicsProject.com. All rights reserved.

Trademarks
Microsoft, Microsoft Dynamics, Microsoft Dynamics NAV, Dynamics 365 Business Central, Windows, Windows Server, and the other products listed on the trademarks page of the Microsoft website are trademarks of the Microsoft group of companies. All other trademarks are property of their respective owners.