Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Unanswered

SQL Server Licensing

Posted on by 155

We have 38 Licenses for GP 2018. But we face some timeout issue and doubting that this is related to SQL User Call.

Could anyone explain what is the exact SQL Server requirement for these 38 users. We already have license for SQL Server Stand Edition 2016 .

Thanks in Advance  

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SQL Server Licensing

    I use indexes in SQL https://codingsight.com/clustered-and-non-clustered-index-7-top-points-explained/ This boosts the database a lot. Maintaining indexes is part of the maintenance of a database and is part of optimizing response time for queries hitting the database.

  • Bryan7425 Profile Picture
    Bryan7425 5 on at
    RE: SQL Server Licensing

    When licensing the SQL Server 2019 Standard Edition software under the Server+CAL model, customers purchase a server license for each server, and a client access license (CAL) for each device (Device CAL) and/or user (User CAL) accessing SQL Server or any of its components.

    krogerfeed

  • Rashid C Profile Picture
    Rashid C 155 on at
    RE: SQL Server Licensing

    Thanks for your reply.

    Timeout is happening certain times. I am watching the issue and could not trace it. Let me go through the link you have provided.

    I will get back to you.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: SQL Server Licensing

    SQL Server CALs have nothing to do with time out issues. You need to look at the type of users and what they do all day long. Are they running reports either in GP or SSRS. Running historical aged trial balance reports puts a heavy load on your server. You need to monitor your server and check the performance. Do these timeouts occur at certain times of the day? Are you maxing out your CPU or memory or disk access? Are you running software RAID? If you are get rid of it. There are plenty of SQL performance monitoring tools out there. Here are a few tips.

    docs.microsoft.com/.../performance-monitoring-and-tuning-tools

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,556 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,625 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans