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
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
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.
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
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.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 2,047
André Arnaud de Cal... 885 Super User 2025 Season 2
Sohaib Cheema 592 User Group Leader
