We are using a SQL server instance for hosting the Cognos analytics Content Store.
Yesterday we started experiencing some memory problems with Queries made on the content store. Those queries are related to cognos security management and they all ended up failing with "waiting semaphore" status.
It seems that our server hosting this SQL server instance does not have enough memory to run the request.
After looking around for guidelines regarding memory requirements for content store hosted on a SQL server instance, I found nothing.
Could somebody tell me where I could find such information?
Thanks
Quote from: vigc0 on 27 Nov 2018 05:27:29 PM
We are using a SQL server instance for hosting the Cognos analytics Content Store.
Yesterday we started experiencing some memory problems with Queries made on the content store. Those queries are related to cognos security management and they all ended up failing with "waiting semaphore" status.
It seems that our server hosting this SQL server instance does not have enough memory to run the request.
After looking around for guidelines regarding memory requirements for content store hosted on a SQL server instance, I found nothing.
Could somebody tell me where I could find such information?
Thanks
Hi,
This would be a database server sizing exercise. You know the size of your database, and you can also get a good feel for the number of concurrent requests being made to it. I googled SQL Server memory sizing, and the below link came up as a hit:
https://blog.heroix.com/blog/how-much-memory-does-microsofts-sql-server-need
Good luck!
MF.